Guidelines for using IBM DB2 Universal Database (UDB) with HP StorageWorks Storage Mirroring (T2558-96335, June 2009)

1 Solution Overview
IBM DB2 UDB is a scalable, reliable, flexible, and high-performance relational database management
system for Microsoft® Windows® server-based systems. Storage Mirroring provides real-time enterprise
data protection and replication. Storage Mirroring can be used to provide high availability for your
DB2 database.
This document describes the steps necessary to configure Storage Mirroring to provide high availability
for Windows 200x servers running IBM DB2 UDB. These procedures allow a secondary server to
assume the identity and role of a failed DB2 server while maintaining the availability of DB2 services
with minimal disruption or data loss.
To complete these instructions, you will install DB2 and Storage Mirroring, and configure Storage
Mirroring for replication and failover. Due to the complexities of these applications, this document is
intended for network administrators with experience installing, configuring, and maintaining network
applications including Storage Mirroring and IBM DB2.
Configuration
In this solution, a single server is configured to act as the DB2 server. Storage Mirroring is used to
replicate and failover the DB2 server database to a Storage Mirroring target machine. In the event
of a source failure, the clients are directed to the target server.
Modifying the sample script files
Sample batch files are available at http://support.hp.com.
After you modify the sample scripts, save them with a new name to remove the SAMPLE_ prefix. Copy
the scripts to the directory where Storage Mirroring is installed.
Guidelines for using IBM® DB2® Universal Database® (UDB) with HP StorageWorks Storage Mirror-
ing 9