PI50903: DB2 ADMINISTRATION TOOL FOR Z/OS WHEN RUNNNING ANALYZE IN CMBATCH DOES NOT TRANSLATE T&ATIME7 PRO 16/01/05 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS when runnning Analyze
  in CMBATCH does NOT translate T&ATIME7 properly
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use a User-defined              *
  *                 template and the Change Management           *
  *                 batch (CM Batch) interface.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following has been fixed:           *
  *                                                              *
  *                      1. When using a variable available      *
  *                      for user customization (such as,        *
  *                      &ATIME7, which is set in skeleton       *
  *                      ADB2UCUS) in a User-defined template    *
  *                      and CM Batch, the variable was not      *
  *                      resolved when running the JCL/          *
  *                      Work Statement List (WSL), and          *
  *                      the utility failed with a Return        *
  *                      Code 8 / RC=8, and                      *
  *                      information message                     *
  *                      DSNU1032I:                              *
  *                                                              *
  *                      DSNU1032I csect-name -                  *
  *                      INVALID QUALIFIER qualifier             *
  *                      IN TEMPLATE name                        *
  *                                                              *
  *                      2. When using a DB2 variable (such      *
  *                      as, &UNIQ.) in a User-defined           *
  *                      template for the UNLOAD utility         *
  *                      in CM Batch, the LOAD failed            *
  *                      with a Return Code 8 / RC=8             *
  *                      and information message                 *
  *                      DSNU1015I:                              *
  *                                                              *
  *                      DSNU1015I csect-name -                  *
  *                      ERROR ALLOCATING DATA                   *
  *                      SET DSN=name                            *
  *                      CODE=X'reason-code'                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following has been fixed:
  
  1. When using a variable available for user customization
  (such as, &ATIME7, which is set in skeleton ADB2UCUS)
  in a User-defined template and CM Batch, the variable was
  not resolved when running the JCL/Work Statement List
  (WSL), and the utility failed with a Return Code 8 / RC=8
  and information message DSNU1032I:
  
  DSNU1032I csect-name - INVALID QUALIFIER qualifier
  IN TEMPLATE name
  
  2. When using a DB2 variable (such as, &UNIQ.) in a
  User-defined template for the UNLOAD utility in CM
  Batch, the LOAD failed with a Return Code 8 / RC=8
  and information message DSNU1015I:
  
  DSNU1015I csect-name - ERROR ALLOCATING DATA
  SET DSN=name CODE=X'reason-code'
  

Problem conclusion

• Problems have been resolved.
  
  This APAR also removes the fix of problem #3 of APAR PI40944,
  since it turned out that it conflicted with the current product
  design.  Now &UQ. is resolved as characters 'UNIQ' in the
  User-defined template DISCARDDN.
  

Temporary fix

Comments

APAR Information

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

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

  UI34306

Modules/Macros

•    ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI34306

     UP16/01/08 P F601 Ø

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.