Viewing parallel activity for an exception
Follow these steps to view parallel activity for an exception.
Procedure
- On the DB2 Query Monitor main menu, type 5 in the Option field and press Enter.
- Locate the exception for which you want to view parallel activity.
-
Type P in the CMD field next to the SQL activity of interest and press
Enter.
The Parallel Task Statistics panel is displayed:
Figure 1. Parallel Task Statistics panel YYYY/MM/DD HH:MM:SS ---- Parallel Task Statistics ------- Row 1 of 2 Option ===> ________________________________________________ Scroll ===> PAGE DB2 SSID: DB01 Plan: PLAN001 DBRM: DBRM001 Coll: DSNTEP2 Cursor: C1 Section: 1 ------------------------------------------------------------------------ > CMD SSID Plan Program DB2 CPU Time DB2 Elapsed GETPAGES SQLCODE - ---- -------- -------- -------------- -------------- -------------- ------- _ QM01 PLAN001 DBRM001 2.741308 30.556241 19,346 0 _ QM01 PLAN001 DBRM001 3.636054 30.602641 25,475 0 ***************************** Bottom of Data **********************************