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

The sample batch files provided are only examples. Because no two environments or configurations
are exactly the same, you MUST modify the sample scripts in order to make the solution work in your
environment.
Configuring the replication set
IBM DB2 UDB creates multiple files for each database. You must make sure that all necessary files
are included in the replication set so that they will be available on the target server.
For a default DB2 installation, you must include the following in your replication set:
Files/Folders to Protect in Replication SetDB2
Version
• Database files. Database files are located in a folder named after the DB2 instance in the
root of each drive that has database files (<drive> : <db2 instance name>, for ex-
ample, f:\db2)
• Table space files. To find the directories that contain the table spaces for each database, run
the DB2 Control Center, select the Table Spaces folder under each database, right-click each
table space in the right pane, select Alter, select the Containers tab, and view the Container
name field.
• Database logs. To find the directories that contain the log files for each database, run the
DB2 Control Center, right-click the database, select Configure Database Logging, and select
“Logging Location”.
• DB2 configuration files. These files include the configuration information including what
databases are attached. They are located at <db2 install path>\<DB2 instance
name> for exampleC:\Program Files\IBM\SQLLIB\DB2.
8.x
Database files. Database files are located in a folder named after the DB2 instance in the root
of each drive that has database files (<drive> : <db2 instance name>, for example,
e:\db2).
9.x
NOTE:
You do not need to replicate the application files, since they already exist on the target machine.
Managing DB2 services
DB2 services will need to be started on the target server when failover is initiated, and stopped on
the target server prior to initiating failback to the source.
The following services must be started/stopped for DB2 v 8.x:
• DB2 Governor
• DB2 JDBC Applet Server
• DB2 License Server
• DB2 Remote Command Server
• DB2 Security Server
• DB2DAS - DB2DAS00
• DB2 - DB2-0
Solution Overview10