Events

Do more with less, part 1 introduces the enhancements provided by DB2 10 to find all your “dirty dozen” static and dynamic SQL in your applications 24/7 in an easy to use way without resource consuming DB2 monitoring and tracing.
Since DB2 V8, DBAs have been able to EXPLAIN Dynamic SQL directly from the dynamic statement cache (DSC) and are therefore able to see What is running, When it runs, and Who is running it. DB2 10 added great new capabilities to dynamic SQL caching so that even flushed SQL from the DSC can be analysed. So, for the first time, you have the complete “big picture” of dynamic SQL. However you will probably not be very happy having only “half” of your SQL house in view.

Also new with DB2 10 is the ability to build the other part of the “house". The EDM Pool now uses the same technology as the DSC. This is why we call it the Static Statement Cache (SSC). Out of the box, you have the capabilities with nearly no costs and overhead to get all SQL 24/7/365 in a very easy to use way.  

Add the capability to aggregate SQL and to compare snaps for trending etc. interfaced with modern Access Path Performance and Impact Tools, you get a powerful Swiss army knife for many purposes. Integrated in industry standards like Eclipse, Data Studio, or Rational, various IT positions can benefit across the enterprise. 
 Webinar registration 

Follow-up Webinars:

The following Webinars “Do more with less, part 2" (April 25) and "Do more with less, part 3" (June 6) are designed to show what you can do with a SQL Workload Warehouse which has stored all (compressed) static and dynamic SQL 24/7/365. SOFTWARE ENGINEERING and SEGUS got more than 20 use cases from its customers, ranging from trending of applications, over modern performance management, to audit procedures.
 

Speaker biography:

Roy Boxwell has more than 26 years of experience in MVS, OS/390, and z/OS environments – 21 of those in DB2. He specializes in installation, migration, and performance monitoring and tuning. Roy leads the SEG development team responsible for the real time database maintenance solutions. He is also an active participant and contributor on the IDUG DB2 Listserv and sends out a monthly DB2 newsletter.