Dynamic SQL Statement Caching Introduction Goal is to reduce or eliminate SQL Prepare operations required for dynamic SQL statements Prepare operations have become more costly over time as optimizer has become more sophisticated Implementation –Three kinds of caching Local Dynamic Statement Caching Global Dynamic Statement Caching Full Caching –Cache prepared SQL statement and statement text for dynamic SQL statements in DBM1address space Local Statement Cache Global Dynamic Statement Cache –Controlled by various parameters Bind options DSNZPARMs
{}