Cover image for Scaling DB2 UDB on Windows Server 2003.
Scaling DB2 UDB on Windows Server 2003.
Title:
Scaling DB2 UDB on Windows Server 2003.
Author:
Redbooks, IBM.
Personal Author:
Physical Description:
1 online resource (274 pages)
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.
Local Note:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2017. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Electronic Access:
Click to View
Holds: Copies: