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 profile_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_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 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.

Terms of use |

Last updated: Tue Feb 21 17:19:16 2006

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