Viewing object details
You can view details about the objects that are accessed by monitored queries.
Procedure
- On the Db2 Query Monitor main menu, type 1 in the Option field and press Enter.
- Select the summary level that you want to view.
- Locate the SQL activity for which you want to view object detail information.
-
Type O in the CMD field next to the SQL activity
of interest and press Enter.
The Object Detail panel is displayed:
Figure 1. Object Detail panel YYYY/MM/DD HH:MM:SS ------- Object Detail ------- Row 1 of 3 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 : DB2(ST):DB06 CMD - Enter "/" to select action ------------------------------------------------------------------------ > CMD Creator Name Type DataBase BPool PageSet GetPages -- -------- ------------------ ----- -------- ------ -------- -------------- __ CREATR1 SYSCOLUMNS TABLE DSNDB06 BP8K0 SYSDBASE 537 __ CREATR1 ABCDEF01 INDEX DSNDB06 BP0 DSNDCX01 7142 __ CREATR1 ABCDEF01 INDEX DSNDB06 BP0 DSNSSH01 4 ***************************** Bottom of Data **********************************