WebSphere

Updating DB2 event database statistics

To enable a DB2® database to optimize queries and find free space, you can update the database statistics by running the runstats script.

About this task

Updating DB2 database statistics is recommended on a regular basis, and especially under any of the following circumstances:

The runstats script is located in the profile_root/event/node_name/server_name or cluster_name/dbscripts/db2 directory.

Procedure
To update the database statistics, run runstats command:
The parameters are as follows:
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.

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_runstats.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).