PL47417: RC00C90101 DSNIDLOD VRACE5013 WHEN USING LOAD RESUME YES ON SEGMENTED TABLESPACE WITH UNIQUE INDEX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00C90101 IN DSNIDM.DSNIDLOD:5013 ERQUAL5013 WHEN
  RUNNING LOAD RESUME YES ON SEGMENTED TABLESPACE. IT WORKS FINE
  ON NON-SEGMENTED TABLESPACE.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: USERS OF SEGMENTED TABLESPACE                *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00C90101 DSNIDLOD ERQUAL(19) *
  *                      DURING LOAD RESUME YES TO A SEGMENTED   *
  *                      TABLESPACE WITH FREEPAGES SPECIFIED.    *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF WHEN AVAILABLE                     *
  ****************************************************************
  USER CREATED A SEGMENTED TABLESPACE WITH FREEPAGE 1. A TABLE
  WITH A UNIQUE INDEX WAS CREATED IN THE TABLESPACE. THE TABLE WAS
  POPULATED WITH DATA, THEN A LOAD RESUME YES WAS DONE WITH NEW
  DATA. THE LOAD RESUME WAS THEN ISSUED AGAIN WITH THE SAME DATA.
  NO ROWS WERE LOADED BECAUSE ALL ROWS WERE DUPLICATES. THE LOAD
  RESUME WAS RUN A THIRD TIME AND ABEND04E RC00C90101 OCCURRED IN
  DSNIDLOD. THE FREEPAGE INSERTED DURING THE LOAD IS BEING MARKED
  AS USED IN THE SPACEMAP. WHEN DSNIDLOD TRIES TO DETERMINE THE
  END OF CURRENT DATA, IT PICKS THE FREEPAGE AND ABENDS BECAUSE
  IT IS EMPTY.
  

Problem conclusion

• DSNIWLPG IS CHANGED TO MARK FREEPAGES AS EMPTY DUE TO MASS
  DELETED IN THE SPACEMAP PAGE STATUS BITS. THE FREEPAGES WILL
  THEN BE BYPASSED AS POSSIBLE END OF DATA PAGES.
  

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:

  PL49099

Modules/Macros

•    DSNIWLPG
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R210 PSY UL57671

     UP89/09/11 P F907

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.