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

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying IBM DB2 9.7 Advanced Administration Cookbook
  • Table Of Contents Toc
IBM DB2 9.7 Advanced Administration Cookbook

IBM DB2 9.7 Advanced Administration Cookbook

By : Adrian Neagu, Robert Pelletier
4.5 (8)
Buy this Book
close
close
IBM DB2 9.7 Advanced Administration Cookbook

IBM DB2 9.7 Advanced Administration Cookbook

4.5 (8)
By: Adrian Neagu, Robert Pelletier
Buy this Book

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
close
IBM DB2 9.7 Advanced Administration Cookbook
Icon
IBM DB2 9.7 Advanced Administration Cookbook
Credits
Icon
Credits
About the Authors
Icon
About the Authors
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Lock Free Chapter
1
DB2 Instance—Administration and Configuration
Icon
DB2 Instance—Administration and Configuration
Icon
Introduction
Icon
Creating and configuring instances for non-partitioned environments
Icon
Creating and configuring a client instance
Icon
Creating and configuring an instance for multipartitioned environments
Icon
Starting and stopping instances
Icon
Configuring SSL for client-server instance communication
Icon
Listing and attaching to instances
Icon
Dropping instances
2
Administration and Configuration of the DB2 Non-partitioned Database
Icon
Administration and Configuration of the DB2 Non-partitioned Database
Icon
Introduction
Icon
Creating and configuring DB2 non-partitioned databases
Icon
Using Configuration Advisor
Icon
Creating a database from an existing backup
Icon
Configuring automatic database maintenance
Icon
Managing federated databases—connecting to Oracle and MSSQL
Icon
Altering databases
Icon
Dropping databases
3
DB2 Multipartitioned Databases—Administration and Configuration
Icon
DB2 Multipartitioned Databases—Administration and Configuration
Icon
Introduction
Icon
Creating and configuring a multipartitioned database
Icon
Adding database partitions
Icon
Creating database partition groups
Icon
Altering database partition groups—adding partitions to database partition groups
Icon
Managing data redistribution on database partition groups
Icon
The table distribution key and its role in a multipartitioned environment
Icon
Altering database partition groups—removing partitions from a database partition group
Icon
Removing database partitions
Icon
Converting a non-partitioned database to a multipartitioned database on MS Windows
Icon
Configuring Fast Communication Manager
4
Storage—Using DB2 Table Spaces
Icon
Storage—Using DB2 Table Spaces
Icon
Introduction
Icon
Creating and configuring table spaces within automatic storage databases
Icon
Creating and configuring SMS table spaces
Icon
Creating and configuring DMS table spaces
Icon
Getting ready
Icon
How to do it...
Icon
How it works...
Icon
There's more...
Icon
See also
Icon
Using system temporary table spaces
Icon
Using user temporary table spaces
Icon
Altering table spaces and dropping table spaces
Icon
Table spaces in a multipartitioned environment
5
DB2 Buffer Pools
Icon
DB2 Buffer Pools
Icon
Introduction
Icon
Creating and configuring buffer pools
Icon
Configuring the block-based area
Icon
Managing buffer pools in a multipartitioned database
Icon
Altering buffer pools
Icon
Dropping buffer pools
6
Database Objects
Icon
Database Objects
Icon
Introduction
Icon
Creating and using MDC tables and block-based indexes
Icon
Creating and using materialized query tables
Icon
Implementing table partitioning
Icon
Using temporary tables
Icon
Created global temporary table
7
DB2 Backup and Recovery
Icon
DB2 Backup and Recovery
Icon
Introduction
Icon
Configuring database logging
Icon
Performing an offline database backup
Icon
Performing a full online database backup
Icon
Performing an incremental delta database backup
Icon
Performing an incremental cumulative database backup
Icon
Backing up table spaces
Icon
Crash recovery
Icon
Full database recovery
Icon
Database rollforward recovery
Icon
Incremental restore
Icon
Recovering table spaces—full and rollforward recovery
Icon
Redirected restore
Icon
Recovery history file
Icon
Configuring tape-based backup with IBM Tivoli Storage Manager
Icon
db2move and db2look utilities as alternative backup methods
8
DB2 High Availability
Icon
DB2 High Availability
Icon
Introduction
Icon
Setting up HADR by using the command line
Icon
Setting up HADR by using Control Center
Icon
Changing HADR synchronization modes
Icon
Performing takeover and takeover by force
Icon
Using automated client rerouting with HADR
Icon
Opening the standby database in read-only mode
Icon
Using the DB2 fault monitor
9
Problem Determination, Event Sources, and Files
Icon
Problem Determination, Event Sources, and Files
Icon
Introduction
Icon
Using db2mtrk—DB2 memory tracker
Icon
Using db2pd—DB2 problem determination tool
Icon
Using db2dart—DB2 database analysis and reporting tool command
Icon
Using db2ckbkp—DB2 check backup tool for backup integrity
Icon
Using db2support to collect diagnostic data
10
DB2 Security
chevron up
Icon
DB2 Security
Icon
Introduction
Icon
Managing instance-level authorities
Icon
Managing database-level authorities and privileges
Icon
Managing object privileges
Icon
Using roles
Icon
Using table encryption
Icon
Using label-based access control (LBAC) to strengthen data privacy
Icon
Auditing DB2
11
Connectivity and Networking
Icon
Connectivity and Networking
Icon
Introduction
Icon
Configuring network communications
Icon
Cataloging and uncataloging instances and databases
Icon
Using DB2 Discovery
Icon
Communications with DRDA servers (z/OS and i/OS)
Icon
Monitoring and configuring FCM for optimal performance
12
Monitoring
Icon
Monitoring
Icon
Introduction
Icon
Configuring and using system monitoring
Icon
Configuring and using snapshot monitoring
Icon
Configuring and using event monitoring
Icon
Using Memory Visualizer
Icon
Using Health Monitor
13
DB2 Tuning and Optimization
Icon
DB2 Tuning and Optimization
Icon
Introduction and general tuning guidelines
Icon
Operating system tuning
Icon
Resolving CPU bottlenecks
Icon
Tuning memory utilization
Icon
Collecting object statistics with the RUNSTAT utility
Icon
Default automatic statistics collection
Icon
Tuning with indexes
Icon
Tuning sorting
Icon
Hit ratios and their role in performance improvement
Icon
I/O tuning
Icon
Using logging and nologging modes
Icon
Using parallelism
Icon
Loading a table
Icon
Using EXPLAIN PLAN
Icon
Creating a benchmark testing scenario
14
IBM pureScale Technology and DB2
Icon
IBM pureScale Technology and DB2
Icon
Introduction
Icon
Managing instances, members, and cluster facilities in DB2 pureScale
Icon
Monitoring DB2 pureScale environments
Icon
High availability in DB2 pureScale environments
Icon
Backup and recovery in DB2 pureScale environments
1
Index
Icon
Index

Using roles

A role can be defined as a database object that has the capability to hold a collection of privileges and authorities that can be assigned to a user or a group. Using roles considerably simplifies the management of privileges and authorities to be granted, especially if you have a large user base in your organization.

Getting ready

In this recipe, we will create two roles, named db2rlus and db2rinh . We will grant the CONNECT and SELECT privileges on tables NAV.COMM and NAV.WAYPOINT, to role db2rlus. We will grant this role to group db2users. Next, we will grant role db2rlus to role db2rihn. Next, we will revoke role db2rlus from the db2users group and re-grant db2rlus role to this group, to demonstrate how roles inherit rights from other roles.

  1. Connect to database NAV as user db2secad:

    [db2inst1@nodedb21 ~]$ db2 "connect to nav user db2secad using db2secad"

   Database Connection Information

 Database server        = DB2/LINUXX8664 9.7.4
 SQL authorization ID   = DB2SECAD
 Local...
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
IBM DB2 9.7 Advanced Administration Cookbook
End of Section 10
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon