PI16350: ABEND04E RC00C90101 DSNISMRS:5003 HAPPENS AFTER REORG PART ON A PARTITIONED TABLESPACE WITH NON-PARTITIONED CLUSTER INDEX.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Dump Title: DB3G,ABND=04E-00C90101,U=LSOII3AA,M=C9 ,C=101.DMC
  -DSNIISRT,M=DSNTFRCV,LOC=DSNIDM  .DSNISMRS:5003
  After REORG PART on a partitioned tablespace with
  non-partitioned cluster index, INSERT into the tablespace may
  get ABEND04E RC00C90101 DSNISMRS:5003.
  It happens because REORG PART may leave some old RIDs in the
  specified parts as pseudo deleted RIDs due to performnce reason.
  Those old RIDs may be bigger than the high used RBA after the
  REORG.
  INSERT refers that old RID to decide the candidate page, then
  issues ABEND04E RC00C90101 DSNISMRS:5003 because the page is
  out of range.
  INSERT shouldn't refer pseudo deleted RID to decide the
  candidate page if the cluster index is non-partitioned and on a
  partitioned tablespace.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 users using non-partitioned secondary        *
  *                 indexes (NPI) as clustering index on a       *
  *                 partitioned tablespace                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: After REORG PART on a partitioned       *
  *                      tablespace with non-partitioned         *
  *                      secondary index (NPI) as clustering     *
  *                      index, an INSERT into the tablespace    *
  *                      may caused ABEND04E RC00C90101          *
  *                      DSNISMRS ERQUAL5003.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In certain cases, REORG TABLESPACE PART and LOAD REPLACE PART
  may leave pseudo deleted keys in index leaf pages.
  While inserting data to table, the clustering, non-partitioned
  secondary index (NPI) was used to position on a candidate page.
  Index Manager, using NPI, incorrectly positioned on a pseudo
  deleted rid and returned an invalid candidate page. This caused
  ABEND04E RC00C90101 DSNISMRS ERQUAL5003.
  
  
  Additional keywords: SQLINSERT SQLDELETE
  

Problem conclusion

• Index manager has been updated so that the clustering,
  non-partitioned secondary index (NPI) does not position on a
  pseudo deleted rid and returns a valid candidate page.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI18412 UI18413

Modules/Macros

• DSNKPOSI
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI18412

     UP14/06/13 P F406

• RB10 PSY UI18413

     UP14/06/13 P F406

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.