A fix is available
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 number
PH48601
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-08-11
Closed date
2022-11-07
Last modified date
2022-12-01
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 December 2022