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
Sub-topics
- 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.
Terms of use |
Last updated: Thu Apr 27 14:23:46 2006
(c) Copyright IBM Corporation 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)