Articles & Content

Archives

The Caveman Chronicles: How We Took our DB Performance from Ice Age to New Age!! (C11)

Topic: DB2 for LUW

Subtopic: 2010



DATE: 2010-5-13 (01:30 PM - 02:30 PM)
SPEAKERS: Brad Price (Werner Enterprises)

Tackling overall database performance can be a formidable task when there are multiple underlying causes. By identifying and prioritizing the improvements to be made to our databases at Werner, we've been able to achieve a 75% improvement in overall query time. Come take a look at how we brought significantly improved performance to our databases. Some of the changes we've made to our environment may very well be helpful for you!

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Learn how to identify the root causes of poor performance and then prioritize a reasonably sane approach to addressing those root causes.

See some of the challenges and details involved with migrating a set of databases to an entirely new hardware platform, new OS and new DB2 version all at once.

See our experiences with STMM and how it helped us initially, but why we eventually turned most of it off.

DB2 Compression was applied after the migration. See options for how to deploy compression and the resulting performance boost.

Identifying clustering indexes and MDCs are providing the next overall performance improvement for us.



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.