Defining Db2 Admin Tool parameters

In TCz, Db2 Admin Tool parameters contain are parameters that are specific to Db2 Admin Tool. If you ran the Db2 Admin Tool Discover EXEC, these parameter values were discovered for you; you need only to review them.

Procedure

To define Db2 Admin Tool parameters:

  1. On the Customizer Workplace (CCQPWRK) panel, specify E next to the Product parameters field, and press Enter.
  2. On the Product Parameters (CCQPPRD) panel, specify the parameter values. Required parameters are indicated by an asterisk (*). 
    CCQPPRD            Product Parameters: DB2 Admin Tool                 19:18:10 
Command ===>                                                  Scroll ===> CSR  
                                                                            
Product customization library  : TS5776.TCZ.CUST.A668.$RS22$.ADB1210           
                                                                   More:     + 
                                                                               
* General Customization                                                        
                                                                               
  * Customize                                                                  
   *Admin Tool/OC CLIST  . 'DMTOOL.SADBCLST'                     More 
   *Admin Tool DBRM  . . . 'DMTOOL.SADBDBRM'                     More 
   *Admin Tool/OC EXEC . . 'DMTOOL.SADBEXEC'                     More 
   *Admin Tool/OC Load . . 'DMTOOL.SADBLLIB'                     More 
   *Admin Tool/OC Message  'DMTOOL.SADBMLIB'                     More 
   *Admin Tool/OC Panel  . 'DMTOOL.SADBPLIB'                     More 
   *Admin Tool/OC Skeleton 'DMTOOL.SADBSLIB'                     More 
   *Admin Tool/OC Table  . 'DMTOOL.SADBTLIB'                     More 
   *Customized Table lib . '<hlq>.CUST.SADBTLIB'                               
    Admin Tool hlq . . . . . . . . . . . . . DMTOOL.ADBC1PTF     
.
.
.
    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
    • 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
    • Start of changeIf your security is managed by a separate tool or GRANT statements need to be run by another user ID (for example, one with SECADM authority), consider setting the Generate a separate job for security field to YES.End of change
    • On this panel, you can specify whether you want to make DB2I and Db2 Object Comparison Tool available from the Db2 Admin Tool main menu. For instructions, see steps 2 and 3 in Making DB2I and IBM Db2 Object Comparison Tool for z/OS available from the Db2 Administration Tool main menu.
    • For the Customized Table lib field, consider specifying an output data set name other than the shipped hlq.SADBTLIB. For example, specify a pre-allocated generic data set name (such as hlq.CUST.SADBTLIB) to store the ISPF customization table member ADBTPARM. This specification has the following advantages:
      • When upgrading Db2 Admin Tool, you do not need to run the Discover EXEC or manually move the ISPF customization table member ADBTPARM from hlq.SADBTLIB if the name of this shipped data set changes.
      • Description and Group information from all Db2 subsystems that are managed by TCz are properly displayed on the Active Db2 Systems (ADB2SYS) panel by using Launchpad mode when a common or general library (for example, hlq.CUST.SADBTLIB) is used to store ADBTPARM, even across LPARs when the common library is on a shared volume.

      When using this method, make sure hlq.CUST.SADBTLIB is also included in the concatenation when invoking Db2 Admin Tool.

      When TCz generates multiple ADBCUST jobs, a product parameters section is included in each job. Therefore, the value of the product parameter Customized Table lib must be the same in each ADBCUST job.

  3. Press End to save your changes and exit, or issue the SAVE command to save your changes and stay on the Product Parameters (CCQPPRD) panel.