Delivering Continuity and Extreme Capacity with the IBM DB2 pureScale Feature

Delivering Continuity and Extreme Capacity with the IBM DB2 pureScale Feature

by Vlad Barshai, Yvonne Chan, Hua Lu, Satpal Sohal
Released September 2012
Publisher(s): IBM Redbooks
ISBN: None

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

The IBM® DB2® pureScale® feature offers clustering technology that helps deliver high availability and exceptional scalability transparent to applications. The DB2 pureScale feature helps you to meet your business needs around availability and scalability, and is also easy to configure and administer.

This IBM Redbooks® publication addresses the DB2 pureScale feature that is available in IBM DB2 10.1 for Linux, UNIX, and Windows operating systems. It can help you build skills and deploy the DB2 pureScale feature. This book bundles all the information necessary for a in-depth analysis into the functions of the DB2 pureScale feature, including the actual hardware requirements. It includes validated step-by-step hardware and software installation instructions. In addition, this book provides detailed examples about how to work effectively with a DB2 pureScale cluster and how to plan and run an upgrade for all DB2 related components to DB2 10.1.

This book is intended for database administrators (DBAs) who use IBM DB2 10.1 for Linux, UNIX, and Windows operating systems who want to explore and get started with the DB2 pureScale feature.

Table of contents

  1. Notices
    1. Trademarks
  2. Preface
    1. The team who wrote this book
    2. Now you can become a published author, too!
    3. Comments welcome
    4. Stay connected to IBM Redbooks publications
  3. Chapter 1: An overview of the DB2 pureScale feature
    1. Technology overview
      1. Application transparency
      2. Continuous availability
      3. Scalability and extreme capacity
    2. The DB2 pureScale feature technical components
      1. DB2 cluster services overview
      2. Member crash recovery services overview
    3. The DB2 pureScale feature and your application
      1. Client affinity
      2. Workload balancing
    4. The DB2 pureScale feature versions and editions
      1. DB2 versions and differences
      2. DB2 editions and differences
      3. Feature availability and differences between editions
      4. Selecting the best DB2 version and edition
  4. Chapter 2: Planning and architecture
    1. Before you begin
    2. Hardware requirements and considerations
      1. Supported hardware
      2. Hardware considerations (1/2)
      3. Hardware considerations (2/2)
    3. Software requirements and considerations
      1. Supported operating systems
      2. Operating system considerations
    4. Hardware firmware requirements
      1. Linux on System x systems firmware requirements
      2. AIX on POWER systems firmware requirements
    5. Topology requirements and considerations
      1. Topology requirements and considerations
      2. Common topology examples
    6. High availability and disaster recovery
      1. Basic principles of high availability
      2. Disaster recovery techniques
    7. Client requirements and considerations
      1. Application considerations
      2. DB2 client configurations for an application (1/2)
      3. DB2 client configurations for an application (2/2)
  5. Chapter 3: Implementation and setup
    1. Hardware setup on a Linux operating systems
      1. Adding a PCI Express card
      2. Connecting the external storage
      3. Connecting the Ethernet network
      4. Connecting an interconnect network
      5. Configuring the internal disks (1/2)
      6. Configuring the internal disks (2/2)
    2. Configuring a Linux system to install the DB2 pureScale feature
      1. Step 1: Installing the operating system
      2. Step 2: Updating the kernel
      3. Step 3: Installing the multipath device driver
      4. Step 4: Configuring the external storage (1/5)
      5. Step 4: Configuring the external storage (2/5)
      6. Step 4: Configuring the external storage (3/5)
      7. Step 4: Configuring the external storage (4/5)
      8. Step 4: Configuring the external storage (5/5)
      9. Step 5: Installing the required software packages
      10. Step 6: Setting up the Ethernet network (1/2)
      11. Step 6: Setting up the Ethernet network (2/2)
      12. Step 7: Setting up the interconnect network (1/3)
      13. Step 7: Setting up the interconnect network (2/3)
      14. Step 7: Setting up the interconnect network (3/3)
      15. Step 8: Editing the hosts file
      16. Step 9: Installing and setting up OpenSSH
      17. Step 10: Blacklisting the system watchdog modules
      18. Step 11: Modifying the mlx4_core parameter
    3. Configuring an AIX system to install the DB2 pureScale feature
      1. Preinstallation checklist
      2. Validating the platform firmware level
      3. Installing the technology level and service packs
      4. Configuring the InfiniBand network
      5. Editing the hosts file
      6. Installing and setting up OpenSSH
      7. Configuring a physical volume identifier for an IBM DB2 pureScale instance
      8. Configuring the I/O completion ports
      9. Allocating storage
      10. Creating the required groups and users
    4. Installing the DB2 pureScale feature
      1. Checking the installation prerequisites
      2. Using the command line on a Linux environment
      3. Using the DB2 setup wizard (1/3)
      4. Using the DB2 setup wizard (2/3)
      5. Using the DB2 setup wizard (3/3)
      6. Using the command line installation in an AIX environment
    5. Post-installation tasks
      1. Validating the installation by creating the SAMPLE database
      2. Creating shared file systems
      3. Changing the default database path
      4. Changing the default log path
      5. Processor binding
      6. Enabling SCSI-3 PR on a Linux environment
  6. Chapter 4: Working with a DB2 pureScale cluster
    1. Operations
      1. Querying cluster components
      2. Working with a cluster caching facility
      3. Working with a member
      4. Activating and deactivating DB2 pureScale databases
      5. Quiescing an operation
    2. Maintenance
      1. Adding or removing components
      2. Putting components in to maintenance mode
      3. Managing disk space on a shared storage file system
      4. Advanced operations
      5. Backup and restore
    3. Monitoring
      1. Performance monitoring
      2. Functional monitoring (1/4)
      3. Functional monitoring (2/4)
      4. Functional monitoring (3/4)
      5. Functional monitoring (4/4)
  7. Chapter 5: Upgrading to DB2 10.1
    1. Benefits of upgrading
    2. Supported upgrade paths
    3. Planning for an upgrade
    4. Performing the upgrade to DB2 10.1
      1. Upgrading DB2 servers
      2. Upgrading DB2 clients
      3. Upgrading a DB2 instance
      4. Upgrading the database
    5. Upgrading from DB2 9.5 or 9.7 to DB2 10.1
      1. Restrictions
      2. General procedure
    6. Enabling the DB2 pureScale feature
      1. Restrictions
      2. General procedure
      3. Resolving possible IBM DB2 pureScale feature database enablement issues
    7. Upgrading a DB2 9.8 server to DB2 10.1
      1. Restrictions
      2. General procedure
    8. Post-upgrade steps
      1. After upgrading the DB2 servers
      2. After upgrading the DB2 clients
      3. After upgrading a database
  8. Abbreviations and acronyms
  9. Related publications
    1. IBM Redbooks publications
    2. Online resources
    3. Help from IBM
  10. Back cover

Product information

  • Title: Delivering Continuity and Extreme Capacity with the IBM DB2 pureScale Feature
  • Author(s): Vlad Barshai, Yvonne Chan, Hua Lu, Satpal Sohal
  • Release date: September 2012
  • Publisher(s): IBM Redbooks
  • ISBN: None