Date: October 23rd, 2014
at 1pm EDST, 19.00 CEST (17:00 UTC)
Duration: 40 minutes
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
Comments