Articles & Content


DB2 Administration for Better Performance and Low Cost (F15)

Topic: 2010 NA

Subtopic: DB2 for LUW

DATE: 2010-5-14 (11:00 AM - 12:00 PM)
SPEAKERS: Sigen Chen (Lockheed Martin)

This presentation will cover some practical aspects of improving DB2 application performance while keeping the cost low. The focus will be on choosing proper language and APIs for a given job; optimizing query and index; exploring DB2 deep compression feature; tuning key configuration parameters. The sample code and user application based benchmarking data will be presented and discussed.

EXP. LEVEL: Beginner,Intermediate,Advanced


This presentation shows how we have achieved excellent DB2 application performance under low cost.

Choosing the right programming language and API for a given job is essential. User application benchmarking data will be presented.

Writing proper query and creating the correct index is the key. Performance improvement is about double to 40+ folds.

DB2 Compression feature and its impact on space saving and performance is also tested.

Some benchmarking test data will be used to illustrate the performance impact.

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.