Maintaining the Host Encyclopedia › Recommended Maintenance Schedule › Weekly

Weekly

We recommend performing the following weekly maintenance tasks in the order listed:

1. Delete orphan objects from the Host Encyclopedia tables (see the How to Delete Orphan Objects section in this chapter).
2. Capture a full image-copy. A full image-copy before the REORG improves the chances for recovery in the event that the REORG fails and cannot be restarted (see the How to Capture an Image-Copy section in this chapter).
3. Reorganize the DB2 database. The job CEUREOR is provided for you to reorganize your Host Encyclopedia using IBM's DB2 REORG utility. The job CAUREOR is also provided for you to perform a DB2 REORG using CA's DB2 Rapid Reorg utility.

   Depending on the activity level your Encyclopedia experiences, you may want to reorganize some tables, such as DSUBEX, more frequently than weekly.

   To provide a point for consistent recovery (a LOG/RBA), perform a tablespace QUIESCE at the beginning of the REORG step, or start the tablespace in Utility status before starting the REORG.

4. Capture another full image-copy. The image-copy after REORG is required because the tablespaces are in copy-pending state. (CEUREOR and CAUREOR specify LOG NO to eliminate DB2 logging of the REORG.)