PH29576: SHAADENU - 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 SHAADENU 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 SHAADENU *
  *                      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:

Modules/Macros

• HAA#UPRI HAA$BUTC HAA$BUTR HAA$BUTX HAA$PPCT HAA$UIST HAA$URBL
  HAA$URCB HAA$USTT HAADDL2  HAAHUSTT HAAHVSTT HAARBLDC HAARBLDW
  HAAREOIC HAAREORC HAARUNSC
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R430 PSY UI72806

     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.