PK28882: AL/RDEF TEMPLATE NAME NOT RESOLVING &JO / &JOBNAME RESULTS IN DSNU1032I DSNUGTDS INVALID QUALIFIER RC=8

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool AL/RDEF command builds a TEMPLATE
  statement without resolving the &JO / &JOBNAME variable which
  results in a message:
  DSNU1032I   DSNUGTDS - INVALID QUALIFIER aaa IN TEMPLATE aaa
  DSNU012I    DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST
  RETURN CODE=8
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users using Templates with AL/RDEF.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: JOB FAILS with the rc=8.  The following *
  *                      message is also produced in job output: *
  *                      DSN U1032I DSNUGTDS - INVALID QUALIFIER *
  *                      .Dxxxxx.  IN TEMPLATE @PUNCH            *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The Alter Tablespace  Redefine the panel ADB21SAJ generates and
  displays JCL template  symbolic variables  resolved if template
  type UTIL is used with  PUNCHDDN toggled off  (not Cleared) and
  UNLDDN is selected using the same template name.In other words,
  when UNLDDN is selected, the template symbolic variables should
  not be resolved when  the JCL is created, only after the job is
  submitted.
  

Problem conclusion

• It turns out that this  has been a problem all along and was not
  result of the first PK28882 fix.What's happening was a TBSCAN in
  ADB2PTPL only searched for the template name when it should also
  be checking  to see  if it is also  toggled ON/OFF switch.  Note
  that the Clear option on PUNCHDDN circumvents the problem.
  

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:

  UK29135 UK29136

Modules/Macros

•    ADB2DSN  ADB2PTPL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK29135

     UP07/10/17 P F710

• R720 PSY UK29136

     UP07/10/17 P F710

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.