Defining Db2 parameters

In TCz, Db2 parameters are parameters for a Db2 entry.

About this task

If you did not run the Db2 Query Monitor Discover EXEC, you must create and associate one or more Db2 entries before you can define the Db2 parameters. For instructions, see Creating and associating Db2 entries.

Procedure

To define Db2 parameters:

  1. On the Customizer Workplace (CCQPWRK) panel, in the Associated DB2 Entries and Parameter Status section, specify E next to one or more Db2 entries, and press Enter.
    The is displayed, as shown in the following figure:
    Figure 1. DB2 Parameters (CCQPDB2) panelDB2 Parameters (CCQPDB2) panel
    Start of change
    CCQPDB2            DB2 Parameters: DB2 Query Monitor                  02:55:20
Command ===>                                                  Scroll ===>  CSR
                                                                              
Ensure that values are specified for the required DB2 parameters. Press End   
to save and exit.                                                             
                                                                              
Commands: SAVE  VERIFYOFF                                                     
                                                                              
 DB2 subsystem ID  . . . . . . . . . . . . : L7BB                             
 Group attach name . . . . . . . . . . . . .                              
                                                                              
General DB2 Information - common                                              
 *Mode . . . . . . . . . . . . . . . . . . . NFM (CM, NFM)                    
 *Level number . . . . . . . . . . . . . . . 131 (121, 131)                   
  Db2 current function level . . . . . . . .                                  
                                                                              
DB2 Libraries - common                                                        
 *Load library . . . . . . DSN.SDSNLOAD                                   Add 
 *Run library  . . . . . . DSN.RUNLIB.LOAD                                Add 
 *Exit library . . . . . . DSN.L7BB.SDSNEXIT                              Add 
                                                                              
DB2 Utilities - common                                                        
  SYSAFF for DB2 utilities . . . . . . . . .                                  
 *Plan name for the DSNTEP2 utility  . . . . DSNTEP2                          
                                                                              
DB2 Query Monitor for z/OS Collector Parameters                               
  Monitoring profile . . . . . . . . . . . .                                  
                                                                              
DB2 Query Monitor for z/OS Configuration Parameters                           
 *SQL authorization ID . . . . . . . . . . . USERID                           
 *BIND Owner ID  . . . . . . . . . . . . . . USERID                         > 
  DB2 Query Monitor for z/OS schema name . .                                > 
 *DB2 Query Monitor for z/OS grantee . . . . NONE                           > 
 *DB2 Query Monitor for z/OS PLAN name . . . CQMPLAN
    End of change

    You can use the following primary commands on this panel:

    SAVE
    Saves the specified product or component parameter values.
    VERIFY / VERIFYOFF
    Use the VERIFY and VERIFYOFF commands to turn on and off parameter verification of Db2 parameters. Before you can generate customization jobs, you must verify that all required parameters are set to a valid value. The Db2 parameter status of Verify Values on the Customize Workplace panel indicates that the values have not been verified.

    Enter these commands either by typing them in the command field and pressing Enter or by positioning the cursor on the command and pressing Enter. When VERIFY is active, VERIFYOFF is displayed so that you can toggle between the two states. By default, verification is turned on when you display the DB2 Parameters (CCQPDB2) panel, and the verification state is reset to VERIFY every time you exit the Customizer Workplace (CCQPWRK) panel by pressing PF3.

    Turning verification off is useful when you need to exit the panel before you have entered all of the required parameters, but you want to save the parameters that you have specified. When you disable verification, it is disabled only for the DB2 Parameters (CCQPDB2) panel.

  2. Specify values for all parameters that are displayed.
    Tips:
    • In the command line, specify the KEYS command, and map EXPAND to one of the function keys.
    • For a detailed description of all input fields, put the cursor in the field, and press F1 or the key that is mapped to Help.
    • The following elements apply to specific fields:
      • Add is displayed when parameters can have multiple values but currently have only one value. To specify multiple values in these fields, place the cursor on Add, and press Enter. Use the displayed panel to add or delete additional values.
      • List is displayed when the complete list of valid values for the fields is too long to be displayed on the panel. To see the complete list of values, place the cursor on List, and press F1 or the key that is mapped to Help.
      • More is displayed when input fields contain multiple values. To see all of the values in the field, place the cursor on More, and press Enter.

    Many parameters have default values, which you can either accept or change.

  3. Press End to save your changes and exit, or issue the SAVE command to save your changes and stay on the same panel.

Results

The status of the Db2 entries that you selected on the Customizer Workplace (CCQPWRK) panel is Ready to Customize.

What to do next

If the status of other parameters on the Customizer Workplace (CCQPWRK) panel is Incomplete, Verify Values, or Discovered, edit these parameters.