Articles & Content


Digging for Gold - In Legacy Applications (F06)

Topic: 2010 EMEA

Subtopic: DB2 for z/OS

DATE: 2010-11-9 (14:15 - 15:15)
SPEAKERS: Meir Zohar (Solunet ACS)

Improving performance of legacy applications is often an exercise in IT archeology. Yet, some of the best opportunities for significant cost savings, lie in the applications that haven't been touched in years and occasionally decades. This presentation will describle a customer tuning project that delayed a major upgrade for over two years in the midst of a major budget challenge and will cover the methods and tools used to perform some extreme tuning of a 1980's vintage application.

EXP. LEVEL: Intermediate


Major SQL performance enhancements over the history of DB2. Over the almost 30 year history of DB2 numerous SQL enhancements have been made that many application programmers have never learned to use.

How to quickly check if your system is reasonably tuned.

Finding the "top 10" wasterful SQL statements in your applications.Response time and CPU usage. In and out of DB2. Result set sizes vs required results. Access paths and sanity checks.

SQL tuning and test made easy - tips, tricks and tools. Application tuning tools vs monitors. IBM vs ISVs

How not to repeat the exercise in 12 months time. How to train application programmers to write quality SQL.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.