DB2 for LUW

DB2 Administration for Better Performance and Low Cost (F15) 

May 14, 2010 03:00 PM

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.

pdf file
NA10F15.pdf   446 KB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.