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 old usage data, save space, and improve processing time:
    1. Run the HZASUDEL job to delete usage data that are older than a specified period.
    2. Run the HZASLDEL job to delete obsolete discovery and usage data for a specified system (LPAR).
    3. Run the HZASPDEL job to physically delete data for all systems.
    4. Run the HZASTPRM job to reset the status flag back to normal for tables in the production Repository database, following a failure.
    5. Run the HZASIVP job to verify database changes since the product was released.
  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 HZASUT01 job to backup the Repository database in Db2® or backup the zFS file system in SQLite.
    2. Run the HZASUT02 job to restore the Repository database in Db2® or restore the zFS file system in SQLite.
    3. Run the HZASUT03 job to reorganize the Repository database in Db2®.
    4. Run the HZASUT04 job to update RUNSTATS statistics for the Repository database in Db2®.