WebSphere

Reorganizing DB2 event database tables

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.

task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 22 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic/com.ibm.websphere.cei.z.620.doc/doc/tcei_reorg.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).