Scaling DB2 UDB on Windows Server 2003 / Whei-Jen Chen ... [et al.].

Format:

Book

Contributor:

Chen, Whei-Jen.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Database management.

IBM Database 2.

Microsoft Windows server.

Physical Description:

xviii, 250 p. : ill.

Edition:

1st ed.

Place of Publication:

San Jose, CA : IBM, International Technical Support Organization, c2003.

Language Note:

English

Contents:

Front cover

Contents

Figures

Tables

Notices

Trademarks

Preface

The team that wrote this redbook

Acknowledgement

Become a published author

Comments welcome

Chapter 1. Introduction

1.1 Scaling overview

1.1.1 Measuring scalability

1.1.2 Achieving scalability

1.2 Scaling with DB2 Universal Database

1.2.1 DB2 UDB for Windows Editions

1.2.2 Try and buy product availability

1.3 Scaling with Windows Server 2003

1.3.1 Windows Server 2003 Editions

1.4 Scaling with IBM xSeries Servers

1.4.1 IBM xSeries servers family

1.5 Design considerations for scaling

1.5.1 Planning considerations

1.5.2 Hardware considerations

1.5.3 Design considerations

1.6 Documentation

1.6.1 PDF documentation

1.6.2 HTML documentation

Chapter 2. Utilizing the capabilities of 64-bit

2.1 Migration

2.1.1 Migrating DB2 between versions of Windows

2.1.2 Migrating between versions of DB2 UDB

2.1.3 Migrating from 32-bit to 64-bit

2.1.4 Migrating everything at once

2.1.5 Migrating back to 32-bit

2.1.6 Migrating back to DB2 UDB V7 or V6

2.2 Installation considerations

2.2.1 Installation requirements

2.2.2 64-bit and 32-bit installation images

2.2.3 Fixpaks

2.3 32-bit installation

2.3.1 Existing references

2.4 64-bit installation

2.4.1 Installation steps

2.4.2 Installing DB2 UDB using a response file

2.4.3 Creating an Instance

2.4.4 Removing an instance

2.5 DB2 configuration

2.5.1 Configuration levels

2.5.2 Using the auto-configure tool

2.5.3 Configuring memory for 64-bit systems

2.5.4 Configuring the instance

2.5.5 Configuring the database

2.6 Additional considerations

2.6.1 Compatibility issues between V7 and V8

2.6.2 Paging

Chapter 3. Scaling up DB2

3.1 Scale up overview

3.2 Adding additional processors.

3.2.1 Can your system scale

3.2.2 Moving from a 4-way to an n-way

3.2.3 Windows considerations

3.2.4 Taking advantage of greater parallelism

3.2.5 Observing the performance change

3.3 Adding additional memory

3.3.1 Physically adding more memory

3.3.2 Configuring Windows

3.3.3 xSeries information

3.3.4 Adjusting your DB2 configuration

3.3.5 How you see how much is allocated

3.3.6 Case studies

3.4 Adding additional storage

3.4.1 Storage and Windows Server 2003

3.4.2 DB2 storage considerations

3.4.3 DB2 tablespace design

3.4.4 Database managed space

3.4.5 DB2 DMS device considerations

3.4.6 Using raw I/O in DB2

3.4.7 Tablespace disk I/O

3.4.8 Optimizing tablespace performance on RAID devices

3.4.9 DB2 Storage Management view

3.4.10 DB2 Health Monitor for storage management

Chapter 4. Scaling out DB2

4.1 Overview

4.1.1 DB2 UDB and Windows clustering technologies

4.1.2 Implementing very large databases on Windows platforms

4.1.3 Cluster benefits and limitations

4.2 Preparing the environment for scaling out DB2 UDB

4.2.1 Installation overview

4.2.2 Windows Server 2003 Domain Controller setup

4.3 Installing a DB2 partitioned environment

4.3.1 Before configuring DB2 on a physical cluster environment

4.3.2 Installing the DB2 Instance Owning Node

4.3.3 Installing a physical database partition

4.3.4 Verifying DB2 partitioning configuration

4.3.5 Creating additional partitions and redistributing data

4.3.6 Creating a partitioned environment with DB2 commands

4.3.7 Executing commands on all partitions

4.4 Creating partitioned databases

4.4.1 Basic database structure

4.4.2 Database partition groups

4.4.3 Partitioning maps and partitioning keys

4.4.4 Partition groups and tablespaces

4.4.5 Create database example

Related publications.

IBM Redbooks

Other publications

Online resources

How to get IBM Redbooks

Help from IBM

Index

Back cover.

Notes:

"August 2003."

"SG24-7019-00."

Includes bibliographical references (p. 239-241) and index.

OCLC:

560101442