A fix is available
APAR status
Closed as program error.
Error description
REORG REBALANCE SHARLEVEL CHANGE failing on a index controlled partitioned tablespace in REORG LOGAPPLY phase with 00C90101 REASON'00E40347' DSNKINSL:500E.
Local fix
nil
Problem summary
**************************************************************** * USERS AFFECTED: DB2 10 for z/OS users running with REORG * * REBALANCE SHRLEVEL CHANGE utility on * * partition by range (PBR) or classic * * partitioned table spaces. * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E RC00C90101 LOC=DSNIDM.DSNKINSL * * ERQUAL500E encountered during REORG * * REBALANCE SHRLEVEL CHANGE utility * * LOGAPPLY phase. * **************************************************************** * RECOMMENDATION: * **************************************************************** At the time of error, a REORG REBALANCE SHRLEVEL CHANGE utility is executing in LOG apply, performing deferred key processing near the end of LOG phase. During this execution, index manager is called to insert into a partitioned unique index. Index manager insert code path fails with ABEND04E RC00C90101 LOC=DSNIDM.DSNKINSL ERQUAL500E sanity abend because the partition of the index page being inserted into is different from the partition of the input RID for the deferred key processing. This error happened because index manager uses the existing OBD limit key value to calculate the partition number for the index page used for insert, which is different from the limit key generated by the REBALANCE operation.
Problem conclusion
DB2 code has been changed so during REORG REBALANCE SHRLEVEL CHANGE LOGAPPLY deferred key processing, the correct partition number is passed to index manager based on the limit key values generated by the REBALANCE operation. Index manager will insert the deferred index keys to the correct partitions.
Temporary fix
Comments
APAR Information
APAR number
PI53080
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-11-24
Closed date
2016-01-27
Last modified date
2016-03-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI34796
Modules/Macros
DSNIKDEF DSNURLAP DSNURLOG
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UI34796
UP16/02/19 P F602
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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 March 2016