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:
  1. 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.
  2. A lock timeout may occur when RUNSTATS and db2rbind are run simultaneously. It is recommended that these commands be run daily at different times.

Copyright IBM Corp. 2003, 2005