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 the following command:
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.