PI53080: REORG REBALANCE SHARLEVEL CHANGE FAILING IN REORG LOGAPPLY PHASE WITH 00C90101 REASON'00E40347' DSNKINSL:500E.

Obtain the fix for this APAR.

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 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.