PH17579: TOTALROWS IN SYSIBM.SYSTABLESPACESTATS HAVING NEGATIVE VALUE CAUSE REORG FAILS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• TOTALROWS in SYSIBM.SYSTABLESPACESTATS having negative value
  after an insert with 3887713289 rows. The afterward REORG will
  fail as Db2SORT abends due to the negative TOTALROWS value.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Db2 for z/OS V12 users of Real Time                          *
  * Statistics                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * TOTALROWS in SYSIBM.SYSTABLESPACESTATS                       *
  * has negative values.                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Internal counters for statistics can overflow into negative
  values that result in the externalization of incorrect fields
  such as TOTALROWS.
  

Problem conclusion

• Change internal counters to unsigned integer to allow for
  values up to 4294967295. SYSIBM.SYSTABLESPACESTATS values for
  REORGINSERTS,REORGUPDATES, REORGDELETES, STATSINSERTS,
  STATSUPDATES, and STATSDELETES are unaffected and will continue
  to have a maximum value of signed integer, 2147483647.
  The TOTALROWS column is calculated with the updated, unsigned
  internal counters and may contain a value greater than the sum
  of the external catalog table values.
  

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:

  UI68219

Modules/Macros

• DSNKCEST DSNWDFTS DSNOLROG DSNISRTI DSNURWT  DSNIDILS DSNIREPR
  DSNOLFOR DSNIRTSX DSNIKDEF DSNIRTSU DSNURFIT DSNXORTS DSNISGRT
  DSNODAL1 DSNIBHUN DSNISMRT DSNKFTOB DSNOLINS DSNOLADS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI68219

     UP20/03/13 P F003

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.