Articles & Content


How Big is Big Enough? A Primer on Sizing OLTP Systems on DB2 for Linux , UNIX, Windows (J03)

Topic: DB2 for LUW

Subtopic: 2006

DATE: 2006-5-8 (04:00 PM - 05:10 PM)
SPEAKERS: Steve Rees (IBM Toronto Lab)

You're planning a new DB2 system - how much CPU, memory and disk it will need? Estimating accurately will give you the best return on your investment, but estimating poorly can get your project off to a rocky start. We will look at ways to make your DB2 sizings more accurate, such as by focusing on your system's high-impact aspects, factoring in published benchmarks, reducing sources of error, and microbenchmarking.

EXP. LEVEL: Beginner,Intermediate


Finding the high-impact areas of your new system

Factoring in choices of platform/OS/storage

Judiciously applying published benchmark results

Identifying and controlling sources of error

Refining your estimate through experimentation

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.