Reorganizing the catalog

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.

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

  • DSNDB06.SYSCOPY
  • DSNDB06.SYSDDF
  • DSNDB06.SYSGPAUT
  • DSNDB06.SYSGRTNS
  • DSNDB06.SYSHIST
  • DSNDB06.SYSJAVA
  • DSNDB06.SYSJAUXA
  • DSNDB06.SYSJAUXB
  • DSNDB06.SYSSEQ
  • DSNDB06.SYSSEQ2
  • DSNDB06.SYSSTR
  • DSNDB06.SYSSTATS
  • Start of changeDSNDB06.SYSUSEREnd of change
  • DSNDB01.SCT02
  • DSNDB01.SPT01