PH08302: DDL GEN LINE COMMAND GENERATES INVALID PBG TABLESPACE DDL PART1 ILLEGAL SYMBOL "(" SQLCODE -104 /SQLCODEN104

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DDL or GEN of a PBG (partition-by-growth) tablespace may
  generate an invalid clause in the DDL, such as the following:
    (PART 1
        FREEPAGE 0 PCTFREE 10 FOR UPDATE  -1)
  If executed, this DDL may result in error SQLCODE = -104 /
  SQLCODEN104, as follows:
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "(". SOME
  SYMBOLS THAT MAY BE LEGAL ARE: IN LOCKSIZE BUFFERPOOL NUMPARTS
  SEGSIZE OBID PSID
  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 3 0  0  -1  796  502 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'00000003'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'0000031C'  X'000001F6' SQL DIAGNOSTIC INFORMATION
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for z/OS. *
  ****************************************************************
  * PROBLEM DESCRIPTION: Reverse Engineering program             *
  *                      (GEN or DDL line command) may           *
  *                      generate invalid DDL for a PBG          *
  *                      table space, resulting in a SQLCODE /   *
  *                      SQLNCODE=-104 error when DDL is         *
  *                      executed.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DDL or GEN line command may generate invalid DDL
  when the Db2 SYSTABLESPACE catalog table has invalid
  values on PCTFREE, PCTFREE_UPD, and/or FREEPAGE
  fields for a PBG table space. The invalid DDL may look
  like the following:
  
   (PART 1
        FREEPAGE 0 PCTFREE 10 FOR UPDATE -1)
  
  The invalid DDL leads to -104 SQL error when being
  executed:
  
  DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "(".) SOME
  SYMBOLS THAT MIGHT BE LEGAL ARE: IN LOCKSIZE BUFFERPOOL
  NUMPARTS SEGSIZE OBID PSID
  

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:

Modules/Macros

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI62635

     UP19/04/27 P F904

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.