Viewing parallel activity for an exception

Follow these steps to view parallel activity for an exception.

Procedure

  1. On the DB2 Query Monitor main menu, type 5 in the Option field and press Enter.
  2. Locate the exception for which you want to view parallel activity.
  3. 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 **********************************