Forum

Appendix (1)

Invalidating statements in the dynamic statement cache

DB2 invalidates statements in the dynamic statement cache when you run RUNSTATS on objects to which those statements refer.
In a data sharing environment, the relevant statements are also invalidated in the cache of other members in the group. DB2 invalidates the cached statements to ensure that the next invocations of those statements are fully prepared and that they use the latest access path changes.
To invalidate statements in the dynamic statement cache without collecting statistics by: Specify the options UPDATE NONE and REPORT NO in the RUNSTATS utility control statement.

The following control statement specifies that RUNSTATS is to invalidate statements in the dynamic statement cache for table space DSN8D81A.DSN8S81E.
However, RUNSTATS is not to collect or report statistics or update the catalog.
[tt]RUNSTATS TABLESPACE DSN8D81A.DSN8S81E
REPORT NO
UPDATE NONE[/tt]

Or you may apply the other, the SQL method:[list bull-blackarrow][*][tt]ALTER TABLE …  AUDIT NONE[/tt][*][tt]RENAME used! INDEX[/tt][/list]