A fix is available
APAR status
Closed as program error.
Error description
REORG TABLESPACE SHRLEVEL CHANGE is run on a classic partitioned or PBR table space with exactly one partitioning+clustering index defined in it. An overlay happens when clustering index is of length shorter than the mapping index. ADDITIONAL SYMPTOMS: ABEND04E RC00E40317 in DSNURBXD ABEND04E RC00E20992 in DSNSVSVB ABEND04E RC00E40347 in DSNURWBR ABEND04E RC00E2000E in DSNSVSFB
Local fix
BYPASS/CIRCUMVENTION: LOCAL FIX: 1. Add the following as 1st line of SYSIN to bypass PI build logic: DIAGNOSE TYPE(892) 2. Disable Parallelism with PARALLEL 1 in REOG job
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users with PH28092 / * * UI71385 applied when REORG TABLESPACE * * SHRLEVEL CHANGE is run on a table space * * with a single clustering and partitioning * * index defined. * **************************************************************** * PROBLEM DESCRIPTION: * * REORG TABLESPACE SHRLEVEL CHANGE with * * unload reload partition parallelism * * resulted in a storage overlay with * * PH28092 / UI71385 applied. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** With PH28092 / UI71385 applied, a REORG TABLESPACE SHRLEVEL CHANGE using data unload/reload partition parallelism on a table space with a single clustering and partitioning index resulted in a storage overlay and caused Db2 to crash. For this overlay to happen, the following conditions all need to be satisified after applying the erroring PTF: 1. REORG TABLESPACE SHRLEVEL CHANGE is run on a classic partitioned or PBR table space with one and only one partitioning index defined on it 2. The partitioning index defined must have a sum of its max key column lengths less than 29 bytes long, which is the size of the mapping index key 3. REORG is sorting the data records (SORTDATA YES) and is exploiting unload/reload partition parallelism (DSNU1160I issued) The reported problem is caused by an incorrect program logic when a task set number at the index level is being used to assign key length being processed at the partition level. Depending on the actual task set assignment, this might cause the build subtask processing the clustering index keys to be operating with a longer length than the actual clustering key length, resulting in overlays in the utility pipe and key buffers. Depending on the trailing storage being used, a variety of external symptoms can be observed: ABEND04E RC00E40317 in DSNURBXD + x'1C92' OFFSET1C92 ABEND04E RC00E2002F in DSNSVSVB + x'0838' OFFSET0838 Additional keywords: DB2OVRLAY/K MSGDSNU1160I MSGDSNU397I DSNU397I
Problem conclusion
Code has been modified to correct the aforementioned problems related to REORG TABLESPACE execution on a range partitioned table space with a single clustering and partitioning index defined.
Temporary fix
Comments
APAR Information
APAR number
PH36695
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
YesPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-04-26
Closed date
2021-06-02
Last modified date
2021-07-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI75666
Modules/Macros
DSNURPCT
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI75666
UP21/06/10 P F106 ¢
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:
30 July 2021