Trace utility

 

The db2drdat utility records the data interchanged between the DB2 Connect™ server (on behalf of the IBM® data server client) and the host or System i™ database server.

As a database administrator (or application developer), you might find it useful to understand how this flow of data works, because this knowledge can help you determine the origin of a particular problem. Suppose you found yourself in the following situation: you issue a CONNECT TO database statement for a host or System i database server but the command fails and you receive an unsuccessful return code. If you understand exactly what information was conveyed to the host or System i database server management system, you might be able to determine the cause of the failure even if the return code information is general. Many failures are caused by simple user errors.

Output from db2drdat lists the data streams exchanged between the DB2 Connect workstation and the host or System i database server management system. Data sent to the host or System i database server is labeled SEND BUFFER and data received from the host or System i database server is labeled RECEIVE BUFFER.

If a receive buffer contains SQLCA information, it will be followed by a formatted interpretation of this data and labeled SQLCA. The SQLCODE field of an SQLCA is the unmapped value as returned by the host or System i database server. The send and receive buffers are arranged from the oldest to the most recent within the file. Each buffer has:

The remaining data in send and receive buffers is divided into five columns, consisting of:

Parent topic: DRDA traces

Related reference
db2drdat - DRDA trace command