Articles & Content


How Big is Big Enough? Sizing OLTP Systems on DB2 U/L/W (D05)

Topic: DB2 for LUW

Subtopic: 2005

DATE: 2005-10-24 (16:15 - 17:15)
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.