Scaling DB2 UDB on Windows Server 2003

Scaling DB2 UDB on Windows Server 2003

by Whei-Jen Chen, Drew Bradstock, David Ceron, Chris Fierros
Released August 2003
Publisher(s): IBM Redbooks
ISBN: None

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

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.

Table of contents

  1. Figures
  2. Tables
  3. Notices
    1. Trademarks
  4. Preface
    1. The team that wrote this redbook
      1. Acknowledgement
    2. Become a published author
    3. Comments welcome
  5. Chapter 1: Introduction
    1. Scaling overview
      1. Measuring scalability
      2. Achieving scalability
    2. Scaling with DB2 Universal Database
      1. DB2 UDB for Windows Editions
      2. Try and buy product availability
    3. Scaling with Windows Server 2003
      1. Windows Server 2003 Editions
    4. Scaling with IBM xSeries Servers
      1. IBM xSeries servers family
    5. Design considerations for scaling
      1. Planning considerations
      2. Hardware considerations
      3. Design considerations (1/2)
      4. Design considerations (2/2)
    6. Documentation
      1. PDF documentation
      2. HTML documentation
  6. Chapter 2: Utilizing the capabilities of 64-bit
    1. Migration
      1. Migrating DB2 between versions of Windows
      2. Migrating between versions of DB2 UDB
      3. Migrating from 32-bit to 64-bit
      4. Migrating everything at once
      5. Migrating back to 32-bit
      6. Migrating back to DB2 UDB V7 or V6
    2. Installation considerations
      1. Installation requirements
      2. 64-bit and 32-bit installation images
      3. Fixpaks
    3. 32-bit installation
      1. Existing references
    4. 64-bit installation
      1. Installation steps
      2. Installing DB2 UDB using a response file (1/2)
      3. Installing DB2 UDB using a response file (2/2)
      4. Creating an Instance (1/2)
      5. Creating an Instance (2/2)
      6. Removing an instance
    5. DB2 configuration
      1. Configuration levels
      2. Using the auto-configure tool (1/2)
      3. Using the auto-configure tool (2/2)
      4. Configuring memory for 64-bit systems
      5. Configuring the instance (1/2)
      6. Configuring the instance (2/2)
      7. Configuring the database (1/2)
      8. Configuring the database (2/2)
    6. Additional considerations
      1. Compatibility issues between V7 and V8
      2. Paging
  7. Chapter 3: Scaling up DB2
    1. Scale up overview
    2. Adding additional processors
      1. Can your system scale
      2. Moving from a 4-way to an n-way
      3. Windows considerations
      4. Taking advantage of greater parallelism
      5. Observing the performance change
    3. Adding additional memory
      1. Physically adding more memory
      2. Configuring Windows
      3. xSeries information
      4. Adjusting your DB2 configuration
      5. How you see how much is allocated
      6. Case studies
    4. Adding additional storage
      1. Storage and Windows Server 2003
      2. DB2 storage considerations
      3. DB2 tablespace design
      4. Database managed space
      5. DB2 DMS device considerations
      6. Using raw I/O in DB2
      7. Tablespace disk I/O
      8. Optimizing tablespace performance on RAID devices
      9. DB2 Storage Management view
      10. DB2 Health Monitor for storage management (1/2)
      11. DB2 Health Monitor for storage management (2/2)
  8. Chapter 4: Scaling out DB2
    1. Overview
      1. DB2 UDB and Windows clustering technologies
      2. Implementing very large databases on Windows platforms
      3. Cluster benefits and limitations
    2. Preparing the environment for scaling out DB2 UDB
      1. Installation overview
      2. Windows Server 2003 Domain Controller setup (1/2)
      3. Windows Server 2003 Domain Controller setup (2/2)
    3. Installing a DB2 partitioned environment
      1. Before configuring DB2 on a physical cluster environment
      2. Installing the DB2 Instance Owning Node (1/2)
      3. Installing the DB2 Instance Owning Node (2/2)
      4. Installing a physical database partition
      5. Verifying DB2 partitioning configuration
      6. Creating additional partitions and redistributing data (1/2)
      7. Creating additional partitions and redistributing data (2/2)
      8. Creating a partitioned environment with DB2 commands (1/2)
      9. Creating a partitioned environment with DB2 commands (2/2)
      10. Executing commands on all partitions
    4. Creating partitioned databases
      1. Basic database structure
      2. Database partition groups
      3. Partitioning maps and partitioning keys
      4. Partition groups and tablespaces
      5. Create database example
  9. Related publications
    1. IBM Redbooks
    2. Other publications
    3. Online resources
    4. How to get IBM Redbooks
    5. Help from IBM
  10. Index (1/3)
  11. Index (2/3)
  12. Index (3/3)
  13. Back cover

Product information

  • Title: Scaling DB2 UDB on Windows Server 2003
  • Author(s): Whei-Jen Chen, Drew Bradstock, David Ceron, Chris Fierros
  • Release date: August 2003
  • Publisher(s): IBM Redbooks
  • ISBN: None