Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • IBM DB2 9.7 Advanced Administration Cookbook
  • Toc
  • feedback
IBM DB2 9.7 Advanced Administration Cookbook

IBM DB2 9.7 Advanced Administration Cookbook

4.5 (8)
close
IBM DB2 9.7 Advanced Administration Cookbook

IBM DB2 9.7 Advanced Administration Cookbook

4.5 (8)

Overview of this book

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.
Table of Contents (21 chapters)
close
close
IBM DB2 9.7 Advanced Administration Cookbook
IBM DB2 9.7 Advanced Administration Cookbook
Credits
Credits
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
DB2 Instance—Administration and Configuration
chevron up
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
2
Administration and Configuration of the DB2 Non-partitioned Database
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
3
DB2 Multipartitioned Databases—Administration and Configuration
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
4
Storage—Using DB2 Table Spaces
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
5
DB2 Buffer Pools
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
6
Database Objects
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
7
DB2 Backup and Recovery
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
8
DB2 High Availability
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
9
Problem Determination, Event Sources, and Files
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
10
DB2 Security
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
11
Connectivity and Networking
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
12
Monitoring
Monitoring
Introduction
Configuring and using system monitoring
Configuring and using snapshot monitoring
Configuring and using event monitoring
Using Memory Visualizer
Using Health Monitor
13
DB2 Tuning and Optimization
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
14
IBM pureScale Technology and DB2
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
Index

Starting and stopping instances

There are several situations in which an instance must be stopped and started, for example, after you change some parameters that are not dynamic, or after applying a fixpack.

Getting ready

We have, at disposal, a couple of different ways to start or stop an instance. We can use, say, db2start for starting and db2stop for stopping; these commands are available for execution in the command line or from DB2 CLI. We can also start or stop an instance from the Control Center. In Windows, you can also start and stop an instance by starting and stopping the service associated with it.

How to do it...

  1. The current instance is set by the environment variable DB2INSTANCE or the global registry variable DB2INSTDEF, in case DB2INSTANCE is not set. This is applicable mostly for Microsoft Windows platforms where there could be more than one instance per user.

    • On Microsoft Windows:

      C:\Documents and Settings>db2ilist
DB2_02
DB2WIN
C:\Documents and Settings>set DB2INSTANCE
DB2INSTANCE=DB2_02

    Now, if we issue db2stop or db2start, only instance DB2_02 will be affected.

    • On our Linux server nodedb21:

      		[db2inst1@nodedb21 ~]$ echo $DB2INSTANCE
		db2inst1

  2. As the db2inst1 instance owner, stop instance db2inst1 with the db2stop command, and start it with db2start:

    [db2inst1@nodedb21 ~]$ db2stop
06/09/2011 17:55:21     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.
[db2inst1@nodedb21 ~]$ db2start
06/09/2011 17:55:29     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.

  3. As the multipartitioned instance owner db2instp, stop instance db2instp with the db2stop command, and start it with db2start:

    [db2instp@nodedb21 sqllib]$ db2stop
06/09/2011 19:03:47     1   0   SQL1064N  DB2STOP processing was successful.
06/09/2011 19:03:48     0   0   SQL1064N  DB2STOP processing was successful.
06/09/2011 19:03:49     2   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.
[db2instp@nodedb21 sqllib]$ db2start
06/09/2011 19:04:02     1   0   SQL1063N  DB2START processing was successful.
06/09/2011 19:04:06     2   0   SQL1063N  DB2START processing was successful.
06/09/2011 19:04:06     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.

  4. Using the Control Center, right-click on db2inst1 and issue stop and start.

How it works...

In the process of starting an instance, memory structures are allocated and the instance starts listening for connections on the ports assigned by the SVCENAME database manager configuration parameter. At stop, existing connections are disconnected and memory is deallocated.

There's more...

Other options that can be used to start and stop an instance are the DB2 CLI commands, START DATABASE MANAGER and STOP DATABASE MANAGER. For Windows, we have as alternate option to start or stop the service associated with the instance. To set the instance for automatic start on Linux or Unix, at system boot, you can use the instance-level registry variable DB2AUTOSTART=YES or the db2iauto –on <instance name> command.

End of Section 6
Next Section
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete