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.
Director of Solutions Delivery, SEGUS Inc
Senior DB2 Software Architect, SOFTWARE ENGINEERING GmbH
Comments