Viewing object statistics for an exception

You can view information about the objects related to an exception.

Procedure

To view object statistics for an exception:

  1. On the IBM DB2 Query Monitor for z/OS panel (the main menu), specify option 5, and press Enter.
  2. On the Display Exceptions panel, issue line command O next to the exception of interest, and press Enter.
    The Object Statistics panel displays object information:
    Figure 1. Object Statistics panel
    YYYY/MM/DD HH:MM:SS  ------- Object Statistics -------          Row 1 of 8         
Option  ===>                                                  Scroll ===> PAGE 
 Filters enabled: N                                               
 DB2 SSID: SS01   Plan: PLAN0001   DBRM: DSNESM68  Coll: DSNESPCS
                  Cursor: C1                  Section:       0   
CMD - Enter "/" to select action
------------------------------------------------------------------------     > 
CMD Creator   Name                Type   DataBase  BPool   PageSet   GetPages   
--- --------  ------------------  -----  --------  ------  --------  --------   
 _  CREATR1   SYSSTMT             TABLE  DATABS1   B04K00  SYSPLAN       1438   
 _  CREATR1   SYSDBRM             TABLE  DATABS1   B04K00  SYSPLAN          1   
 _  CREATR2   PMSYSDBRM1          INDEX  DATABS1   B04K00  PMSYSDBR         2   
 _  CREATR1   SPTR                TABLE  DATABS2   B04K00  SPT01            5   
 _  CREATR1   DSNSPT01            INDEX  DATABS2   B04K00  DSNSPT01         3   
 _  N/A       N/A                 TABLE  DATABS3   B04K00  DSN4K01        180   
 _  CREATR1   SYSPACKSTMT         TABLE  DATABS4   B04K00  SYSPKAGE       464   
 _  CREATR1   DSNKSX01            INDEX  DATABS5   B04K00  DSNKSX01       205   
***************************** Bottom of Data **********************************

    You can use the following line commands as needed to view additional information about any listed object:

    22. B-Buffer Pool Stats
    Show buffer pool statistics for the selected item.