DB2 performance analysis reports

This section describes the DB2® Performance Analysis Reports.

For information about ... See ...
The DB2 data extractor Overview of DB2 data extractor
The DB2+ data extractor The DB2+ data extractor
Displaying SQL Statement Text Displaying SQL Statement Text
SQL statement sequence numbers SQL statement sequence numbers
DB2 Multiple Address Space Support Overview of DB2 Multiple Address Space Support
F01 DB2 session statistics F01 - DB2 measurement
F02 DB2 SQL activity timeline F02 - DB2 SQL activity timeline
F03 DB2 SQL activity by DBRM F03 - DB2 SQL activity by DBRM
F04 SQL execution summary F04 - DB2 SQL activity by statement
F05 DB2 SQL activity by plan F05 - DB2 SQL activity by plan
F06 SQL statement attributes F06 - DB2 SQL statement attributes
F07 DB2 SQL wait time by DBRM F07 - DB2 SQL wait time by DBRM
F08 DB2 SQL wait time by statement F08 - DB2 SQL wait time by statement
F09 DB2 SQL wait time by plan F09 - DB2 SQL wait time by plan
F10 DB2 SQL CPU/Svc time by DBRM F10 - DB2 SQL CPU/Svc time by DBRM
F11 DB2 SQL CPU/Svc Time by Stmt F11 - DB2 SQL CPU/Svc time by stmt
F12 DB2 SQL CPU/Svc Time by Plan F12 - DB2 SQL CPU/Svc time by plan
F13 DB2 SQL threads analysis F13 - DB2 SQL threads analysis
F14 DB2 CPU by plan/stored proc F14 - DB2 CPU by plan/stored proc
F15 DB2 SQL CPU/Svc Time by Rq Loc F15 - DB2 SQL CPU/Svc Time by Rq Loc
F16 - DB2 SQL CPU/Svc Time by Enclave F16 - DB2 SQL CPU/Svc Time by Enclave
F17 - DB2 SQL CPU/Svc Time by Corrid F17 - DB2 SQL CPU/Svc Time by Corrid
F18 - DB2 SQL CPU/Svc Time by Wkstn F18 - DB2 SQL CPU/Svc Time by Wkstn
F19 - DB2 SQL CPU/Svc Time by EndUsr F19 - DB2 SQL CPU/Svc Time by EndUsr
F20 - DB2 Class 3 Wait Times F20 - DB2 Class 3 Wait Times
DB2 EXPLAIN report DB2 EXPLAIN report
DB2SQL Category in report C01 DB2SQL category in C01 report