A fix is available
APAR status
Closed as program error.
Error description
REORG at PARTLEVEL with DRAIN_ALLPARTS failed to drain the tablespace, but DISPLAY CLAIMERS command was just against partitions that in reorg scope so user can not find claimers on other partitions.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS utility users of REORG * * TABLESPACE with DRAIN_ALLPARTS specified. * **************************************************************** * PROBLEM DESCRIPTION: * * DISPLAY CLAIMERS during a REORG * * TABLESPACE PART(1:4) with * * DRAIN_ALLPARTS does not show the * * claims against all partitions when * * the REORG fails with MSGDSNU590I * * RESOURCE NOT AVAILABLE ABEND04E * * RC00C200EC. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** REORG TABLESPACE PART(1:4) with DRAIN_ALLPARTS YES specified failed to acquire the part 0 drain due to an existing claim on partition 7, and resulted in a DSNU590I - RESOURCE NOT AVAILABLE, REASON=X'00C200EA'; however, the subsequent DISPLAY CLAIMERS output was only performed against partitions 1 thru 4 so no blocking claimers were displayed.
Problem conclusion
REORG was modified to correct the aforementioned problem by displaying global claimers on all table space partitions when the option DRAIN_ALLPARTS is provided and the part 0 drain fails.
Temporary fix
Comments
APAR Information
APAR number
PH31981
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
2020-11-23
Closed date
2021-02-15
Last modified date
2021-03-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI73984
Modules/Macros
DSNURDRN
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI73984
UP21/02/24 P F102
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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"}]
Document Information
Modified date:
06 March 2021