A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00E70100 on DSNXIDPT happened during REORG if the below conditions are all true: 1) REORG runs against a PBG tablespace which has no table defined in it 2) The PBG has more than 1 trailing empty partitions 3) REORG is going to remove the trailing empty partitions which can be triggered by REORG option DROP_PART YES , or zPARM REORG_DROP_PBG_PARTS=ENABLE Dump Title: xxxx,ABND=04E-00E70100,U=uuuuuu ,M=N ,C=121.RDS -DWADIAG,M=DSNTFRCV, LOC=DSNXGRDS.DSNXIDPT:P006
Local fix
BYPASS/CIRCUMVENTION: Disallow REORG to remove trailing empty PBG partition by setting REORG option DROP_PART NO , or zPARM REORG_DROP_PBG_PARTS=DISABLE
Problem summary
**************************************************************** * USERS AFFECTED: * * Db2 12 for z/OS users of REORG. * **************************************************************** * PROBLEM DESCRIPTION: * * Users encounter an error during a * * REORG against a partition-by-growth * * table space. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** Users who run a REORG may encounter ABEND04E RC00E70100 at DSNXIDPT P006 if the following conditions are met: 1. REORG is run on a partition-by-growth table space which has no table defined in it. 2. The partition-by-growth table space has more than one trailing empty partition. 3. REORG option DROP_PART YES is specified, or zPARM REORG_DROP_PBG_PARTS is enabled.
Problem conclusion
Db2 is modified to properly drop empty trailing partitions of a partition-by-growth table space with no table defined in it.
Temporary fix
Comments
APAR Information
APAR number
PH31863
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-19
Closed date
2021-03-03
Last modified date
2021-04-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI74228
Modules/Macros
DSNXIDPT DSNGDADP
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI74228
UP21/03/11 P F103
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:
02 April 2021