To enable the DB2 database to optimize queries and find free space, update the database statistics using the runstats script.
The runstats script is located in the install_root/event/dbscripts/db2 directory.
runstats.bat db_alias db_user [db_password]
runstats.sh db_alias db_user [db_password]
For example, the following command updates the DB2 database statistics on a Windows system where the event database name is event, the database user ID is dbadmin , and the password is mypassword:
runstats.bat event dbadmin mypassword
Last updated: Tue Feb 21 17:36:51 2006
(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)