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 |