Maintaining the production Repository database

You must perform regular maintenance tasks on the production Repository database to ensure optimal performance. The maintenance tasks cull obsolete and unwanted data and reorganize the database as necessary.

About this task

A database administrator or system programmer performs these maintenance tasks.

Procedure

  1. Run the following jobs on a regular basis to delete obsolete data, save space, and improve processing time:
    1. Run the HSISUDEL job to delete usage data that are older than a specified period.
    2. Run the HSISLDEL job to delete obsolete discovery and usage data for a specified system (LPAR).
    3. Run the HSISPDEL job to physically delete data for all systems.
    4. Run the HSISMDEL job to delete obsolete audit records that are older than a specified period.
  2. Run the following jobs on a regular basis to maintain the integrity and performance of data in the production Repository database:
    1. Run the HSISUT01 job to backup the Repository database in Db2® or backup the zFS file system in SQLite.
    2. Run the HSISUT02 job to restore the Repository database in Db2® or restore the zFS file system in SQLite.
    3. Run the HSISUT03 job to reorganize the Repository database in Db2®.
    4. Run the HSISUT04 job to update RUNSTATS statistics for the Repository database in Db2®.