• Oct 23, 2014 from 1:00pm to 1:45pm
  • Location: Online
  • Latest Activity: Sep 2, 2021

Date:      October 23rd, 2014 
               at 1pm EDST, 19.00 CEST (17:00 UTC)
Duration: 40 minutes

                Register >>

Webinar Abstract

Nothing is more expensive than a missed opportunity” (H. Jackson Brown, Jr).


This is especially true when it comes to SQL tuning!

There are many low-hanging fruits within easy grasp of anyone tasked with tuning their systems.But how do you know what is dangling within reach if you can’t see it?

Find out how a modern DB2 for z/OS SQL warehouse can collect and store all executed static and dynamic SQL (plex-wide) with basically no overhead.

By comparing SQL statements side-by-side, the “easy pickings” will immediately become apparent. But why stop there? Experts can effortlessly dig deeper and find the totally hidden gems: Disc Problem Detection, Delay Detection, Never executed SQL, SQL Timeline. Precisely pinpoint specific areas to target and get the most out of your DB2 system – while reducing costs.

 

Outlines

1 – Tuning SQL – how we’ve always done it

2 – Single SQL, package, application
3 – Tuning SQL  – year 2004 – AP comparison and 
      simulation

4 – Tuning SQL Revisited – A new methodology

5 – Harvesting the low-hanging fruit

Votes: 0
E-mail me when people leave their comments –

You need to be a member of WorldofDb2 to add comments!

Join WorldofDb2