PI96053: ENHANCEMENTS FOR SUPPORTING DET IN BATCH AND GENERATING READABLEWSL IN CM BATCH.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Enhancements for supporting DET in batch and Generating readable
  WSL in CM Batch.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS or DB2 Object Comparison Tool for z/OS. *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1 - New enhancement will provide batch  *
  *                      interface to generate detailed report   *
  *                      for tables, packages and accelerated    *
  *                      tables.                                 *
  *                                                              *
  *                      The following Catalog Navigation panels *
  *                      have been enhanced with the provision   *
  *                      to generate a detailed report in batch  *
  *                      via the new command "BET":              *
  *                                                              *
  *                       - ADB21T - Tables, Views, and Aliases  *
  *                       - ADB21K - Packages                    *
  *                       - ADBPZAT - Display Accelerated Tables *
  *                                                              *
  *                      2 -  Customers would like to see        *
  *                      validation errors earlier than          *
  *                      analyze time for DDL that they are      *
  *                      importing in CM batch.                  *
  *                                                              *
  *                      Support is added to allow               *
  *                      customer to do validation on            *
  *                      DDL that is imported during CM          *
  *                      batch.                                  *
  *                                                              *
  *                      3 - Change management panels            *
  *                      allow customers to read WSL and         *
  *                      edit it before running, but the         *
  *                      CM batch interface does not.            *
  *                                                              *
  *                      Support is added to allow               *
  *                      customer to give a data set             *
  *                      where the readable version              *
  *                      of a WSL given by parameters            *
  *                      will be stored.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1 - New enhancement will provide batch interface to generate
  detailed report for tables, packages and accelerated tables,
  similar to online DET function.
  
  A single job control language (JCL) program can be used to
  generate report for one or more below object types.
  
  Parameters that can be specified are as follows:
  
  TYPE = 'TB' | 'PK' | 'AT' (mandatory)
  QUAL = >creator< (for tables) OR
          >collid< (for packages) (optional)
  NAME = >name< (optional)
  VERSION = >version< (optional, only valid for TYPE='PK')
  ACCELERATOR = >acceleratorname< (optional, only valid
                 for TYPE = 'AT')
  
  Eg.
   //PARMS DD *
   TYPE = 'TB' QUAL = 'TS5771' NAME = 'TB%';
   TYPE = 'PK' QUAL = 'TDKDB' NAME = 'ADB0' VERSION = '*';
   TYPE = 'AT' NAME = 'T%' ACCELERATOR = '%ACC1';
  
  Each TYPE record entry must terminate with a semi-colon to
  indicate end of its input parameters.
  Wild cards % (one or more) or * (all) can be specified for
  QUAL, NAME, VERSION or ACCELERATOR.
  All fields except TYPE are OPTIONAL. Eg. No QUAL parm would
  be equivalent to QUAL='*'.
  
  The following Catalog Navigation panels have been enhanced
  with the provision to generate a detailed report in batch
  via the new command "BET":
  
   - ADB21T - Tables, Views, and Aliases
   - ADB21K - Packages
   - ADBPZAT - Display Accelerated Tables
  
  2- With use of a new CM batch parameter, users
  can get validation done for imported DDL before
  analyze time. The validation will be done in a report
  just like the report that is done during WSL
  validation.
  
  The CM batch parameter added is:
  
  VALIDATE_DDL
  The validate_ddl parameter specifies whether to validate
  the DDL that is being imported into change management.
  This option is forced to NO (N), when input to import is
  a changes file, and not DDL.
  
  Values:
  Y
    Validate the DDL and display the report in the job
    output.
  N
    Do not validate the DDL.
  Default:
    N
  
  This option validates the input DDL directly against the
  catalog for issuing the DB2 PREPARE, checking for the
  existence of objects, etc. Prerequisite changes are not
  taken into consideration and hence an informational
  message will be issued when validate_ddl is turned on.
  For example, if table is being referred in the DDL that
  does not exist in catalog, validate_ddl, will result in error.
  If a prerequisite change is creating that that table, that
  will not be taken into consideration.
  
  The message is as below:
  
  ADB9756I Prerequisite changes may be present but
  validate DDL does not take them into consideration.
  Explanation:
   Prerequisite changes are not seen by the
   DDL validation for import.
  User Response:
   Prerequisite changes are not validated. it.
  System Action:
   Processing continues.
  
  Validate_DDL is an import option, strictly limited to validating
  the DDL and not applicable to validating the change file.
  For example, if you run compare, and importing the delta
  changes file, this option will not be in effect. User will recei
  receive a warning message that validate_ddl option is forced
  to NO (N):
  
  ADB9755W Validate_ddl is forced to NO because validate DDL
  is strictly limited to validating DDL. Input file provided is a
  changes file.
  Explanation:
   Only DDL will be validated with validate_DDL = Y
  User Response:
   Specify a DDL file as import file if validation is required.
  System Action:
    Processing continues.
  
  3 - With use of new CM batch parameters, users
  can give a dataset name where the WSL specified
  by CM batch parms or by change name can be
  input in a readable format that is editable.
  
  The CM batch parameters added are:
  
  ACTION_CONVERT_TO_READ_WSL
   Valid values are: Y or N
  
  ACTION_CONVERT_TO_ISPF_WSL
   Valid values are: Y or N
  
  PDS_FOR_WSL_CONV
   Specifies the name of the PDS that will have the readable
   work statement list.
  
  WORKLIST_NAME_CONV
   Specifies the member name of the readable WSL.
  

Problem conclusion

Temporary fix

Comments

• Enhancement delivered and problems have been resolved.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    ADBALT   ADBASPR  ADBA1TC  ADBA1TG  ADBA1TH
  ADBA1TM  ADBA1TP  ADBA1TV  ADBA1TX  ADBCCM   ADBCRCR  ADBCUPC
  ADBDAT   ADBDET   ADBEBET  ADBHZAT  ADBH1K   ADBH1T   ADBPZAT
  ADBPZBT0 ADBPZEDM ADBPZED1 ADBP1TB0 ADBSBET  ADB0     ADB2A2WS
  ADB2PA   ADB2PA3  ADB2PA4  ADB2PA5  ADB2WVL  ADB2W1   ADB2000
  ADB21K   ADB21T   ADB9000  H0IHB20J H0IHC10
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI55504

     UP18/04/28 P F804

• RC10 PSY UI55505

     UP18/04/28 P F804

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.