IBM DB2 9.7 Advanced Administration Cookbook
eBook - ePub

IBM DB2 9.7 Advanced Administration Cookbook

  1. 480 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

IBM DB2 9.7 Advanced Administration Cookbook

About this book

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.

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access IBM DB2 9.7 Advanced Administration Cookbook by Adrian Neagu, Robert Pelletier in PDF and/or ePUB format, as well as other popular books in Computer Science & Entreprise Applications. We have over one million books available in our catalogue for you to explore.

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

  1. IBM DB2 9.7 Advanced Administration Cookbook