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.

+INVALIDATECACH


(BMC.DB2.SPE2407)

The +INVALIDATECACH option indicates whether the SQL statements in the dynamic cache should be invalidated for the processing object.

Important

  • If +INVALIDATECACH (YES) is specified, the dynamic statement cache is invalidated.
  • If +INVALIDATECACH (NO) is specified, the dynamic statement cache is not invalidated.
  • If nothing is specified, the dynamic statement cache is not invalidated.


Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

Example
+INVALIDATECACH(YES)

 

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