After events are purged or deleted from a DB2® event database on Linux®, UNIX®, or Windows®,
you can reorganize the database tables using the reorg script.
About this task
The reorg script is located in the profile_root/event/node_name/server_name or cluster_name/dbscripts/db2
directory.
Procedure
To reorganize the event database tables,
run one of the following commands:
The parameters are as follows:
- db_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 for it.
Example
For example, the following command reorganizes
the event database tables on a Windows system,
using the database alias
eventdb, user ID
dbadmin ,
and the password
mypassword:
reorg.bat eventdb dbadmin mypassword
What to do next
After running the
reorg script, you should update
the database statistics using the
runstats script. For more
information, see
Updating DB2 event database statistics.