Do more with less 3

“Do more with less” – webinar series

Basic DB2 10 technology, SQL Workload Analysis and relevant use cases

Part 3: Deep dive into the Winners of the voting from part 2 (engl)

(See also part 1 and part 2)

Date: June 6th

Time: 19:00 Paris, Berlin, Madrid, CEST (Central European Summer Time)
1pm New York, EDT (Eastern Daylight Saving Time)
6pm London, BST (British Summer Time)

Webinar Präsentation
Webinar Aufzeichnung


The following webinar “Do more with less, part 3” is dedicated to the winners of the voting from “Do more with less”, part 2 on DB2 SQL Workload Analysis.

The Winners are:
– Application Workload Analysis
– Trending of Application
– KPIs
Discussion of the voted use cases. Showing interactive reports e.g. for application trending.

30-45 minutes SOFTWARE ENGINEERING and large DB2 customer.

Introductory webinar:

“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 enterprises.

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.