Distributed Relational Database Architecture (DRDA) allows communications between clients and servers among heterogeneous databases. The following set of enhancements have been implemented:
See the DB2 Connect Enterprise Edition Quick Beginnings and DB2 Connect User's Guide for details about the enhancements described in this section.
TCP/IP has been added as a second protocol (the other being SNA) over which DB2 Connect can communicate to host systems. Also, DB2 servers are enabled to accept incoming DRDA connections from the host using TCP/IP. In other words, DRDA Application Requester (AR) and DRDA Application Server (AS) functionality has been implemented using TCP/IP instead of SNA.
DRDA two-phase commit for the DB2 DRDA Application Requester (DB2 Connect) over the TCP/IP communications protocol has been implemented.
In addition, applications running on the host (for example, DB2 for MVS/ESA applications) using SNA can invoke the two-phase commit processing involving both the host and DB2 Version 5 databases.
The ability to execute stored procedures on DB2 for MVS/ESA Version 4.2 is greatly improved. Applications can now receive multiple open cursors from stored procedures executing on DB2 for OS/390 Version 5. Each cursor can have multiple rows.