Michael_D. 1100004WAH Visits (3059)
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.
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.
DB2 10 NFM Cat/Dir SPT01/DBD01 excessive growth related
APAR PM68842 to resolve: REORG abend. Broken aux index.
agburke 060001QPDN Visits (1632)
These two APARs address unexpected table space growth due to internal DB2 algo
· PM80804 – LOB space growth in V10 due to old read claim LRSN
PM60732: INSERT SPACE SEARCH ENHANCEMENT, USING PREFETCH TO SCAN SPACE MAP PAGES DURING EXHAUSTIVE SEARCH
KevinHarrison 1000005N52 Visits (1933)
DB2 attempts to avoid the cost of an index pageset extend by first
Symptoms include high getpages and sync I/O's
The index space map search algorithm has been enhanced to utilize