Articles & Content

Archives

DB2 Administration for Better Performance and Low Cost (F15)

Topic: DB2 for LUW

Subtopic: 2010



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

OBJECTIVES:

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.



Click Here to Download

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