PH48601: SQLCODE551 RECEIVED DURING THE CREATION OF AN INDEX ON A DECLARED GLOBAL TEMPORARY TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When creating a Declared Global Temporary Table (DGTT) the use
  of the buffer pool and the storage group are not checked for
  authorization.
  
  However, when an index on a DGTT is created those authorization
  checks for the use of the Buffer Pool and storage group in which
  that Index on a DGTT is going to be created are performed
  instead leading sometimes to authorization check failures
  (SQLCODE -551).
  .
  KEYWORDS: SQLCREATE SQLCODE551 SQLDGTT
  

Local fix

• BYPASS/CIRCUMVENTION:
  LOCAL FIX: Perform an explicit GRANT USE OF BUFFERPOOL BPn TO
  authid
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 and 13 for z/OS users of CREATE                   *
  * INDEX on DECLARE GLOBAL TEMPORARY TABLE                      *
  * (DGTT).                                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * User received an unexpected SQLCODE                          *
  * -551 error when creating an index on                         *
  * a DGTT indicating user does not have                         *
  * the proper privilege to use the                              *
  * buffer pool even when the buffer pool                        *
  * is the same as the one for the DGTT.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Creating an index on a DGTT requires the USE privilege on the
  buffer pool that is either specified in the CREATE INDEX
  statement or the buffer pool attribute that is associated with
  the workfile database.  The same applies to the USE privilege
  check for storage group when creating the index on a DGTT.
  However, this is not the intent of how DGTTs should behave.
  

Problem conclusion

• Db2 has been enhanced to only check the USE privilege on the
  buffer pool/storage group specified during CREATE INDEX on a
  DGTT processing if it is different than the buffer pool/storage
  group of the work file database.
  Additional Keywords:
  SQLCREATE
  SQLINDEX
  SQLDGTT
  SQLCODE551
  

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:

  UI83160 UI83161

Modules/Macros

• DSNXICX2 DSNXODDL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI83160

     UP22/11/17 P F211

• RD10 PSY UI83161

     UP22/11/17 P F211

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.