Webinars on Thurs, Nov. 6th: 'Optimizing Dynamic SQL & DB2 Index Design'

Chris Straub

Webinars on Thurs, Nov. 6th: 'Optimizing Dynamic SQL & DB2 Index Design'
I received this email for a couple of free webinars and I wanted to pass
them along.

To register for either or both of these one hour webinars, please visit the
following url:

Webinar #1:
Thurs, Nov 6th, 12:00PM - 1:00PM Eastern Time: 'Intro to EZ-DB2: Reveal the
hidden Impact of Dynamic SQL'

Are you concerned about the impact of Dynamic SQL on DB2 performance? Would
you like to pin-point and control this ?hidden cost?? Dynamic SQL is used
everywhere. It is generated by in-house applications, reporting tools, ERP
systems and other distributed applications. Unfortunately, the Dynamic SQL
workload is a 'black box'. There is simply no good way to get a handle on
overall impact of a Dynamic SQL Workload. Massive DB2 CPU resource is being
consumed and the organization doesn't understand where and by what!

The problem with Dynamic SQL lies in the fact that 'otherwise identical'
statements appear to be different for many reasons. For example, the
application generating the SQL might:
*embed different literals in different instances of the same statement
*use different numbers of spaces between tokens in different instances of
the same statement
*reverse the order of table names in different instances of the same join
*use different numbers of IN List values in different instances of the same

There are many other examples of how 'otherwise identical' statements can
appear to be different. What if you could see that beyond these trivial
differences to see that thousands of SQL statements are actually the same?
What if you could group all instances of 'otherwise identical' statements
into 'Consolidated' statements and for each statement see Total CPU, Total
Get Pages, Total number of executions, etc? What if you could see that
otherwise innocuous statements run tens of thousands of times each day and
consume huge CPU resource? Each is a hidden and real tuning opportunity.
EZ-DB2 quickly identifies these top offenders and performance tuning

The EZ-DB2 Development Team invites you to join a technical discussion and
demonstration of a unique solution for capturing, analyzing and tuning
Dynamic and Static SQL Workloads. Learn about EZ-DB2 and its unique
patented SQL Consolidation feature that has everyone talking!

Webinar #2:
Thurs, Nov 6th, 1:00PM-2:00PM Eastern Time: 'Index Analysis and
Optimization with EZ-DB2'

DB2 index design optimization offers perhaps the single greatest
opportunity to improve individual SQL as well as overall system
performance. Maintaining an optimal index design, however, requires
continuous reevaluation of the design against a constantly changing
application environment (i.e. SQL Workload). It is simply not feasible for
a DBA team to consider all possible index permutations at a point in time,
and to re-perform this exercise on an ongoing basis. Automation is a
necessity. EZ-Index Analyzer and EZ-Index Optimizer (EZ-XOP) are the
industry?s leading solutions for index design optimization. EZ-Index
Analyzer and EZ-XOP are used to optimize the index design of both home
grown databases as well as those underlying complex off the shelf
applications such as PeopleSoft and SAP.

EZ-Index Analyzer and EZ-XOP are workload-centric optimization solutions.
Both make recommendations from the perspective of your existing SQL
workload(s) taking into account not just individual SQL statements, but
also frequency of execution.

EZ-Index Analyzer determines how well your SQL Statements are served by
your existing Index design. EZ-Index Analyzer lists 'used' and 'not used'
indexes, analyzes the predicates used in SQL Statements against the
existing Index design, identifies where new and/or modified indexes would
improve performance, and reveals where different predicates would make
better use of existing Indexes.

EZ-XOP takes a clean slate approach to index design. In a sandbox
environment, EZ-XOP drops the existing index design and uses patented
algorithms and evolutionary techniques to establish and evaluate all
possible index combinations. EZ-XOP Interacts with the DB2 Optimizer to
re-cost the SQL workload across alternative index combinations. Through a
complex sequence of iterations it evolves the optimal index design for a
given workload and presents this back to the user with respect to the
existing index design. Index tuning per EZ-XOP recommendations yields a
dramatic improvement in system performance and resource utilization.

Welcome to the DB2 User Group - Pittsburgh list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/DB2-UG-Pittsburgh.html. From that page select "Join or Leave the list". The IDUG Listserv FAQ is at http://www.idugdb2-l.org. The DB2 User Group - Pittsburgh List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm