Usage
Use this report to see information about WAIT time that occurred during the processing of SQL requests. The percentage of time is reported for each module (DBRM) that issued SQL requests and is expressed as the percentage of the total measurement interval.
In addition, a SETUP option lets you choose to see the WAIT time
expressed as a percentage of SQL service time. The two quantification
options help answer these questions about SQL processing wait time:
- For how much of the overall measurement interval was the address space in a WAIT during SQL processing?
- For how much of the SQL processing time was the address space in a WAIT?
You can further expand each module line to see a further breakdown and quantification by individual SQL statements.
Note: This report shows all SQL calls that were sampled,
but when the DB2+ feature is active it will not show SQL calls that
were measured by the DB2+ feature but not sampled.