Skip to content

Db2 Table Backup and Reorganization

As with any critical set of Db2 tables it is important that the CIM, HST, and IAT tables are backed up and reorganized regularly. You should follow your site standards where this is concerned but a suggested regime for a regular job is shown below. Note that one or more of these steps may be combined by use of various keywords on the REORG TABLESPACE utility command. You should adopt whatever method is usual at your site.

  • Image Copy the tables

  • Reorganize the tables

  • Image Copy the reorganized tables

  • Execute RUNSTATS against the reorganized tables/indexes

  • ReBIND all relevant packages i.e. CMNDB2RQ and CMNRA905