Configuring Db2 system parameters

Configure your Db2® system parameters to enable the Query Monitor subsystem to monitor your environment.

Procedure

  1. On the IBM® Db2 Query Monitor main menu, specify the appropriate Query Monitor subsystem in the Query Monitor Target field or type ? in this field and press Enter to select a Query Monitor subsystem from a list of those available.
  2. Type 7 in the Option line and press Enter. The Enter DB2 System Parameters panel is displayed.
    Figure 1. Enter DB2 System Parameters panel
     -----------Enter DB2 System Parameters------------
Command ==>                                                              
                                                                         
 DB2 Control Dataset      ==> CQM.DB2.CONTROL                            
 (Pre-allocated)                                                         
                                                                         
 Enter DB2 Subsystem Info:                                               
                                                                         
 DB2 Subsystem ID         ==> QM01      (1-4 Character Subsystem ID)     
                                                                         
                                                                         
 Valid command selection values are:                                     
   1:  ZPARM, BSDS, and Load Library Information                         
   2:  DB2 Query Monitor Parameters

    These fields are displayed on the Enter DB2 System Parameters panel:

    DB2® Control Dataset
    (Display only) Indicates the Db2 control file (DB2PARMS) that is currently being used for the Query Monitor subsystem.
    Note: Setup allocates the Db2 control file in use by the Query Monitor subsystem the last time that Query Monitor subsystem was started. You can specify your own Db2 control file DSN by first blanking-out the Query Monitor Target field (on the main menu) and then typing an S in the option line and pressing Enter to display the Specify DB2PARMS Dataset panel where you can specify the appropriate DB2PARMS data set for your setup.
    DB2 Subsystem ID
    Indicates the ID of the Db2 subsystem where Db2 Query Monitor will execute.

    These options are available on the Enter DB2 System Parameters panel:

    ZPARM, BSDS, and Load Library Information (Option 1)
    Display the Update Parameters for Db2 Subsystem panel where you can specify the DB2 ZPARMs member, the Db2 bootstrap DSNs, and Db2 loadlibs.
    DB2 Query Monitor Parameters (Option 2)
    Display the Update Parameters for Db2 Subsystem panel where you can specify the plan name.
  3. Specify the one- to four-character ID for the Db2 subsystem.
  4. Select Option 1, ZPARM, BSDS, and Load Library Information and press Enter. The Update Parameters for DB2 Subsystem panel is displayed.
    Figure 2. Update Parameters for DB2 Subsystem panel
    ---------  Update Parameters for DB2 Subsystem SSID
Command ==>                                                
                                                           
                                                           
 Enter or Update Specific DB2 Parameters :                 
                                                           
   DB2 ZPARMs Member      ==> SSIDPARM                     
   DB2 Bootstrap DSN #01  ==> SSID.BSDS01                  
   DB2 Bootstrap DSN #02  ==> SSID.BSDS02                  
   DB2 Loadlib1           ==> SSID.SDSNEXIT                
   DB2 Loadlib2           ==> DSN.VXXX.SDSNLOAD            
   DB2 Loadlib3           ==>                              
   DB2 Loadlib4           ==>                              
   DB2 Loadlib5           ==>
  5. Type the appropriate ZPARM load module member name in the DB2 ZPARMs Member field.
  6. Type the full data set names of the two boot strap data sets used for your Db2 subsystem in the DB2 Bootstrap DSN #01 and DB2 Bootstrap DSN #02 fields.
  7. Type the names of the data sets that comprise the current loadlib concatenation for Db2 in the DB2 Loadlib 1 through DB2 Loadlib 5 fields and press Enter.
    Note: You must specify the current loadlib concatenation for Db2 (in the DB2 Loadlib 1 through DB2 Loadlib 5 fields). Db2 Query Monitor does not search the linklist for these values if the DB2 Loadlib 1 through DB2 Loadlib 5 fields are left blank.
  8. Press PF3 to return to the Enter DB2 System Parameters panel.
  9. Select Option 2, DB2 Query Monitor Parameters, to configure Db2 Query Monitor plan information. The Update Parameters for DB2 Subsystem panel is displayed.
    Figure 3. Update Parameters for DB2 Subsystem panel
     DB2 Query Monitor - Update Parameters for DB2 Subsystem SSID 
 Command ==>                                                        
                                                                    
                                                                    
  Enter or Update Specific DB2 Parameters :                         
                                                                    
    Plan #1 Name        ==> CQMPLAN1
  10. Type the plan name for Db2 Query Monitor in the Plan #1 Name field and press Enter.
  11. Press PF3 to exit.
    Note: In some situations, where applicable, Db2 Query Monitor uses ISPF environment variables to reestablish the state in which the user was previously running Db2 Query Monitor. For such situations, Db2 Query Monitor uses the Db2 subsystem defined in a previous invocation and retrieves setup values for that Query Monitor subsystem from the Db2 control file.