Name: IBM DB2 9.7 Advanced Administration Cookbook
Author: Adrian Neagu Robert Pelletier
ISBN: 9781849683333

微信读书书城IBM DB2 9.7 Advanced Administration Cookbook

首页我的书架登录

翻译完成

切换

IBM DB2 9.7 Advanced Administration Cookbook

Adrian Neagu Robert Pelletier

扉页
coverpage
+书签
IBM DB2 9.7 Advanced Administration Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
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 database partition 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

简介

版权

IBM DB2 9.7 Advanced Administration Cookbook