PI22118: ABENDS0C9 IN DSNUCINM WHEN DOING A REBUILD INDEX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In the absence of index statistics DB2 can calculate
  number of rows using table and table space pages.  If
  for some reason the catalog has a very large number of
  table pages and a small number of table space pages
  the row calculation can result in an ABENDS0C9 in DSNUCINM
  +3180 UK94071.  Logically, you should never have a
  much larger number of table pages than table space pages.
  

Local fix

• Run RUNSTATS
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 utility users of REBUILD INDEX               *
  ****************************************************************
  * PROBLEM DESCRIPTION: REBUILD INDEX abends with ABENDS0C9 RC9 *
  *                      at DSNUCINM +x'30E6'                    *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  After having its indexes dropped, a table was loaded with over
  5 million pages of data rows with LOAD REPLACE and without any
  statistics being gathered.  Without STATISTICS on the LOAD, the
  number of pages for that table space is not updated so it
  maintained the small number of pages it had from before the
  LOAD.
  
  When REBUILD INDEX was run, DB2 attempted to calculate the
  number of rows in the table for its index(es).  However, the
  number of data pages in the table was very high but the number
  of table space pages was low from a previous catalog update so
  the algorithm, which used 31-bit variables, could not handle the
  arithmetic calculations and the ABEND0C9 occurred.
  
  It should be noted that if LOAD REPLACE is not run with the
  STATISTICS keyword, RUNSTATS should be run before the rebuilding
  of any indexes.
  

Problem conclusion

• Code has been changed to use larger variables in the calculation
  of rows per table to help avoid the aforementioned error.
  

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:

  UI23292 UI23293

Modules/Macros

• DSNUCINM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI23292

     UP14/12/09 P F412

• RB10 PSY UI23293

     UP14/12/09 P F412

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.