Using Dynamic SQL › Dynamic SQL Caching › Controlling the Cache

Controlling the Cache

There are various ways that an individual user and a DBA can control dynamic SQL caching. Three ways are discussed following:

• Establishing caching attributes for an individual SQL session by issuing a SET SESSION statement
• Establishing default caching attributes for a central version through a system generation SQL CACHE statement
• Establishing default caching attributes for a local mode job by specifying a SYSIDMS SQL_CACHE_ENTRIES parameter.

Note: For more information about the SET SESSION statement, the various tables that control caching and examples of how to display and control the cache using SQL, see the CA IDMS SQL Reference Guide. For more information about the SQL CACHE system generation statement, see the CA IDMS System Generation Guide. For more information about SYSIDMS parameter SQL_CACHE_ENTRIES, see the CA IDMS Common Facilities Guide.