PM47312: LISTDEF DB2 UTILITY DUPLICATE TABLE(ALL) STATEMENTS DSNU082I DSNUGPPP - INVALID KEYWORD - TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS LISTDEF based DB2 Utility
  generation created JCL with duplicate TABLE(ALL) statements
  which resulted in the job failing with a message DSNU082I
  DSNUGPPP - INVALID KEYWORD - TABLE.
  

Local fix

• Remove the duplicate TABLE(ALL) syntax.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When entering the 'UT - Utility         *
  *                      Selection' line command in panel        *
  *                      ADB25L 'LISTDEFs in < schema >.UTLIST'  *
  *                      at the left of the LISTDEF, then        *
  *                      entering the 'RT - Runstats table all'  *
  *                      line command in panel ADB25LU           *
  *                      'LISTDEF Utilities', to build a         *
  *                      RUNSTATS utility job, the resulting     *
  *                      job is missing the LISTDEF statement    *
  *                      and also includes a second TABLE(ALL)   *
  *                      parameter:                              *
  *                                                              *
  *                      //DSNUPROC.SYSIN  DD  *                 *
  *                      RUNSTATS TABLESPACE  LIST               *
  *                        TABLE(ALL)                            *
  *                        TABLE(ALL)                            *
  *                        SHRLEVEL REFERENCE                    *
  *                        UPDATE ALL                            *
  *                                                              *
  *                                                              *
  *                      which resulted in the job failing       *
  *                      with DB2 message DSNU082I:              *
  *                                                              *
  *                      DSNUGPPP - INVALID                      *
  *                      KEYWORD - TABLE.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Both skeleton ADB2USR and skeleton ADB2USRO add a TABLE(ALL)
  parameter, leading to a duplicate keyword situation.
  

Problem conclusion

• Skeleton ADB2USR is modified to resolve 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:

Modules/Macros

•    ADB2USR  ADB25LU  ADB27A
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK75982

     UP12/02/08 P F202

• R720 PSY UK75983

     UP12/02/08 P F202

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.