Invalidation of cached dynamic statements
Various actions and events can invalidate statements in the dynamic statement cache. DB2® uses the full prepare process to generate new access paths for invalid cached dynamic SQL statements.
For example, the following actions can invalidate cached dynamic statements, among others:
- Changing objects referenced by the statement by issuing ALTER, REVOKE, or DROP statements.
- Collecting statistics for objects referenced by the statement with the RUNSTATS utility.