Free Sample
+ Collection

IBM DB2 9.7 Advanced Administration Cookbook

Cookbook
Adrian Neagu, Robert Pelletier

Over 100 recipes focused on advanced administration tasks to build and configure powerful databases with IBM DB2 book and ebook
$38.99
$64.99
RRP $38.99
RRP $64.99
eBook
Print + eBook

Want this title & more?

$16.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849683326
Paperback480 pages

About This Book

  • Master all the important aspects of administration from instances to IBM’s newest High Availability technology pureScale with this book and e-book.
  • Learn to implement key security features to harden your database's security against hackers and intruders.
  • Empower your databases by building efficient data configuration using MDC and clustered tables.

Who This Book Is For

If you are a DB2 Database Administrator who wants to understand and get hands on with the underlying aspects of database administration, then this book is for you.

This book assumes that you have a basic understanding of DB2 database concepts.

Table of Contents

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
Getting ready
How to do it...
How it works...
There's more...
See also
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

What You Will Learn

  • Learn to make best use of scalability with multi-partitioned databases
  • Get to grips with advanced technological breakthroughs with RBAC, and pureScale technology
  • Sharpen your troubleshooting skills
  • Design and implement the best backup strategy
  • Master the new exciting features added to the DB2 9.7 version
  • Get step-by-step instructions to tune and optimize DB2 to achieve best performance
  • Understand the database objects and their integration

In Detail

IBM DB2 LUW is a leading relational database system developed by IBM. DB2 LUW database software offers industry leading performance, scale, and reliability on your choice of platform on various Linux distributions, leading Unix Systems like AIX, HP-UX and Solaris and MS Windows platforms. With lots of new features, DB2 9.7 delivers one the best relational database systems in the market.

IBM DB2 9.7 Advanced Administration Cookbook covers all the latest features with instance creation, setup, and administration of multi-partitioned database.

This practical cookbook provides step-by-step instructions to build and configure powerful databases, with scalability, safety and reliability features, using industry standard best practices.

This book will walk you through all the important aspects of administration. You will learn to set up production capable environments with multi-partitioned databases and make the best use of hardware resources for maximum performance.

With this guide you can master the different ways to implement strong databases with a High Availability architecture.

Authors

Read More

Recommended for You

IBM Rational ClearCase 7.0: Master the Tools That Monitor, Analyze, and Manage Software Configurations
$ 32.99