After events are purged or deleted from a DB2® event database ,
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 the reorg command: 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.
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.