IBM DB2 9.7 Advanced Administration Cookbook

Table of Contents

• Preface

• Chapter 1: DB2 Instance—Administration and Configuration
• Introduction
• Creating and configuring instances for non-partitioned environments
• Creating and configuring a client instance
• Creating and configuring an instance for multipartitioned environments
• Starting and stopping instances
• Configuring SSL for client-server instance communication
• Listing and attaching to instances
• Dropping instances

• Chapter 2: Administration and Configuration of the DB2 Non-partitioned Database
• Introduction
• Creating and configuring DB2 non-partitioned databases
• Using Configuration Advisor
• Creating a database from an existing backup
• Configuring automatic database maintenance
• Managing federated databases—connecting to Oracle and MSSQL
• Altering databases
• Dropping databases

• Chapter 3: DB2 Multipartitioned Databases—Administration and Configuration
• Introduction
• Creating and configuring a multipartitioned database
• Adding database partitions
• Creating database partition groups
• Altering database partition groups—adding partitions to database partition groups
• Managing data redistribution on database partition groups
• The table distribution key and its role in a multipartitioned environment
• Altering database partition groups—removing partitions from a databasepartition group
• Removing database partitions
• Converting a non-partitioned database to a multipartitioned database on MS Windows
• Configuring Fast Communication Manager

• Chapter 4: Storage—Using DB2 Table Spaces
• Introduction
• Creating and configuring table spaces within automatic storage databases
• Creating and configuring SMS table spaces
• Creating and configuring DMS table spaces
• Using system temporary table spaces
• Using user temporary table spaces
• Altering table spaces and dropping table spaces
• Table spaces in a multipartitioned environment

• Chapter 5: DB2 Buffer Pools
• Introduction
• Creating and configuring buffer pools
• Configuring the block-based area
• Managing buffer pools in a multipartitioned database
• Altering buffer pools
• Dropping buffer pools

• Chapter 6: Database Objects
• Introduction
• Creating and using MDC tables and block-based indexes
• Creating and using materialized query tables
• Implementing table partitioning
• Using temporary tables
• Created global temporary table

• Chapter 7: DB2 Backup and Recovery
• Introduction
• Configuring database logging
• Performing an offline database backup
• Performing a full online database backup
• Performing an incremental delta database backup
• Performing an incremental cumulative database backup
• Backing up table spaces
• Crash recovery
• Full database recovery
• Database rollforward recovery
• Incremental restore
• Recovering table spaces—full and rollforward recovery
• Redirected restore
• Recovery history file
• Configuring tape-based backup with IBM Tivoli Storage Manager
• db2move and db2look utilities as alternative backup methods

• Chapter 8: DB2 High Availability
• Introduction
• Setting up HADR by using the command line
• Setting up HADR by using Control Center
• Changing HADR synchronization modes
• Performing takeover and takeover by force
• Using automated client rerouting with HADR
• Opening the standby database in read-only mode
• Using the DB2 fault monitor

• Chapter 9: Problem Determination, Event Sources, and Files
• Introduction
• Using db2mtrk—DB2 memory tracker
• Using db2pd—DB2 problem determination tool
• Using db2dart—DB2 database analysis and reporting tool command
• Using db2ckbkp—DB2 check backup tool for backup integrity
• Using db2support to collect diagnostic data

• Chapter 10: DB2 Security
• Introduction
• Managing instance-level authorities
• Managing database-level authorities and privileges
• Managing object privileges
• Using roles
• Using table encryption
• Using label-based access control (LBAC) to strengthen data privacy
• Auditing DB2

• Chapter 11: Connectivity and Networking
• Introduction
• Configuring network communications
• Cataloging and uncataloging instances and databases
• Using DB2 Discovery
• Communications with DRDA servers (z/OS and i/OS)
• Monitoring and configuring FCM for optimal performance

• Chapter 12: Monitoring
• Introduction
• Configuring and using system monitoring
• Configuring and using snapshot monitoring
• Configuring and using event monitoring
• Using Memory Visualizer
• Using Health Monitor

• Chapter 13: DB2 Tuning and Optimization
• Introduction and general tuning guidelines
• Operating system tuning
• Resolving CPU bottlenecks
• Tuning memory utilization
• Collecting object statistics with the RUNSTAT utility
• Default automatic statistics collection
• Tuning with indexes
• Tuning sorting
• Hit ratios and their role in performance improvement
• I/O tuning
• Using logging and nologging modes
• Using parallelism
• Loading a table
• Using EXPLAIN PLAN
• Creating a benchmark testing scenario

• Chapter 14: IBM pureScale Technology and DB2
• Introduction
• Managing instances, members, and cluster facilities in DB2 pureScale
• Monitoring DB2 pureScale environments
• High availability in DB2 pureScale environments
• Backup and recovery in DB2 pureScale environments

• Index