Deploying DB2 Database on the Sun Storage 7000 Unified Storage System

Deploying DB2 Database on the Sun Storage 7000 Unified Storage System

by Cherry Shu
March 2009

For DB2 applications, Sun Storage 7000 Unified Storage Systems meet a range of functional requirements for availability, capacity, and performance. This Sun BluePrints™ article describes the steps needed to configure and install a DB2 database in a Sun Storage 7000 Unified Storage System environment. The article addresses the following topics:

• Preparing a Sun Storage 7000 Unified Storage System for DB2 database storage
• Preparing a server running the Solaris™ Operating System (Solaris OS) to use NFS file systems or Internet SCSI (iSCSI) logical unit numbers (LUNs)
• Installing the DB2 software on the server and creating a database on the storage system
• Separating database transaction log files from data files and storing them on the storage system
• Taking a snapshot of an online DB2 database and recovering from the snapshot

Contents

  • Introduction
  • Sun Storage 7000 Unified Storage Systems
    • Advantages for DB2 databases
  • Deployment configuration
  • Configuring the storage and DB2 database server
    • Configuring the Sun Storage 7000 Unified Storage System
    • Installing and configuring the DB2 database
    • Configuring the database system to use NFS file systems
    • Setting up iSCSI initiators and LUNs on the database system
  • Creating a new database
  • DB2 database backup and recovery scenarios using snapshots
    • Taking a snapshot of an online DB2 database
    • Database recovery from a snapshot
  • Performance considerations
  • About the author
  • References
  • Ordering Sun documents
  • Accessing Sun documentation online
About the Authors

A member of the technical staff in the ISV Engineering group at Sun Microsystems, Cherry Shu assists independent software vendors with technology adoption and performance tuning projects on the Solaris platform.

Rate this blueprint (Log In to vote.)
Choices Your Vote

Great

Good

Fair

Poor

Labels

new new Delete
blueprints blueprints Delete
blueprint blueprint Delete
storage storage Delete
database database Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.

Sign up or Log in to add a comment or watch this page.


The individuals who post here are part of the extended Sun Microsystems community and they might not be employed or in any way formally affiliated with Sun Microsystems. The opinions expressed here are their own, are not necessarily reviewed in advance by anyone but the individual authors, and neither Sun nor any other party necessarily agrees with them.

Copyright 1994-2009 Sun Microsystems, Inc.
Powered by Atlassian Confluence
Sun Guidelines on Public Discourse Privacy Policy Terms of Use Trademarks Site Map Employment Investor Relations Contact