Usage

Use this report to see information about the chronology of SQL requests that were sampled over the duration of the measurement and to identify any calls with excessive service times. Each line shows information about one SQL call. By default, the detail lines are sorted chronologically by DB2® thread. You can also request that the data be sorted in descending sequence by SQL call duration. Enter the “SD” line command on the “Threads” heading field to sort in this sequence. This will bring to the top of the report any SQL calls that might have had excessive service times.

When the DB2+ feature is active for a measurement, the number of SQL calls displayed in this report is limited by the value of the DB2IMaxTraceSize parameter specified during Application Performance Analyzer installation, or by the value on panel 2 of the measurement request (if your installation has configured this field). The report is truncated when the number of SQL calls issued reaches the value specified for DB2IMaxTraceSize.