Skip to Content
Information
Important We are integrating BMC AMI LOBMaster technology into the BMC AMI Reorg product and discontinuing BMC AMI LOBMaster as a separate product. For the latest integrated documentation, see BMC AMI Reorg for Db2 13.1.

INVALIDATECACHE

(BMC.DB2.SPE2407)

The INVALIDATECACHE option indicates whether the SQL Statements in the dynamic cache should be invalidated for the processing object.


Related topics

REORG-TABLESPACE-syntax-diagrams

REORG-TABLESPACE-option-descriptions

BMC-AMI-Reorg-parameters-RRGPARMS-DD-RRGPARMX-DD

INVALIDATECACH

image-2024-4-29_10-50-3.png

Value

Description

Yes

Tells BMC AMI Reorg to invalidate the SQL statements in the dynamic statement cache. 

No

Tells BMC AMI Reorg not to invalidate the SQL statements in the dynamic statement cache.

Warning

Important

  • BMC AMI Reorg changes NO to YES when REORG REBALANCE or REORG DDLIN is specified, invalidating the dynamic statement cache in all cases. It doesn't matter if INVALIDATECACHE (YES|NO), +INVALIDATECACH (YES|NO), or both are specified.
  • If you specify INVALIDATECACHE (YES), the dynamic statement cache is invalidated. It doesn't matter if +INVALIDATECACH (YES|NO) is specified.
  • If you specify INVALIDATECACHE (NO), the dynamic statement cache is not invalidated. It doesn't matter if +INVALIDATECACH (YES|NO) is specified.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Reorg for Db2 13.1