Everand Logo

Welcome to Everand!

  • Discover millions of ebooks, audiobooks, and so much more with a free trial

    Only $9.99/month after trial. Cancel anytime.

    IBM DB2 9.7 Advanced Administration Cookbook
    IBM DB2 9.7 Advanced Administration Cookbook
    IBM DB2 9.7 Advanced Administration Cookbook
    Ebook1,311 pages8 hours

    IBM DB2 9.7 Advanced Administration Cookbook

    By Adrian Neagu

    ()

    Read preview

    About this ebook

    This cookbook has recipes written in a simple, easy to understand format, with lots of screenshots and insightful tips and hints. 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.
    LanguageEnglish
    PublisherPackt Publishing
    Release dateFeb 24, 2012
    ISBN9781849683333
    IBM DB2 9.7 Advanced Administration Cookbook
    Author

    Adrian Neagu

    Dr. Adrian Neagu received his M.S. in Physics from the West University of Timisoara, Romania (1991). He worked at Freie Universität Berlin as a research fellow of the German Academic Exchange Service (Deutscher Akademischer Austauschdienst, DAAD) (1992-1993). In 2002, he obtained his PhD in Statistical Physics from the Babes-Bolyai University of Cluj-Napoca, Romania. As a postdoctoral fellow in the research group led by Prof. Gabor Forgacs at the University of Missouri, Columbia, MO, USA, he studied the self-assembly of multicellular systems (2002-2003). He applied methods of statistical physics to develop computer simulations aimed at predicting the outcome of three-dimensional (3D) bioprinting of living tissue constructs [1-3]. He teaches Biophysics at the Victor Babes University of Medicine and Pharmacy Timisoara, as Associate Professor (2004-2006), and Professor (2006-present). In 2008, he was assigned Adjunct Professor at the University of Missouri, Columbia, USA. Here, as a visiting scholar, he worked on computational aspects of 3D tissue bioprinting as co-principal investigator of a National Science Foundation grant, FIBR-0526854 entitled "Understanding and employing multicellular self-assembly" (2006-2010). Dr. Neagu is coauthor of a patent on 3D tissue printing (United States Patent No. 8241905/14.08.2012), and editor of the Journal of 3D Printing in Medicine.

    Related to IBM DB2 9.7 Advanced Administration Cookbook

    Related ebooks

    Information Technology For You

    View More
    View More

    Related podcast episodes

    Related articles

    • Article

      Picture In A Mainframe

      Jul 2, 2019

      Picture In A Mainframe
      11 min read

    • Article

      Deep Into Storage Space

      Jun 25, 2019

      Deep Into Storage Space
      8 min read

    • Article

      Deep Into Storage Space

      Oct 7, 2019

      Deep Into Storage Space
      8 min read

    • Article

      Expand Your Storage With High-speed SSDs

      Aug 20, 2024

      How do you increase storage on a system with no more drive slots? That’s a reasonable question, especially when most modest motherboards only offer two NVMe slots. As storage prices have spiked over the last year, it’s not too hard to believe you hav

      3 min read

    • Article

      Mac 911

      Apr 20, 2021

      Mac 911
      7 min read

    • Article

      Help Desk

      Apr 12, 2024

      Help Desk
      5 min read

    • Article

      Create Your Own Virtual Classroom

      Mar 8, 2022

      Credit: https://moodle.org David Rutland believes it’s impossible for a person to be either be overdressed or overeducated. People who know him agree that he is neither. Education, education, education. If you were around in 1997, you probably rememb

      10 min read

    • Article

      Create Your Own Virtual Classroom

      Mar 8, 2022

      Credit: https://moodle.org David Rutland believes it’s impossible for a person to be either be overdressed or overeducated. People who know him agree that he is neither. Education, education, education. If you were around in 1997, you probably rememb

      10 min read

    • Article

      Boost Your SSD Performance

      Nov 5, 2024

      Boost Your SSD Performance
      8 min read

    • Article

      Boost Your SSD Performance

      Dec 9, 2024

      YOU’LL NEED • CrystalDiskMark Download it from https://crystalmark.info/en/software/crystaldiskmark Millennial APC readers may find it hard to fathom that solid-state drives first hit the market 33 years ago in 1991. SSDs rely on non-volatile memory

      9 min read

    • Article

      Upgrade your Mac

      Aug 23, 2022

      Upgrade your Mac
      4 min read

    • Article

      HDDs Up, This Is A RAID!

      Jan 9, 2024

      Sometimes novice administrators don’t S understand that cloud disk performance management and optimisation can be an art form. Some cloud providers limit individual disk I/O performance to ensure decent performance is available to all. As an example,

      2 min read

    • Article

      Tweaking System Components

      Nov 19, 2019

      Tweaking System Components
      4 min read

    • Article

      Create a Time Capsule

      Nov 2, 2020

      Create a Time Capsule
      2 min read

    • Article

      Answers

      Jan 9, 2024

      Answers
      9 min read

    • Article

      Mac 911

      Jan 21, 2020

      Mac 911
      7 min read

    • Article

      Create a Time Capsule

      Aug 25, 2020

      Create a Time Capsule
      2 min read

    • Article

      Mailserver

      Jun 27, 2023

      Mailserver
      4 min read

    • Article

      Upgrade your Mac

      Oct 11, 2022

      Upgrade your Mac
      3 min read

    • Article

      Doctor

      Mar 26, 2024

      > Deploy new PC > Office alternatives > Linux drives I was inspired by your Hydra Mini ITX Chassis build (Feb 2024 issue) to go out and spec a similar system to replace my three-year-old setup (also based on one of your builds, namely the AMD Ryzen 9

      6 min read

    • Article

      Backup Alternatives

      May 11, 2017

      Backup Alternatives
      3 min read

    • Article

      Observability Of The Kernel And Containers

      Apr 4, 2023

      Mihalis Tsoukalos is currently working on Time Series. You can reach him at: @mactsouk. For our final delve into eBPF, we’re tackling applications, the kernel and Docker containers. At the end of the day, all Linux machines execute code for applicat

      10 min read

    • Article

      Meet The Team

      Jun 29, 2021

      Speaking from experience, it’s a good idea to change your bash prompt or use tmux decorations – anything to embellish the fact that the machine you’re working on is remote. It’s no fun when you think you’re dd-ing a USB stick, but it’s actually your

      1 min read

    Related categories

    Reviews for IBM DB2 9.7 Advanced Administration Cookbook

    0 ratings

    0 ratings0 reviews

    What did you think?

    Tap to rate

    Review must be at least 10 words

      Book preview

      IBM DB2 9.7 Advanced Administration Cookbook - Adrian Neagu

      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 table spaces within automatic storage databases

      Getting ready

      How to do it...

      How it works...

      There's more...

      Using self tuning buffer pools

      Physical implementation

      Adding a storage path to a manual storage database

      Creating and configuring SMS table spaces

      Getting ready

      How to do it...

      How it works...

      There's more...

      Space allocation

      Tables and objects

      Limits

      Filesystem caching

      Limits

      See also

      Creating and configuring DMS table spaces

      Benefits

      Getting ready

      How to do it...

      How it works...

      There's more...

      Raw partitions

      Space allocation

      Tables and objects

      Filesystem caching

      Extent size

      Prefetch size

      Striping strategy

      High water mark

      See also

      Using system temporary table spaces

      Getting ready

      How to do it...

      How it works...

      There's more...

      Reorgs

      Using user temporary table spaces

      Getting ready

      How to do it...

      How it works...

      There's more...

      Page size for temporary table space

      SMS or DMS?

      See also

      Altering table spaces and dropping table spaces

      Getting ready

      How to do it…

      How it works...

      There's more...

      Container management

      Size management

      Physical characteristics

      Performance characteristics

      Dropping table space

      See also

      Table spaces in a multipartitioned environment

      Getting ready

      How to do it...

      How it works...

      There's more...

      Distribution maps

      Distribution keys

      Table space containers

      Partition groups

      Table space state

      Storage paths in an automatic storage-partitioned database

      See also

      5. DB2 Buffer Pools

      Introduction

      Creating and configuring buffer pools

      Getting ready

      How to do it...

      How it works...

      There's more...

      Naming convention

      Specifying space size for the buffer pool

      Memory sizing

      Windows 32-bit environments: Address Windowing Extensions (AWE) and Extended Storage (ESTORE)

      Hidden buffer pools

      See also

      Configuring the block-based area

      Getting ready

      How to do it...

      How it works...

      There's more...

      Block size and table space extent size

      See also

      Managing buffer pools in a multipartitioned database

      Getting ready

      How to do it...

      How it works...

      There's more...

      See also

      Altering buffer pools

      Getting ready

      How to do it...

      How it works...

      There's more...

      Page size

      Buffer pool size

      Self-tuning

      Partitions

      Partition groups

      See also

      Dropping buffer pools

      Getting ready

      How to do it...

      How it works...

      There's more...

      IBMDEFAULTBP

      Dependencies

      See also

      6. Database Objects

      Introduction

      Creating and using MDC tables and block-based indexes

      Getting ready

      How to do it...

      How it works...

      There's more...

      Block indexes and aggregate functions in queries

      Block size and extents

      Using runstats to determine dimension candidates

      Restrictions on dimensions

      Rollout

      Partitioned database

      See also

      Creating and using materialized query tables

      Getting ready

      How to do it...

      How it works...

      There's more...

      Refresh deferred

      Maintained by system/user

      Query rewrites

      Combining with table partitioning

      Replicated MQTs and database partitioning

      See also

      Implementing table partitioning

      Getting ready

      How to do it...

      How it works...

      There's more...

      Scalability

      Non-partitioned indexes

      Partitioned indexes

      Storage strategies

      Adding a partition to a table

      Detach a partition from a table

      See also

      Using temporary tables

      Getting ready

      How to do it...

      How it works...

      Created global temporary table

      How to do it...

      How it works...

      There's more...

      Restrictions

      Recovery

      See also

      7. DB2 Backup and Recovery

      Introduction

      Configuring database logging

      Getting ready

      How to do it...

      How it works...

      There's more...

      See also

      Performing an offline database backup

      Getting ready

      How to do it...

      How it works...

      There's more...

      Backup naming convention

      Partitioned database

      Recovery from offline backup

      See also

      Performing a full online database backup

      Getting ready

      How to do it...

      How it works...

      There's more...

      Resource usage

      Restrictions

      Backup pending

      See also

      Performing an incremental delta database backup

      Getting ready

      How to do it...

      How it works...

      There's more...

      Table space name change

      Recovery history file

      See also

      Performing an incremental cumulative database backup

      Getting ready

      How to do it...

      How it works...

      There's more...

      See also

      Backing up table spaces

      Getting ready

      How to do it...

      How it works...

      There's more...

      Operations incompatible with online table space backups

      See also

      Crash recovery

      Getting ready

      How to do it...

      How it works...

      There's more...

      How crash recovery works to ensure database integrity

      Inspect database

      See also

      Full database recovery

      Getting ready

      How to do it...

      How it works...

      There's more...

      Attempting to recover from a backup of database in another logging mode

      See also

      Database rollforward recovery

      Getting ready

      How to do it...

      How it works...

      There's more...

      Database state after restore

      Point-in-time recovery on a partitioned database

      History of restore operations

      See also

      Incremental restore

      Getting ready

      How to do it...

      How it works...

      There's more...

      Archive log file not associated with the current log sequence

      See also

      Recovering table spaces—full and rollforward recovery

      Getting ready

      How to do it...

      How it works...

      There's more...

      Backup image

      Table space with system catalog

      Partitioned database

      Partitioned table

      See also

      Redirected restore

      Getting ready

      How to do it...

      How it works...

      There's more...

      ABORT

      See also

      Recovery history file

      Getting ready

      How to do it...

      How it works...

      There's more...

      Location

      List history

      PRUNE

      Drop database

      Restore database

      Configuring tape-based backup with IBM Tivoli Storage Manager

      Getting ready

      How to do it...

      How it works...

      There's more...

      Partitioned environment

      See also

      db2move and db2look utilities as alternative backup methods

      Getting ready

      How to do it...

      How it works...

      There's more...

      Using db2move to load data

      LOAD with care

      See also

      8. DB2 High Availability

      Introduction

      Setting up HADR by using the command line

      Getting ready

      How to do it...

      Install IBM DB2 ESE on nodedb22

      Creating additional directories for table space containers, archive logs, backup, and mirror logs

      Setting permissions on the new directories

      Configuring archive log and mirror log locations

      Configuring LOGINDEXBUILD and INDEXREC parameters

      Backing up the primary database

      Copying the database backup to nodedb22

      Restoring the database NAV on nodedb22

      Setting up HADR communication ports

      Setting up HADR parameters on the primary database

      Setting up HADR parameters on the standby database

      Starting HADR on standby database

      Starting HADR on primary database

      Monitoring HADR

      How it works…

      There's more…

      The hadr_timeout and hadr_peer_window database configuration parameters

      See also

      Setting up HADR by using Control Center

      Getting ready

      How to do it...

      How it works...

      Changing HADR synchronization modes

      Getting ready

      How to do it...

      Changing to NEARSYNC synchronization mode

      Changing to SYNC synchronization mode

      Changing back to ASYNC synchronization mode

      How it works...

      There's more...

      Performing takeover and takeover by force

      Getting ready

      How to do it...

      Using Control Center

      Using the command line to perform a takeover

      Using the command line to perform a takeover by force

      How it works...

      There's more...

      Using automated client rerouting with HADR

      Getting ready

      How to do it...

      How it works...

      There's more...

      Opening the standby database in read-only mode

      Getting ready…

      How to do it…

      How it works...

      There's more...

      Using the DB2 fault monitor

      Getting ready

      How to do it...

      How it works…

      There's more...

      9. Problem Determination, Event Sources, and Files

      Introduction

      Using db2mtrk—DB2 memory tracker

      Getting ready

      How to do it...

      How it works...

      There's more...

      Using db2pd—DB2 problem determination tool

      Getting ready

      How to do it...

      How it works...

      There's more...

      Using db2dart—DB2 database analysis and reporting tool command

      Getting ready

      How to do it...

      How it works...

      There's more...

      Using db2ckbkp—DB2 check backup tool for backup integrity

      Getting ready

      How to do it...

      How it works...

      There's more...

      Using db2support to collect diagnostic data

      Getting ready

      How to do it...

      How it works...

      There's more...

      10. DB2 Security

      Introduction

      Managing instance-level authorities

      Getting ready

      How to do it...

      How it works...

      There's more...

      Managing database-level authorities and privileges

      Getting ready

      How to do it...

      How it works...

      There's more...

      Security administrator authority

      Managing object privileges

      Getting ready

      How to do it...

      How it works...

      There's more…

      Using roles

      Getting ready

      How it works...

      There's more…

      Creating roles using the WITH ADMIN OPTION

      SECAD exception

      Using table encryption

      Getting ready

      How to do it...

      How it works...

      There's more...

      Using label-based access control (LBAC) to strengthen data privacy

      Getting ready…

      How to do it...

      Creating security label components

      Defining security policies

      Creating security labels

      Modifying read and write access rules by using exemptions

      One more example using the ARRAY security component label

      How it works...

      There's more…

      Auditing DB2

      Getting ready

      How to do it...

      Configuring auditing scopes

      Configure audit data path and archive path:

      Archiving, formatting, and extracting the audit data:

      Using audit policies

      How it works...

      There's more…

      11. Connectivity and Networking

      Introduction

      Configuring network communications

      Getting ready

      How to do it...

      Using Control Center

      How it works...

      There's more...

      See also

      Cataloging and uncataloging instances and databases

      Getting ready

      How to do it...

      Using Control Center

      How it works...

      See also

      There's more...

      Using DB2 Discovery

      Getting ready

      How to do it...

      How it works...

      There's more...

      Communications with DRDA servers (z/OS and i/OS)

      Getting ready

      How to do it...

      How it works...

      There's more...

      Monitoring and configuring FCM for optimal performance

      Getting ready

      How to do it...

      How it works...

      There's more...

      12. Monitoring

      Introduction

      Configuring and using system monitoring

      Getting ready

      How to do it...

      How it works...

      There's more...

      Querying system information using table functions

      Querying activity information using table functions

      Querying data objects information using table functions

      Workload management (WLM)

      See also

      Configuring and using snapshot monitoring

      Getting ready

      How to do it...

      How it works...

      There's more...

      Table functions and administrative views

      Database load

      Buffer pool hit ratios

      Buffer pool physical reads and writes per transaction

      Average sorting time

      Sorting time per transaction

      Lock wait time

      Deadlocks and lock timeouts

      Rows read/rows selected

      Dirty steal BP clean/transaction

      Package cache inserts/transaction

      Average log writes/transaction

      See also

      Configuring and using event monitoring

      Getting ready

      How to do it...

      How it works...

      There's more...

      Unformatted event table

      Using the db2evmonfmt tool for reporting

      Table space use

      Pruning event monitor tables

      Resetting a monitor's counters

      Workload management (WLM)

      See also

      Using Memory Visualizer

      Getting ready

      How to do it...

      There's more...

      Self tuning memory management

      See also

      Using Health Monitor

      Getting ready

      How to do it...

      How it works...

      There's more...

      Getting recommendations for an alert

      Using the command line to check and set configuration

      See also

      13. DB2 Tuning and Optimization

      Introduction and general tuning guidelines

      Operating system tuning

      Getting ready

      How to do it...

      How it works...

      There's more...

      Virtual storage

      Disabling file system caching on table spaces

      Maintaining a historic record

      See also

      Resolving CPU bottlenecks

      Getting ready

      How to do it...

      How it works...

      There's more...

      Utilities

      Context switches

      See also

      Tuning memory utilization

      Getting ready

      How to do it...

      How it works...

      There's more...

      AUTOCONFIGURE

      Self-tuning memory in partitioned database environments

      See also

      Collecting object statistics with the RUNSTAT utility

      How to do it...

      How it works...

      There's more...

      Default automatic statistics collection

      Collecting statistics using a statistics profile

      Background stats collecting (asynchronous)

      Real-time stats collecting (synchronous)

      Setting priority

      Automatic statistics profiling

      Partitioned database

      See also

      Tuning with indexes

      Getting ready

      How to do it...

      How it works...

      There's more...

      Sample output

      Recommendations

      See also

      Tuning sorting

      Getting ready

      How to do it...

      How it works...

      There's more...

      Sort overflows

      Piped sorts

      Coding practices

      See also

      Hit ratios and their role in performance improvement

      Getting ready

      How to do it...

      How it works...

      There's more...

      Buffer pools

      Catalog cache

      Package cache

      Log buffer

      See also

      I/O tuning

      Getting ready

      How to do it...

      How it works...

      There's more...

      Logpath

      Diagnostic logs on partitioned databases

      Reorgchk

      See also

      Using logging and nologging modes

      Getting ready

      How to do it...

      How it works...

      There's more...

      Catalog locks

      Recovery

      LOAD with non-recoverable option

      High Availability Disaster Recovery (HADR)

      See also

      Using parallelism

      Getting ready

      How to do it...

      How it works...

      There's more...

      RAID 5 and DB2_PARALLEL_IO

      Loading a table

      See also

      Using EXPLAIN PLAN

      Getting ready

      How to do it...

      How it works...

      There's more...

      Sample output

      Watch out for...

      Importing production statistics

      See also

      Creating a benchmark testing scenario

      Getting ready

      How to do it...

      There's more...

      Warm-up run

      See also

      14. IBM pureScale Technology and DB2

      Introduction

      Managing instances, members, and cluster facilities in DB2 pureScale

      Getting ready

      How to do it...

      Creating and managing a DB2 pureScale instance

      Managing DB2 pureScale members

      Starting pureScale members

      Managing the DB2 pureScale caching facilities

      Stopping the caching facility

      Starting pureScale cluster facilities

      How it works…

      There's more…

      Put pureScale members in maintenance mode

      Monitoring DB2 pureScale environments

      Getting ready

      How to do it…

      Monitoring cluster facility memory structures

      How it works…

      There's more…

      High availability in DB2 pureScale environments

      Getting ready

      How to do it…

      How it works…

      There's more…

      Backup and recovery in DB2 pureScale environments

      Getting ready

      How to do it…

      Performing an offline database backup

      Performing an online database backup

      Performing a restore and rollforward recovery

      Performing database recovery

      How it works…

      There's more…

      Index

      IBM DB2 9.7 Advanced Administration Cookbook

      IBM DB2 9.7 Advanced Administration Cookbook

      Copyright © 2012 Packt Publishing

      All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

      Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

      Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

      First published: March 2012

      Production Reference: 1200212

      Published by Packt Publishing Ltd.

      Livery Place

      35 Livery Street

      Birmingham B3 2PB, UK.

      ISBN 978-1-84968-332-6

      www.packtpub.com

      Cover Image by Sandeep Babu (<[email protected]>)

      Credits

      Authors

      Adrian Neagu

      Robert Pelletier

      Reviewers

      Nadir Doctor

      Marius Ileana

      Nivasreddy Inaganti

      Nitin G. Maker

      Drazen Martinovic

      Eldho Mathew

      Acquisition Editor

      Rukshana Khambatta

      Lead Technical Editor

      Hithesh Uchil

      Technical Editor

      Arun Nadar

      Project Coordinator

      Leena Purkait

      Copy Editor

      Brandt D’Mello

      Proofreader

      Aaron Nash

      Indexer

      Monica Ajmera Mehta

      Production Coordinator

      Shantanu Zagade

      Cover Work

      Shantanu Zagade

      About the Authors

      Adrian Neagu has over 10 years of experience as a database administrator, mainly with DB2 and Oracle databases. He has been working with IBM DB2 since 2002.

      He is an IBM DB2 Certified Administrator (versions 8.1.2 and 9), Oracle Database Administrator Certified Master 10g, Oracle Certified Professional (9i and 10g), and Sun Certified System Administrator Solaris 10. He is an expert in many areas of database administration, such as performance tuning, high availability, replication, and backup and recovery.

      In his spare time, he enjoys cooking, taking photos, and catching big pikes with huge jerkbaits and bulldawgs.

      I would like to give many thanks to my family, to my daughter Maia-Maria, and my wife Dana, who helped and supported me unconditionally, and also to my colleagues, my friends, to Rukshana Khambatta, my acquisition editor, for her patience, and finally to Robert Pelletier and Marius Ileana, who have provided invaluable advice, helping me to climb up the cliffs of authoring.

      Robert Pelletier is a Senior DBA Certified Oracle 8i, 9i, 10g, and DB2. He has 12 years of experience as DBA, in production/development support, database installation and configuration, and tuning and troubleshooting. He has more than 30 years of IT experience in application development in mainframe central environments, client-server, and UNIX. More recently, he has added expertise in Oracle RAC 11gR2, 10gR2, 9i, DB2 UDB DBA, ORACLE 9iAS, Financials, PeopleSoft, and also SAP R/2 & R/3. He is renowned for his expertise among many major organizations worldwide and has a solid consulting background in well-known firms.

      I would like to thank my wife, Julie, and son, Marc-André, for their positive and unconditional support, and also to Adrian Neagu, who helped me a lot for coauthoring this book, and all the Packt publishing team for making this possible. I would also like to thank my clients and colleagues who have provided invaluable opportunities for me to expand my knowledge and shape my career.

      About the Reviewers

      Marius Ileana is an OpenGroup Certified IT specialist currently working in banking industry.

      Working for six years in IBM Romania as a part of middleware team and also being a two-year support specialist, he has been involved in various IBM-related technologies and enterprise grade deployments.

      He holds many IBM certifications including IBM Certified DBA for DB2 9 on LUW. Since Java development is one of his hobbies, he is also a Sun Certified Programmer for Java™ v1.4. His areas of expertise include AIX, HACMP, WebSphere Application Server, DB2 UDB, and design and development of J2EE™ applications.

      His current focus areas include the architecture and development of a general-purpose monitoring solution, Portal solutions, and data visualization.

      Nitin G. Maker is an IBM Certified DB2 UDB DBA with around 11 years of IT experience, primarily in IBM DB2 Universal Database Technologies. He has demonstrated excellent capabilities in various roles as Data Architect/Database Administrator/DataWarehouse Architect, Applications Administrator, Upgrade Specialist, and Technical Team Leader.

      Nitin has worked with many leading software houses in India and also completed assignments in the USA, UK, and Sri Lanka. He is currently based in Pune, with his family, and enjoys making new friends, listening to music, and following sports.

      Drazen Martinovic graduated at the Faculty of Electronics, Machinery and Shipbuilding, Split, Croatia, in 1996. He worked in DHL international d.o.o. as a Unix administrator—IT support administrator—for 11 years. He then started to work as a database administrator for DB2 for LUW. He has been an IBM Certified Database Administrator (DB2 9 for Linux, UNIX, and Windows), since last year.

      He works in the Raiffeisenbank Austria d.d. Zagreb bank as a Database Administrator for DB2. It has over 2000 employees.

      Eldho Mathew is a DB2 LUW, Linux and AIX certified administrator with 8 years of proven expertise in various aspects of building, administrating, and supporting highly complex 24x7 operational and warehouse database servers. He has handled highly complex and critical systems for many top branded customers in UK.

      www.PacktPub.com

      Support files, eBooks, discount offers and more

      You might want to visit www.PacktPub.com for support files and downloads related to your book.

      Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.PacktPub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at for more details.

      At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.

      http://PacktLib.PacktPub.com

      Do you need instant solutions to your IT questions? PacktLib is Packt’s online digital book library. Here, you can access, read and search across Packt’s entire library of books.

      Why Subscribe?

      Fully searchable across every book published by Packt

      Copy and paste, print and bookmark content

      On demand and accessible via web browser

      Free Access for Packt account holders

      If you have an account with Packt at www.PacktPub.com, you can use this to access PacktLib today and view nine entirely free books. Simply use your login credentials for immediate access.

      Instant Updates on New Packt Books

      Get notified! Find out when new books are published by following @PacktEnterprise on Twitter, or the Packt Enterprise Facebook page.

      Preface

      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, such as AIX, HP-UX, and Solaris, and also MS Windows platforms. With lots of new features, DB2 9.7 delivers one the best relational database systems on the market.

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

      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 high-availability architecture.

      What this book covers

      Chapter 1, DB2 Instance—Administration and Configuration, covers DB2 instance creation and configuration for non-partitioned database and multipartitioned database environments.

      Chapter 2, Administration and Configuration of the DB2 Non-partitioned Database, contains recipes that explain how to create a database and get operational in simple and easy steps. In this chapter, you will also learn how to configure your database for its mission and prepare it for automatic maintenance, so its operation is worry-free.

      Chapter 3, DB2 Multipartitioned Databases—Administration and Configuration, contains recipes that explain how to create and configure a multipartitioned database and its related administration tasks. This chapter will also teach us how to add and remove new partitions, how to perform add, remove, and redistribute operations on database partition groups, and much more.

      Chapter 4, Storage—Using DB2 Table Spaces, covers physical aspects of storage, the foundation of a database. In this chapter, we will cover configuring SMS and DMS table spaces, altering table spaces, and dropping table spaces.

      Chapter 5, DB2 Buffer Pools, covers caching. Here, you will learn how data is read from the disk, to buffer pools. And as reading from memory is faster than reading from disk, the buffer pools play an important part in database performance.

      Chapter 6, Database Objects, covers Multidimensional Clustering (MDC), Materialized Query Tables (MQT), and Partitioning as the key techniques used for efficient data warehousing. Combined with database partitioning, these deliver a scalable and effective solution, reduce performance problems and logging, and provide easier table maintenance.

      Chapter 7, DB2 Backup and Recovery, covers the major aspects of backup and recovery, as is practiced industry-wide, the preferred solutions, and how we can implement some of these methods.

      Chapter 8, DB2 High Availability, mainly covers High Availability Disaster Recovery as a HA solution and DB2 Fault Monitor, which is used for monitoring and ensuring the availability of instances that might be closed by unexpected events, such as bugs or other type of malfunctions. The reader will learn how to implement HADR using command line and Control Center, about synchronization modes, how to initiate takeover and takeover by force, how to configure and open a standby database in read-only mode, and more.

      Chapter 9, Problem Determination, Event Sources, and Files, has recipes for various tools used for diagnostics, inspection, and performance problem detection, such as db2mtkr, for gathering memory-related information, db2pd, a very powerful tool used for problem determination, db2dart, also a very powerful tool with wide applicability, that can be used for virtually any problem that may arise, db2ckbkp, for backup image checking, and db2support, used mainly for automating diagnostic data collection.

      Chapter 10, DB2 Security, speaks about the main security options used to harden and secure DB2 servers. It is about instance-level and database authorities, data encryption, roles, and securing and hiding data using Label Based Access Control.

      Chapter 11, Connectivity and Networking, covers many network-related configurations that apply to DB2 servers and clients, such as node cataloging, setting up connections to DRDA serves, and how to tune and monitor the Fast Communication Manager.

      Chapter 12, Monitoring, covers an important part of a DBA's work, ensuring the database is available and that nothing hinders its functionality.

      Chapter 13, DB2 Tuning and Optimization, provides general guidelines, as well as insightful details, on how to dispense the regular attention and tuning that databases need, using a design-centered approach. Our tips, based on best practices in the industry, will help you in building powerful and efficient databases.

      Chapter 14, IBM pureScale Technology and DB2, represents mainly an introduction to pureScale technology. We will cover the principal administration tasks related to members, instances, and caching facilities. The reader will also learn about monitoring, backup and recovery methods, and special features that exist only in pureScale configurations.

      What you need for this book

      Unless you have access to a facility that has DB2 installed, you can install a trial version of DB2 on your own PC for learning purposes. Make sure you have the required hardware and operating system.

      We must stress the importance of using a sandbox environment in order to duplicate the recipes in this book. Some recipes are intended for demonstration purposes and should not be done in a production environment.

      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

      Enjoying the preview?
      Page 1 of 1