IBM DB2 9.7 Advanced Administration Cookbook

Adrian Neagu, Robert Pelletier

• Publisher: Packt Publishing
• Year: 2012
• Edition: 1
• eBook ISBN:
  9781849683326
• Topic: Computer Science
• Subtopic: Entreprise Applications
• Index: Computer Science

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.

Approach

This cookbook has recipes written in a simple, easy to understand format, with lots of screenshots and insightful tips and hints.

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.

IBM DB2 9.7 Advanced Administration Cookbook

---

Table of Contents

IBM DB2 9.7 Advanced Administration Cookbook

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. DB2 Instance—Administration and Configuration

Introduction

Creating and configuring instances for non-partitioned environments

Getting ready

How to do it...

How it works...

There's more...

Updating instances using the db2iuptd command

Creating and configuring a client instance

Getting ready…

How to do it…

How it works...

There's more...

See also

Creating and configuring an instance for multipartitioned environments

Getting ready

How to do it...

Set up NFS for sharing the instance home

Creating the instance owner and fenced user

Set up SSH for client authentication

Install DB2 ESE software with a response file option

Configuring communication for inter-partition command execution

Configuring the nodes

How it works...

There's more...

See also

Starting and stopping instances

Getting ready

How to do it...

How it works...

There's more...

Configuring SSL for client-server instance communication

Getting ready

How to do it...

How it works...

There's more...

See also

Listing and attaching to instances

Getting ready

How to do it...

Listing instances

Attaching to instances

How it works...

There's more...

See also

Dropping instances

Getting ready

How to do it...

How it works...

There's more…

2. Administration and Configuration of the DB2 Non-partitioned Database

Introduction

Creating and configuring DB2 non-partitioned databases

Getting ready

How to do it...

How it works...

There's more...

Command preview

Automatic storage

Adaptive self-tuning memory

File and directory permission on database objects

UNIX links

Default codeset

Territory

Collate using

Control files

See also

Using Configuration Advisor

Getting ready

How to do it...

How it works...

There's more...

Main configuration characteristics of OLTP databases

Main configuration characteristics of DSS databases

Main configuration characteristics of mixed processing databases

See also

Creating a database from an existing backup

Getting ready

How to do it...

How it works...

There's more...

Roll-forward recovery

Redirected restore

See also

Configuring automatic database maintenance

Getting ready

How to do it...

How it works...

There's more...

Backups

Reorgs

Runstats

See also

Managing federated databases—connecting to Oracle and MSSQL

Getting ready

How to do it...

How it works...

See also

Altering databases

How to do it…

How it works…

From Oracle to DB2

Startup/shutdown instance

Startup/shutdown database

Database file containers

Log files

How it works...

There's more...

Control files

Quiesce instance/database

Backup and recovery

Standby databases

See also

Dropping databases

Getting ready

How to do it...

How it works...

There's more...

Backup history

Keep safe

See also

3. DB2 Multipartitioned Databases—Administration and Configuration

Introduction

Creating and configuring a multipartitioned database

Getting ready

How to do it...

How it works...

There's more...

Adding database partitions

Getting ready

How to do it...

Using Control Center

Using the command line

How it works...

There's more…

Creating database partition groups

Getting ready

How to do it…

Using Control Center

Using the command line

Using Control Center

Using the command line

Create the NAV application's table spaces

How it works...

There's more...

See also

Altering database partition groups—adding partitions to database partition groups

Getting ready

How to do it...

Using Control Center

Using the command line

How it works…

There's more…

See also

Managing data redistribution on database partition groups

Getting ready

How to do it...

Using the command line

How it works…

There's more…

The table distribution key and its role in a multipartitioned environment

Getting ready

How to do it...

Using the command line

How it works...

There's more...

Table collocation

Altering database partition groups— removing partitions from a database partition group

Getting ready

How to do it...

Using the command line

How it works...

There's more...

Removing database partitions

Getting ready

How to do it...

Using Control Center

Using the command line

How it works...

There's more...

Converting a non-partitioned database to a multipartitioned database on MS Windows

Getting ready

How to do it...

How it works...

There's more...

Configuring Fast Communication Manager

Getting ready

How to do it…

How it works...

There's more...

See also

4. Storage—Using DB2 Table Spaces

Introduction

Creating and configuring t...

Table of contents

• IBM DB2 9.7 Advanced Administration Cookbook