Optimizing
database query performance
The RUNSTATS command updates the database query access
plan for each table and index. To optimize database query performance,
run RUNSTATS at least once a week when IBM WebSphere Partner Gateway
application and database activity is at a minimum. As database traffic
increases, run RUNSTATS more frequently, up to once a day.
Notes:
- Since RUNSTATS updates database system information, lock timeouts
potentially can occur under specific circumstances. The WebSphere
Partner Gateway application be quiesced and database access be limited
to running RUNSTATS.
- A lock timeout may occur when RUNSTATS and db2rbind are run simultaneously.
It is recommended that these commands be run daily at different times.
