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 profile_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_alias
- The database alias. The event database must be catalogued on the DB2 client;
if you are running the script on the DB2 server, the database is already catalogued.
- 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 , using the database user ID dbadmin,
the password mypassword, and the database name is event:
reorg.bat event 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.