UTIL_RUNSTATS_INVALIDATECACHE

The UTIL_RUNSTATS_INVALIDATECACHE CM batch parameter specifies the INVALIDATECACHE option for the generated RUNSTATS utility statements. INVALIDATECACHE specifies whether the dynamic statement cache is invalidated.

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