Integrating IBM DB2 with the IBM System Storage N series

Integrating IBM DB2 with the IBM System Storage N series

by Alex Osuna, Jawahar Lal, Roger Sanders
Released December 2006
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

This IBM Redbooks publication describes the steps carried out to configure and install an IBM DB2 database in a N series storage system UNIX environment. It particularly elaborates the configuration steps for the UNIX host as well as the IBM N series storage system. The UNIX host types covered in this book are Linux, IBM AIX, Sun Solaris, and HP-UX.

Table of contents

  1. Notices
    1. Trademarks
  2. Preface
    1. The team that wrote this redbook
    2. Become a published author
    3. Comments welcome
  3. Chapter 1: Introduction
    1. The configuration used for this IBM Redbook
    2. Sample scripts
  4. Chapter 2: Requirements
    1. DB2 UDB ESE V8
    2. Database server with DB2 administrator and user accounts
    3. IBM N series storage system
    4. Network
    5. Network performance notes
  5. Chapter 3: Configuration overview
    1. Designing a database with recovery in mind
    2. Aggregate and volume configuration
  6. Chapter 4: IBM DB2 UDB databases on IBM N series storage system
    1. Extremely fast backup
    2. Quick recovery
    3. High availability
    4. High reliability
    5. No impact on system response time
    6. Minimum storage requirement
    7. Tablespace container load balance
  7. Chapter 5: Configuring the environment
    1. Configuring the IBM N series storage system (1/2)
    2. Configuring the IBM N series storage system (2/2)
      1. Configuring database server in an NAS environment
      2. IBM AIX
      3. Linux host
      4. Sun Solaris
      5. HP-UX
    3. Configuring a database server in a SAN environment
      1. Linux
      2. AIX (1/2)
      3. AIX (2/2)
      4. Sun Solaris (1/2)
      5. Sun Solaris (2/2)
      6. HP-UX (1/2)
      7. HP-UX (2/2)
  8. Chapter 6: Creating a new database on an IBM N series storage system
    1. Install IBM DB2 UDB
    2. Create a new database
    3. Transaction logs
    4. Database verification
    5. Establishing a database connection
    6. List and verify tablespaces
  9. Chapter 7: Migrating existing DB2 UDB databases to an IBM N series storage system
    1. Migrating a DB2 database using a redirected restore operation
    2. Migrating a DB2 database using db2look and db2move
  10. Chapter 8: Performance considerations
    1. The DB2_PARALLEL_IO registry variable
    2. The DB2 Configuration Advisor
    3. Additional factors that affect performance
  11. Chapter 9: Enabling NVFAIL on the IBM N series
  12. Related publications
    1. IBM Redbooks
    2. Other publications
    3. Online resources
    4. How to get IBM Redbooks
    5. Help from IBM
  13. Index
  14. Back cover

Product information

  • Title: Integrating IBM DB2 with the IBM System Storage N series
  • Author(s): Alex Osuna, Jawahar Lal, Roger Sanders
  • Release date: December 2006
  • Publisher(s): IBM Redbooks
  • ISBN: None