Top 20 DB2 Performance Myths 2006: Demystified

Wednesday, 14 June, 2006 - 11:45 - 13:15
Susan Lawson

The New Speed Factor - V8 Multi-row processing

Wednesday, 14 June, 2006 - 11:00 - 11:45
Maria Sarikos

A-Z of Performance

Wednesday, 14 June, 2006 - 09:45 - 10:45
Phil Grainger

Optimizing Dynamic Queries

Wednesday, 14 June, 2006 - 09:00 - 09:45
Namik Hrle

The number of applications using dynamic SQL is increasing. The large enterprise systems such as SAP are based on this flexible way of accessing databases. However, the flexibility is coupled with additional challenges when it comes to resources utilization, performance monitoring and tuning. Caching of the dynamic SQL statements, impact on virtual storage, reoptimization and EXPLAIN considerations need to be understood in order to take advantage of the feature and ensure optimal execution for the applications that use dynamic SQL.
This presentation will help you gain that understanding.

To Reorg or not to Reorg (is not the question anymore)

Tuesday, 13 June, 2006 - 16:45 - 17:15
Mirna Kos

Problems  concerning  daily  database maintenance are down to big amount of necessary  out-of-working-hours  DBA  time.  Solution  to  this problem is automation  of  maintenance jobs. After automating execution of imagecopies and  runstats jobs, DBA in Zagrebačka banka implemented complete automation of index and tablespace reorganization. Through  numerous  planning and categorization steps we managed to elaborate in  detail  schedule  and  prerequisites  for  a database/table/application reorganization.   We  used  standard  DB2  utility  jobs  and standard z/OS capabilities  to  devise  the  way  the  jobs  are executed, execution time control,  as  well as error and abend control. All solutions with examples, as well as imperfections and shortcomings and potential future enhancements are topic of this presentation.

DB2 V8 Experiences – Access path patterns

Tuesday, 13 June, 2006 - 16:00 - 16:45
Dirk Johann

Full Presentation Abstract:
The DB2 V8 Optimizer has many enhancements under the hood. As DBAs it is our nature to care about performance implications during migration. At several customers, we implemented procedures that kept us in control of access paths and insured good SQL performance before V8 migration. In this presentation, I will show the methodology we used to implement a V8 early precheck of all dynamic and static SQL while still on a production V7 system. Not only were we able to predict and evaluate the resulting V8 access paths, we also determined that patterns of expected access path changes will occur using the V8 Optimizer. By making such Optimizer decisions transparent, we took our performance-securing measures one step further. By using the results of the early precheck in combination with the new function of the V8 RUNSTATS utility regarding the column distribution statistics and skewed columns, we were able to influence Optimizer decisions under V8.

Presentation Outline:
1.Comparing access path changes between two DB2 Versions: the procedure
Simulating a V8 comparison environment
Evaluating V7 and V8 differences
2.A look at specific types of access path changes that are typical under V8
Static SQL
Dynamic SQL
3.Risk control management
Pinpointing which access path changes are relevant
Securing access paths under V8
4.Exploiting V8 Column Distribution Stats
Nourishing the V8 Optimizer with extended statistics
And, how early recognition of expected access path changes can help
Presentation Bullet Points:
Stage a V8 environment in which to do an SQL performance early precheck
Identify the Optimizer differences between V7 and V8
Show expected access path changes when migrating
Show access path change patterns for static and dynamic SQL
Opportunities to secure application performance using extended features of the V8 RUNSTATS

Utilities for Applications Developers

Tuesday, 13 June, 2006 - 12:15 - 13:15
Phil Grainger

The Trinity -DB2, DB2 Connect & WebSphere

Tuesday, 13 June, 2006 - 11:00 - 12:15
Maria Sarikos

DB2 V next

Tuesday, 13 June, 2006 - 09:45 - 10:45
Namik Hrle

DB2 V9 is the new feature-packed release of the IBM's industry-leading mainframe data server. It introduces numerous enhancements in database administration, particularly backup/recovery, reorganization and space management, as well as various performance and programming improvements.
Rich new SQL capabilities, increased security and regulatory compliance, database on demand capabilities, performance-boosting innovations for varying length data, improved logging and inserts are only some of the features brought by DB2 V9.
This presentation will give you an overview of DB2 V9 and demonstrate benefits you can expect from migrating to the new release.

Syndicate content  


SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2019

Ljubljana - 9th & 10th April 2019
Belgrade - 12th April 2019
Šibenik - 26th - 30th May 2019
Zagreb - 26th September 2019
Opatija - 28th & 29th November 2019