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 Business Integration Connect application
and database activity is at a minimum. As database traffic increases,
run RUNSTATS more frequently - up to once a day.
- Note:
-
- Since RUNSTATS updates database system information, lock timeouts
potentially can occur under specific circumstances. It is recommended
that the WebSphere Business Integration Connect application be quiesced and
database access be limited to running RUNSTATS.
- A lock timeout may occur when running RUNSTATS and db2rbind
simultaneously. It is recommended that these commands be run daily at
different times.
