Fix to the way extents are calculated in SYSTABLEPART
MartinPacker 11000094DH Visits (1176)
Running out of extents for DB2 tablespaces can be a real bore. So installations like to monitor them (and I like to see them too). APAR PK12653 describes a fix to the recording of the number of extents in the SYSTABLEPART Catalog table. This fix is only available for DB2 Version 8.
RUNSTATS updates this table using the extents count in the PB0 control block. This is updated on physical data set OPEN, but not when the data set gets extended. So it can be inaccurate.
The changes are two-fold:
This should make the number a lot more accurate in SYSTABLEPART because RUNSTATS will be sampling a more accurately maintained control block field.