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
Procedure
To reorganize table spaces in the repository database:
- Go to <IBM Db2 Data Management Console installed directory>\samples\DB2LUW
- Locate and run the reorg.sql file against the repository database to RUNSTATS and REORG the product repository tables.