DSNU1383I csect-name DYNAMIC STATEMENT CACHE WAS INVALIDATED, REASON = reason-text
Explanation
The RUNSTATS utility or another utility invalidated the dynamic statement cache for the specified objects.
Db2 invalidates the cached statement to ensure that the next invocations of the statements are fully prepared and use the latest access path changes.
- csect-name
- The name of the control section that issued the message.
- reason-text
- The reason that the statement were invalidated:
- OBJECT RESTRICTIVE STATE
- The object was in a restrictive state.
- STATIC PACAKGE INVALIDATED
- The object had pending alters.
- INVALIDATECACHE YES
- The INVALIDATECACHE keyword was specified in the RUNSTATS utility or with the STATISTICS keyword of another utility.
System action
Processing continues.
The next time that each invalidated statement is prepared, a new statement is built for the dynamic statement cache. Existing threads that already retrieved the statement from the dynamic statement cache before the statistics collection completed continue to use the same copy of the statement.
User response
No action is required.
Severity
0 (informational)
