Do more with less 2

“Do more with less” – webinar series

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

Part 2: Introducing use cases (engl)

(See also part 1 and part 3)

Date: April 25th,

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 Aufzeichnung (engl.)

Webinar Präsentation (engl.)


What would you like to do with all static and dynamic SQL collected, not only the dirty dozen, with nearly no overhead 24/7/365 and stored compressed in an SQL Workload Warehouse?

Using a graphical presentation layer integrated either in Eclipse native, Data Studio, or Rational.

Overview of about 20 customer ideas and short description followed by voting on which use cases should be chosen for the next “deep dive” webinar.

45-60 minutes from SOFTWARE ENGINEERING and SEGUS labs.

Overview of 8 selected use cases from about 20:

  • Application workload analysis – which machine load is produced by a certain application
  • Trending of Applications: Compare of CPU, I/O, execution rates, current KPIs and deltas – calculated and summarized to the costs of several apps
  • Object Quiet Times for maintenance (REORG)
  • Audit (Parallel user access etc.)
  • Never used objects (Plans, Collections, Packages, Tables, MQTs, VIEWs and Indexes)
  • SQL WLX KPIs – Background noise and exceptions
  • Long Delay detection
  • REORG Detector & Suppressor

Follow-up webinar:

The following webinar “Do more with less, part 3”- a deeper dive into special cases (June 6) is also designed to show what you can do with a SQL Workload Warehouse which has stored all (compressed) static and dynamic SQL 24/7/365

A deep dive into the most interesting use case(s) voted by the audience of the previous webinar will be proposed. Showing selected reports e.g. for application trending.

45-60 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 enterprise.

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.