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.
- 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.