PK60233: BUFFER POOL/STORAGE GROUP CONFIGURATION IS NOT READ CORRECTLY FROM PWH RESPONSE FILE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following error message is issued during recreation of the
  PWH database :
  ****************************************************************
  ********
  ***
  DB2 SQL operation failed:
  SQL code ............. : - 551
  Detecting module ..... : DSNXODD2
  PM Server function ... : DGOZMT1
  SQL state ............ : 42501
  SQL error message .... :
  +---------------------------------------------------------------
  --------
  
  ! DSNT408I SQLCODE = -551, ERROR: DB2PM DOES NOT HAVE THE
  PRIVILEGE TO
  ! PERFORM OPERATION CREATE INDEX ON OBJECT BP3
  ! DSNT418I SQLSTATE = 42501 SQLSTATE RETURN CODE
  ! DSNT415I SQLERRP = DSNXODD2 SQL PROCEDURE DETECTING ERROR
  ! DSNT416I SQLERRD = 50 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
  ! DSNT416I SQLERRD = X'00000032' X'00000000' X'00000000'
  ! X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC
  ! INFORMATION
  +---------------------------------------------------------------
  --------
  

Local fix

• Turn off PWH
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Performance Warehouse user                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Wrong Buffer pool used for the creation *
  *                      of indexes, SQLCODE -551 fired.         *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                 to use the specified Buffer Pool and         *
  *                 Storage group for the indexes.               *
  ****************************************************************
  PROBLEM SUMMARY:
  Wrong buffer pool and storage group used for the creation of
  indexes when creating the PWH tables. A sqlcode -551 is fired.
  
  PROBLEM CONCLUSION:
  PWH use now the specified buffer pool for the indexes creation.
  
  KEYWORDS: BUFFER POOL PWH INDEXES SQLCODE -551
  

Problem conclusion

• PWH use now the specified buffer pool for the indexes creation.
  
  KEYWORDS: BUFFER POOL PWH INDEXES SQLCODE -551
  

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:

  UK33468

Modules/Macros

•    DGO@DB   DGOZDB
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK33468

     UP08/02/06 P F802

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.