DB2 Server for VM: System Administration

Benefits of Using the DRDA Protocol

The DRDA option does the following:

• Makes DB2 Server for VM data accessible to users equipped with the DRDA application requester function. Users on platforms such as OS/2, AIX, OS/400, OS/390, or Microsoft Windows^(TM) can run applications that utilize DRDA remote unit of work or DRDA distributed unit of work processing to access data residing in DB2 Server for VM application servers.
• Enables DB2 Server for VM users to use remote unit of work access to work with data on non-DB2 Server for VM application servers. This allows access to data that would otherwise remain unavailable.

To support this access, application programs can contain SQL statements that are specific to the target system, and both the DBS Utility and ISQL can be run on non-DB2 Server for VM application servers. The SQL statements in these application programs can be static, dynamic, and extended dynamic, even if the target system does not support extended dynamic statements. In addition, portable packages can be loaded on non-DB2 Server for VM application servers.

The DRDA option provides the following additional functions:

• To determine the status of connections in an environment that may have local and remote systems, you can use either the SHOW CONNECT operator command or the SQLQRY CMS immediate command.
• To aid in the diagnosis of errors, first failure data capture is automatically performed. IBM service can use the captured data for diagnosis, decreasing the probability of having to rerun applications to acquire data for diagnosis.
• Another aid in the diagnosis of errors is the LUWID support. The LUWID is a unique identifier associated with each application requester connection. It is composed of four parts: network id, LU name, LUW instance number, and LUW sequence number. This provides additional information that may be required in problem diagnosis.