Viewing object usage

You can view object usage information for the query activity that is monitored by Db2 Query Monitor.

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 object detail information.
  4. Type S in the CMD field next to the SQL activity of interest and press Enter.
  5. Type O in the CMD field next to the activity of interest and press Enter.
  6. Type X in the CMD field next to the activity of interest and press Enter.
    The Object Usage panel is displayed:
    Figure 1. Object Usage panel
    YYYY/MM/DD HH:MM:SS      ------- Object Usage -------      Row 1 of 1       
 Option  ===>                                                  Scroll ===> CSR  
 QM Subsystem : QM01         Interval Start Date: MM/DD/YYYY  Time: HH:MM:SS
 Filters Enabled : N            Interval End   Date: CURRENT     Time: CURRENT 
 NAVI            : DB2(ST):DB06 -> TBCreator:CQMTOOLZ TBName:TABLE_MGR     
 ------------------------------------------------------------------------     > 
    PLAN     PROGRAM   USER     CORRID       WSUSER                             
    -------- --------- -------- ------------ ----------------                   
    CQMEOPLN CQM01     XXXYYY   XXXYYY       XXXYYY                                    
 ***************************** Bottom of Data **********************************