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

Updating database statistics

To enable the DB2 database to optimize queries and find free space, update the database statistics using the runstats script.

Why and when to perform this task

It is recommended that you update the database statistics regularly, and especially under any of these circumstances:

The runstats script is located in the install_root/event/dbscripts/db2 directory.

Steps for this task

To update the database statistics, run one of the following commands:
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 will prompt you for it.

Example

For example, the following command updates the DB2 database statistics on a Windows system, using the database user ID dbadmin and the password mypassword:

runstats.bat dbadmin mypassword

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_runstats.html

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