After events are purged from a DB2 event database, reorganize the
database tables using the reorg script.
Why and when to perform this task
The reorg script is located in the install_root/event/dbscripts/db2 directory.
Steps for this task
To reorganize the event database tables, run one of the following
commands:
The parameters are as follows:
- db2_version
- The DB2 Universal Database major release number; this must be either 8.1 or 8.2.1.
This parameter is required.
- db_user
- The database user ID to use. This parameter is required.
- db_password
- The database password. This parameter is optional. If you do not specify
the password on the command line, the DB2 database prompts you.
Example
For example, the following command reorganizes the event database
tables on a Windows system running DB2 Universal Database Version 8.1 or Version
8.2.1, using the database user ID dbadmin and the password mypassword:
reorg.bat 8 dbadmin mypassword
What to do next
After you run the
reorg script, you should update
the database statistics using the
runstats script. For more
information, see
Updating
database statistics.