Articles & Content


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

Topic: 2005 EU

Subtopic: DB2 for LUW

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

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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