DB2 database maintenance
If you are using a DB2 event database, you should periodically
perform database maintenance by running the provided scripts.
The DB2 versions currently supported for running these maintenance scripts
are
- DB2 Universal Version 8.1
- DB2 Universal Version 8.2.1
- Updating database statistics
To enable the DB2 database to optimize queries and find free space, update the database statistics using the runstats script.
- Reorganizing database tables
After events are purged from a DB2 event database, reorganize the database tables using the reorg script.
(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)