Scaling DB2 UDB on Windows Server 2003
An IBM Redbooks publication
Note: This is publication is now archived. For reference only.
Published on 22 August 2003, updated 04 November 2003
ISBN-10: 0738499676
ISBN-13: 9780738499673
IBM Form #: SG24-7019-00
Authors: Whei-Jen Chen, Drew Bradstock, David Ceron and Chris Fierros
As organizations strive to do more with less, DB2 Universal Database v8.1 on Windows Server 2003 brings unprecedented enterprise-class scalability to 32-bit and 64-bit Intel platforms. Supporting both vertical (scale up) and horizontal (scale out) scaling, DB2 UDB v8.1 represents over a decade of industry proven scalability with both non-clustered and clustered database architectures.
This IBM Redbooks publication is designed as an informative guide to scaling DB2 UDB V8.1 with Windows Server 2003. It is intended for database and system administrators who need both an introduction and detailed information on scaling DB2 UDB on Windows Server 2003.
We begin with an overview to scalability including the goals, measurements, and common approaches. We introduce the scalability features of DB2 UDB, Windows Server 2003, and the IBM xSeries Servers followed by some design considerations for scaling. We dedicate an entire chapter to running DB2 UDB on 64-bit Windows including installation, configuration, and 64-bit migration techniques. We discuss scaling up and how to leverage large memory support in a 32-bit environments. Finally, we include a chapter on scaling out including adding logical and physical database partitions.
Chapter 1. Introduction
Chapter 2. Utilizing the capabilities of 64-bit
Chapter 3. Scaling up DB2
Chapter 4. Scaling out DB2