Articles & Content

Archives

No Magic to Improve DB2 for z/OS Application Performance (F01)

Topic: 2007 EU

Subtopic: DB2 for z/OS



DATE: 2007-11-5 (11:15 - 12:15)
SPEAKERS: Marcel LÚvy (Natixis)

DBAs are usually familiar with programs, SQL statements and DB2 tables at their shop. But what to do when all DB2 programs are brand new for you in production? Here is the story of a large DB2 application migration from another company and how we solved several DB2 performance issues in our production system. Measurement based on DB2 accounting and RMF records was key to identify main areas for improvement. Testing and benchmarking helped to convince upper management of potential reduction in elapsed time to meet SLAs. Application Developers, Database administrators and DB2 system programmers worked together in order to transform challenges into a sucessful migration.

EXP. LEVEL: Intermediate

OBJECTIVES:

Story of a DB2 application migration

Measurement of CPU, memory and I/O resources

Understanding program logic and impact of SQL statements

Optimizing physical design with tested techniques

Solving DB2 performance issues with a task force



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.