Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004

    Question Unanswered: DB2DRDAT - Trace Command, need assistance

    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.

  2. #2
    Join Date
    Mar 2004

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts