When IBM introduced the DB2 Dynamic Statement Cache (DSC), it transformed the way dynamic SQL was tracked, traced, and tuned. As a result, DBAs can see what is running, when it runs, and who runs it: Important data – especially for performance trending, costing and tuning, with the added benefit of being useful for auditing too.
Now DB2 10 introduces new tracking capabilities for static SQL, enabling the same opportunities in the form of a “Static Statement Cache” (SSC). It is not truly a cache, but this term illustrates what finally becomes possible for static SQL. An SSC offers the same insights as the DSC. Furthermore, the DSC has been enhanced to record any SQL that is being flushed from the cache – providing unrivalled performance, tuning data, and superb auditing capabilities right out of the box! Once executed in your shop, ANY SQL can be reviewed for auditing, performance analysis, and tuning without any overhead.
Attend this webinar to learn more about utilizing these exciting new features and find out which pitfalls to avoid.