Previous Topic: SQL Cache TablesNext Topic: Tables for Viewing, Monitoring, and Controlling the Cache


Overview

This appendix describes the table procedures that are used for displaying and controlling the SQL cache. It also provides some examples of how the DBA can display and control the cache. The SQL cache is used in conjunction with the dynamic SQL statement caching feature. Dynamic SQL and dynamic SQL statement caching is explained in the CA IDMS SQL Programming Guide.