PH29577: SDYXDENU - DDL JOBS: REMOVE "BUFFERPOOL" FROM SYNTAX FOR CREATED ON SYSIBM (DB2 CATLG) OBJECTS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DDL jobs generated via TCz for SDYXDENU currently specify
  "BUFFERPOOL"  parm in the DDL for indexes created on
  Db2 Catalog objects.
  This BUFFERPOOL syntax references whatever BP the customer
  specified on the  CCQPDB2 panel of TCz.
  Should a BP other than BP0 be entered, a -607
  SQLERROR is possible when the DDL is executed.
  
  This fix will eliminate the BUFFERPOOL statement from the CREATE
  INDEX statements for those indexes being created on a Db2
  catalog object - forcing Db2 to use the default BP - thus,
  eliminating a potential -607 SQLCODE.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: DDL jobs generated via TCz for SDYXDENU *
  *                      currently specify "BUFFERPOOL" parm in  *
  *                      the DDL for indexes created on Db2      *
  *                      Catalog objects.  This BUFFERPOOL       *
  *                      syntax references whatever BP the       *
  *                      customer specified on the CCQPDB2 panel *
  *                      of TCz.  Should a BP other than BP0 be  *
  *                      entered, a -607 SQLERROR is possible    *
  *                      when the DDL is executed.               *
  *                                                              *
  *                      This fix will eliminate the BUFFERPOOL  *
  *                      statement from the CREATE INDEX         *
  *                      statements for those indexes being      *
  *                      created on a Db2 catalog object -       *
  *                      forcing Db2 to use the default BP -     *
  *                      thus, eliminating a potential -607      *
  *                      SQLCODE.                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF                                *
  ****************************************************************
  .
  

Problem conclusion

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:

  UI72807

Modules/Macros

• DYXDDL1
  

Fix information

• Fixed component name

  AUTONMICS DIR D

• Fixed component ID

  5655V9301

Applicable component levels

• R160 PSY UI72807

     UP20/12/07 P F012

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.