Reorganizing the Db2 catalog and directory

The REORG TABLESPACE utility can be run on all the table spaces in the catalog database (DSNDB06) to reclaim unused or wasted space, which can affect performance.

For detailed information about completing this task and other important consideration, see Reorganizing the catalog and directory.

Start of change For best results, also run the REORG TABLESPACE utility for any altered Db2 catalog objects that a CATMAINT utility job places in REORG-pending (AREO*) advisory status. End of change

The REORG TABLESPACE utility observes the PCTFREE and FREEPAGE values specified in the ALTER INDEX statement for all the catalog indexes and the following table spaces:

DSNDB06.SYSDDF
DSNDB06.SYSGPAUT
DSNDB06.SYSGRTNS
DSNDB06.SYSHIST
DSNDB06.SYSJAVA
DSNDB06.SYSJAUXA
DSNDB06.SYSJAUXB
DSNDB06.SYSSEQ
DSNDB06.SYSSEQ2
DSNDB06.SYSSTATS
DSNDB06.SYSTSCHX
DSNDB06.SYSTSCKD
DSNDB06.SYSTSCKS
DSNDB06.SYSTSCPY
DSNDB06.SYSTSSRG
DSNDB06.SYSUSER
DSNDB01.SCT02
DSNDB01.SPT01