Maintaining a repository database

After the database is populated, a regularly scheduled maintenance plan is essential to maintain peak performance of your database.

About this task

Running the REORGs and RUNSTATS utilities on the database tables are critically important for optimal performance with Db2® databases. REORG is a database operation that is executed to reorganize the table spaces or index spaces. The purpose of the reorganization is data clustering. This operation reconstructs the data in the table spaces or index spaces, so that the data is unfragmented and physically continuous.

Procedure

To reorganize table spaces in the repository database:

  1. Go to <IBM Db2 Data Management Console installed directory>\samples\DB2LUW
  2. Locate and run the reorg.sql file against the repository database to RUNSTATS and REORG the product repository tables.