Working with interval data sets

Use the Interval Datasets panel to access data set information for your intervals.

Procedure

When viewing activity summaries, exceptions, SQLCODES, or Db2 commands, type INTV in the command line and press Enter.

In the CMD field next to the interval or intervals for which you want to access data set information, type D and press Enter.

Figure 1. Interval Datasets panel

YYYY/MM/DD HH:MM:SS  --------- Interval Datasets --------  Row 1 of 15         
Option  ===>                                                  Scroll ===> PAGE 
                                                                               
------------------------------------------------------------------------       
 CMD        DATASET NAME                                 VOLUME                
 --------   -------------------------------------------- ------                
 ________   CQM.DB01.EDATA.D000001.T1111.I00005          *VSAM*                
 ________   CQM.DB01.EDATA.D000001.T1111.I00005.DATA     DTP100                
 ________   CQM.DB01.EINDX.D000001.T1111.I00005          *VSAM*                
 ________   CQM.DB01.EINDX.D000001.T1111.I00005.DATA     DTP101                
 ________   CQM.DB01.METRD.D000001.T1111.I00005          *VSAM*                
 ________   CQM.DB01.METRD.D000001.T1111.I00005.DATA     DTP103                
 ________   CQM.DB01.OBJSD.D000001.T1111.I00005          *VSAM*                
 ________   CQM.DB01.OBJSD.D000001.T1111.I00005.DATA     DTP100                
 ________   CQM.DB01.TEXTD.D000001.T1111.I00005          *VSAM*                
 ________   CQM.DB01.TEXTD.D000001.T1111.I00005.DATA     DTP108                
 ________   CQM.DB01.SQLCD.D000001.T1111.I00005          *VSAM*                
 ________   CQM.DB01.SQLCD.D000001.T1111.I00005.DATA     DTP109                
 ________   CQM.DB01.SQLCD.D000001.T1111.I00005.INDEX    DTP109                
 ________   CQM.DB01.DB2CD.D000001.T1111.I00005          *VSAM*                
 ________   CQM.DB01.DB2CD.D000001.T1111.I00005.DATA     DTP104                
***************************** Bottom of Data **********************************

The following columns are available:

Dataset Name: The names of the Db2® Query Monitor data sets that were created for the selected interval.
Volume: The volume on which the data set is located.

Note: The commands available to users who access the Interval Data Sets panel can be customized by editing a copy of SCQMSAMP library member CQMCMDS. After customization, the CQMCMDS CLIST must be placed in the SYSPROC concatenation for your installation. The Interval Data Sets panel passes the command name and the data set name from the panel to the CQMCMDS CLIST as parameters.