Viewing activity by SQL text

You can view activity for SQL text of interest.

Procedure

  1. On the Db2 Query Monitor main menu, type 1 in the Option field and press Enter.
  2. Select the summary level that you want to view.
  3. Locate the SQL activity for which you want to view SQL activity information.
  4. Type S in the CMD field next to the SQL activity of interest and press Enter.
    The Activity by SQL Text panel is displayed:
    Figure 1. Activity by SQL Text panel
    YYYY/MM/DD HH:MM:SS  ---- Activity by SQL Text ----  Row 1 of 6  
Option  ===>                                                  Scroll ===> PAGE 
QM Subsystem : QM01         Interval Start Date: MM/DD/YYYY  Time: HH:MM:SS 
Filters Enabled : N            Interval End   Date: CURRENT     Time: CURRENT  
NAVI:   Plan:PLAN0123      
CMD - Enter "/" to select action                                                    
---------------------------------------------------------------------------  > 
CMD  SQL Text                                     Exec Count          Calls    
 --  ---------------------------------------- -------------- --------------    
 __  SELECT MIN(E.SALARY)  FROM GLWTEMP E, GLW            12             12
 __  SELECT MIN(E.SALARY)  FROM GLWTEMP E, GLW             1              5
 __  SELECT MAX(EMPTIME)   FROM GLWTEPA                   17             17
 __  SELECT MAX(EMPTIME)   FROM GLWTEPA                    1              5
 __  SELECT MAX(E.SALARY), MAX(D.EMPLOYEE_CNT             29             29
 __  SELECT MAX(E.SALARY), MAX(D.EMPLOYEE_CNT              1              5
***************************** Bottom of Data **********************************

    When you view SQL text for rows that display dynamic text, the Db2, Plan, Program, and Section number columns are blank.