UTIL_REORG_STATISTICS_INVALIDATECACHE
The UTIL_REORG_STATISTICS_INVALIDATECACHE CM batch parameter specifies the INVALIDATECACHE option for the generated REORG TABLESPACE utility statements with inline statistics. INVALIDATECACHE indicates whether statements in the dynamic statement cache are invalidated as a result of the inline statistics collection.
If you specify the UTIL_REORG_STATISTICS_INVALIDATECACHE parameter, you must also specify UTIL_REORG_STATISTICS ='Y'.
- Values:
-
- YES or Y
- INVALIDATECACHE YES is added to the utility statement.
- NO or N
- INVALIDATECACHE NO is added to the utility statement.
- blank
- The INVALIDATECACHE option is not added to the utility statement. The Db2® default for this utility option is used.
- Default:
- blank