WebSphere WebSphere Enterprise Service Bus, Version 6.0.1 Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Reorganizing database tables

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 install_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_version
The DB2 Universal Database major release number; this must be either 8.1 or 8.2.1. This parameter is required.
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 running DB2 Universal Database Version 8.1 or Version 8.2.1, using the database user ID dbadmin and the password mypassword:

reorg.bat 8 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.

Task topic

Terms of Use | Rate this page

Timestamp iconLast updated: 13 Dec 2005
http://publib.boulder.ibm.com/infocenter/dmndhelp/v6rxmx/index.jsp?topic=/com.ibm.websphere.wesb.doc\doc\tcei_admin_reorg.html

(C) Copyright IBM Corporation 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)