Viewing SQLCODE information with no grouping
Follow these steps to view SQLCODE information with no grouping.
Procedure
-
On the DB2 Query Monitor main menu, type 2 in the
Option field and press Enter.
The DB2 QM SQL Code Summary panel is displayed:
Figure 1. DB2 QM SQL Code Summary panel YYYY/MM/DD HH:MM:SS ------ DB2 QM SQL Code Summary ----- Row 1 of 2 Option ===> Scroll ===> CSR QM Subsystem : QM01 Interval Start Date: MM/DD/YYYY Time: HH:MM:SS Interval End Date: CURRENT Time: CURRENT Group by A (P-Plan, D-DBRM/Package, A-Authid, S-SQLCode) Specify "*" for no grouping C: S-Select detail, P-Plans, D-DBRMs/Packages, A-AUTHIDs ------------------------------------------------------------------------ CMD Authid Occurrences - -------- -------------- _ USERID1 1 ***************************** Bottom of Data ********************************** -
Type a * in the Group By field and press Enter.
The DB2 QM SQL Code Detail Display panel is displayed:
Figure 2. DB2 QM SQL Code Detail Display panel YYYY/MM/DD HH:MM:SS --- DB2 QM SQL Code Detail Display --- Row 1 of 1 Option ===> Scroll ===> PAGE QM Subsystem : QM01 Interval Start Date: MM/DD/YYYY Time: HH:MM:SS Interval End Date: CURRENT Time: CURRENT C:S-SQL Text, C-SQLCA ------------------------------------------------------------------------ > CMD SSID Timestamp SQLCODE Plan DBRM JOBNAME - ---- --------- ------- ---- ------------- ------- _ SS01 YYYY/MM/DD - HH:MM:SS -204 DSNESPCS DSNESM68 PDUSER ***************************** Bottom of Data **********************************