DB2 database maintenance
If you are using a DB2 event database on Linux, UNIX, or Windows,
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: Tue Feb 21 17:19:14 2006
(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)