PM55107: GEN FAILS SQLCODEN104 WHEN PBG TS HAS MORE THAN 1 PARITITION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Users of DB2 Administration Tool for z/OS who use GEN line
  command on panel ADB21S " Table Spaces " can produce invalid DDL
  on PBG Partition By Growth Table Spaces which contain more than
  one partition. Generated DDL contains a PART clause similar to:
     (PART 2
      USING STOGROUP sgname
      PRIQTY 299416 SECQTY -1)
  which is invalid DDL syntax for a PBG Table Space. Trying to run
  the GENerated DDL fails with error messages like:
  .
     DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "(". SOME
     SYMBOLS THAT MIGHT BE LEGAL ARE: IN LOCKSIZE BUFFERPOOL
     <IDENTIFIER> NUMPARTS OBID PSID DSSIZE
  .
  Failing DDL occurs only when GEN option USED or ALLOC is
  specified. GEN option DEFINED works ok.
  .
  Additional symptoms: SQLCODE104 SQLCODEN104 SQLCODE104N
     MSGDSNT408I
  

Local fix

• Use GEN option DEFINED to produce valid DDL.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who specify the field 'Alloc TS size    *
  *                 as' with a value of 'ALLOC' or 'USED' on     *
  *                 panel ADB2GEN 'Generate SQL from DB2         *
  *                 catalog' to GEN the DDL statement for        *
  *                 partition-by-growth (PBG) table space.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users of the DB2 Administration Tool    *
  *                      for z/OS who use the GEN line command   *
  *                      on panel ADB21S 'Table Spaces' can      *
  *                      produce invalid DDL on PBG table        *
  *                      spaces which contain more than one      *
  *                      partition. The generated DDL contains   *
  *                      a PART clause similar to:               *
  *                                                              *
  *                         (PART 2                              *
  *                          USING STOGROUP sgname               *
  *                          PRIQTY 299416 SECQTY -1)            *
  *                                                              *
  *                      which is invalid DDL syntax for a       *
  *                      PBG table space. Trying to run          *
  *                      the generated DDL fails with a          *
  *                      SQLCODE=-104 / SQLCODEN104              *
  *                      error message:                          *
  *                                                              *
  *                      DSNT408I SQLCODE = -104,                *
  *                      ERROR:  ILLEGAL SYMBOL                  *
  *                      ">open parenthesis<".                   *
  *                      SOME SYMBOLS THAT MIGHT                 *
  *                      BE LEGAL ARE:                           *
  *                      IN LOCKSIZE BUFFERPOOL                  *
  *                         >IDENTIFIER< NUMPARTS                *
  *                      OBID PSID DSSIZE                        *
  *                                                              *
  *                      The failing DDL occurs only when the    *
  *                      GEN option 'USED' or ALLOC' is          *
  *                      specified. The GEN option 'DEFINED'     *
  *                      does not produce an error.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The PART clause statement was generated for a partition-by-
  growth table space when using the 'USED' or 'ALLOC' value for
  field 'Alloc TS size as' on panel ADB2GEN.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK77297

Modules/Macros

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK77178

     UP12/03/25 P F203

• R720 PSY UK77297

     UP12/03/25 P F203

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.