Defining Db2 parameters

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

Before you begin

If you did not run the Db2 Admin Tool 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 (IBM Tools Customizer for z/OS 1.1).

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.
  2. On the DB2 Parameters (CCQPDB2) panel, specify the parameter values. Required parameters are indicated by an asterisk (*).
    Start of change
    Figure 1. DB2 Parameters (CCQPDB2) panel
    CCQPDB2            DB2 Parameters: DB2 Admin Tool                     20:01:25
Command ===>                                                  Scroll ===> CSR 
                                                                              
Ensure that values are specified for the required DB2 parameters. Press End   
to save and exit.                                                             
                                                                              
Commands: SAVE  VERIFYOFF                                                     
                                                                   More:     +
 DB2 subsystem ID  . . . . . . . . . . . . : DC1Q                             
 Group attach name . . . . . . . . . . . . .                                  
 Started task name for MSTR services . . . .                                  
                                                                              
General DB2 Information - common                                              
 *Mode . . . . . . . . . . . . . . . . . . . NFM (CM, CM8, CM9, NFM)          
 *Level number . . . . . . . . . . . . . . . 121 (101, 111, 121)              
  Db2 current function level . . . . . . . .                                  
                                                                              
DB2 Utilities - common                                                        
  SYSAFF for DB2 utilities . . . . . . . . .                                  
 *Plan name for the DSNTEP2 utility  . . . . DSNTEP2                          
                                                                              
DB2 Admin Tool - Subsystem Parameters                                         
  Admin Tool PROCLIB . . .                                                    
  WLM Environment Name . . . . . . . . . . .                                  
  WLM Environment Proc Name  . . . . . . . . ADBWLMP                          
  WLM Environment NUMTCB . . . . . . . . . . 10                               
  DB2 subsystem description  . . . . . . . . DB2 VERSION 12 NFM             > 
  Type of DB2 security exit  . . . . . . . . STD                          List
  Enable DB2 Cloning Tool (CT) . . . . . . .     (YES, NO)                    
  Cloning Tool CLIST lib .                                                    
  Enable Db2 Table Editor  . . . . . . . . .     (YES, NO)                    
  Table Editor CLIST(mbr)  . . . . . . . . .                                > 
  Pass accelerator name to Table Editor  . .     (YES, NO)                   
  ...
    End of change
    Tips:
    • For field-specific information, put your cursor in the input field and press F1.
    • Start of changeWhen completing any GRANT fields, always follow the principle of least privilege, which means that users are granted the minimum level of access necessary for their job functions.End of change
    • Any fields that have ADD at the end allow multiple values.
    • Start of changeTo ensure proper security on the Db2 catalog, avoid setting the following GRANT fields to PUBLIC:
      • GRANT ALL ON CDB tables TO field
      • GRANT SELECT ON xxxAUTH tables TO (Not setting this field to PUBLIC ensures that the SYSIBM.SYSxxxAUTH tables cannot be read by PUBLIC.)
      • GRANT SELECT ON remaining tables TO
      Instead, specify specific authorization IDs or roles. Or, if you use RACF security or another means to control access (such as grant management), specify NONE in these fields so that no GRANT statements are generated.End of change
    • Use the fields under Db2 Admin Tool main menu - option parameters to specify additional options to display on the main DB2 Administration Menu (ADB2) panel. You can specify up to 10 additional options.
    • Some of the parameters on this panel are identical to parameters on the Product Parameters (CCQPPRD) panel. If you leave these parameters blank, Tools Customizer uses the values specified on the CCQPPRD panel. If you use unique values for specific Db2 entries, specify these values on the CCQPDB2 panel.
  3. Press End to save your changes and exit, or issue the SAVE command to save your changes and stay on the same panel.