Good Morning All -

I am currently running DB2 UDB 7.2 fixpack 6. I am connecting to a database on OS/390 DB2 V7.1. I am using the db2drdat trace command to trace my application as it accesses the data on the mainframe db2 tables. I have been successful in generating the trace report. My question is, where can I find documentation that explains how to read the report in detail? I have read the information in the Command Reference manual, but it does not do a good job of explaining all the different fields and their meanings. I am specifically interested in knowing how long it is taking to complete each of the sql requests coming from the application. Any assistance that can be provided would be greatly appreciated. Thank you for your time.

Redbook

The Universal guide to DB2.

There is also a command ddcstrc


At the gateway , you can use the command

list dcs applications extended.

You can turn the monitor switches on and take the snapshot