System Generation Statements › SQL CACHE Statement—Controls SQL Caching › SQL CACHE Statement Usage

SQL CACHE Statement Usage

Dynamically changing caching attributes: All of the options that can be specified in an SQL CACHE statement can be changed dynamically by issuing SQL DML statements against CA-supplied tables. For more information, see the CA IDMS SQL Reference Guide.

Default caching status: If an SQL CACHE statement is not specified for a system, the dynamic SQL caching is disabled at system startup. SQL caching can be dynamically enabled by inserting a row into the SYSCA.SQLCACHEOPT table. For more information, see the CA IDMS SQL Reference Guide.

Specifying an exception list: You can specify an exception list of connect-names for which caching is enabled or disabled depending on what was implicitly or explicitly specified in the DEFAULT CACHING clause. If default caching is enabled, caching is disabled for any session connected to a dictionary or database whose name appears in the exception list. Conversely, if default caching is disabled, caching is enabled for any such session.