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.
[ Top of Page | Previous Page | Next Page | Contents | Index ]