PI46307: DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT RESOLVE USER DEFINED TEMPLATE FOR IMAGE COPY CORRECTLY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS does not resolve
  user defined TEMPLATE for IMAGE COPY correctly
  which results in Invalid &SUBSTR-range message
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use user-defined templates with     *
  *                 the 'ALT Alter Table' (ALT) function.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Admin Tool does not resolve a       *
  *                      user-defined TEMPLATE for an IMAGE      *
  *                      COPY correctly, which results in an     *
  *                      'Invalid &SUBSTR-range' message,        *
  *                      encounters the following syntax         *
  *                      error:                                  *
  *                                                              *
  *                      THIS STATEMENT HAS AN INVALID           *
  *                      &SUBSTR RANGE OR EXIT CODE              *
  *                      EXPRESSION                              *
  *                                                              *
  *                      and ends with RC=912 / Return Code      *
  *                      912.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program should fix the substring out of range problem and be
  enhanced to issue error message ADBM708E / msgadbm708e to
  report the template syntax error if it cannot be resolved
  during the ALT process.  The template syntax error occurred
  while building the APPLY job or Work Statement List ( WSL ).
  

Problem conclusion

• Problem has been resolved.
  
  The following new message will be displayed when a template
  syntax error is encountered:
  
  ADBM708E
  A template syntax error occurred while building the apply
  job or work statement list.
  
  Explanation
  DB2 Admin detected a syntax error for the user-defined
  template while building the apply job or work statement list.
  
  System action
  No system action is taken.
  
  User response
  Modify the definition for the user-defined template.
  

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:

  UI33206 UI33207 UI33208

Modules/Macros

•    ADBEALT  ADBGAJOB ADBM70   ADB2DSN  ADB2DSN2
  ADB2PTPL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI33206

     UP15/11/25 P F511

• RB10 PSY UI33207

     UP15/11/25 P F511

• RB20 PSY UI33208

     UP15/11/25 P F511

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.