Updated list of APARs for excessive SPT01/DBD01 growth – Base and LOB tablespaces - including related Utility APARs
Customers running with DB2 10 NFM have noticed that table spaces associated with the DB2 directory data base or catalog (DSNDB01 and SPT01) experience significant space growth resulting from BIND/REBIND operations, DDL, utility activity (Reorg). The only way customer could sustain the issue was by frequently scheduling reorgs on the DB2 directory and catalog in DB2 10 NFM.
With APAR PM64226 DB2 10 code has been changed to allow the deleted LOB space to more quickly be reused by an inserter that is running in the same data sharing member without dependence upon the global read claim LRSN. This change is limited to LOB table spaces residing within the DB2 directory data base (DSNDB01),DSNDB01.SYSDBDXA, DSNDB01.SYSSPUXA, DSNDB01.SYSSPUXB.
However, this only addresses the space growth for DB2 directory and catalog LOB data bases.
Updated list of APARs for excessive SPT01/DBD01 growth – Base and LOB tablespaces - including related Utility APARs in this area!
DB2 10 NFM Cat/Dir SPT01/DBD01 excessive growth
APAR PM66874 to resolve: LOB integrity abend during REORG of DBD01.
APAR PM64226 to resolve: LOBs issue with catalog/directory space growth.
APAR PM74659 For the base SPT01/DBDXA growth - space reuse enhancement
APAR PM81485 more enforcement in roll back process to prevent other INSERT UR to reuse the free space
APAR PM77611 to resolve: Basing chain issue of PM79266
APAR PM79266 Rollback fix for the reuse of pseudo deleted space
APAR PM75921 Candidate page lookup enhancement will drive more exhaustively search for insertion within the table
DB2 10 NFM Cat/Dir SPT01/DBD01 excessive growth related
APAR PM68842 to resolve: REORG abend. Broken aux index.