DB2SQL category in C01 report

More DB2® measurement data is presented in the C01 CPU Usage by Category report, under the category DB2SQL. If you expand the DB2SQL with the “+” line command, SQL Statement items will be displayed.

A sample is shown here:

  File  View  Navigate  Help
--------------------------------------------------------------------------------
C01: CPU Usage by Category (0645/CICS23A)                     Row 00001 of 00014
Command ===> __________________________________________________ Scroll ===> CSR 

Name      Description             Percent of CPU time * 10.00%  ±2.6%
                                      *....1....2....3....4....5....6....7....8.
SYSTEM    System/OS Services     76.39 ======================================
DB2SQL    SQL Processing         17.02 ========
→ 00008     PFSAMPC(1466) FETCH   8.00 ====
→ 00003     PFSAMPB(408) SET HOS  2.10 =
→ 00010     PFSAMPB(816) UPDATE   2.03 =
→ 00004     PFSAMPC(1316) SELECT  1.56 =
→ 00006     PFSAMPC(1347) SELECT  0.94
→ 00002     PFSAMPB(678) SELECT   0.67
→ 00001     PFSAMPA(816) SELECT   0.67
→ 00007     PFSAMPC(1443) OPEN    0.61
→ 00009     PFSAMPC(1562) CLOSE   0.40

APPLCN    Application Code        6.58 ===

You can enter the “+” command to further expand each SQL statement one more level to display a breakdown by load module.

SQL Statement

This item attributes measured activity to a DB2 SQL statement.

Name Column: A sequence number is assigned by Application Performance Analyzer to each unique SQL statement observed during the measurement. This sequence number is shown in the name field. It is possible for some sequences numbers to be missing (sequence gaps) from the report. This will occur if a sequence number was assigned to SQL statements but no CPU activity was measured for these statements.
Description Column: The name of the program that issued the SQL request followed by the precompiler statement number (enclosed in parentheses) is shown here. This is followed by the SQL function (e.g. SELECT, INSERT, COMMIT).