Guidelines for using IBM DB2 Universal Database (UDB) with HP StorageWorks Storage Mirroring (T2558-96335, June 2009)
path. (For detailed information on connecting a source and target, see the HP StorageWorks
Storage Mirroring user’s guide.)
10. Select One to One to map the replication set data from the source to an identical volume/directory
structure on the target.
11. On the Orphans tab, select the Move/Delete Orphan Files checkbox.
12. On the Mirroring tab, select the type of mirror, either Full or File Differences, to perform.
NOTE:
If the target has been previously mirrored to or restored, select File differences with the
Use block checksum option so that only the changed data is sent across the network.
13. Click Connect to start the mirror and replication processes.
NOTE:
If you start DB2 and mount the replicated databases on the target, or if the data on the target is
otherwise modified, the data on the source and target will no longer match. If the updated data
on the target is not needed, perform a full or difference with block checksum mirror from the
source to the target. If the updated data on the target is needed, restore the data from the target
to the source.
Configure failover
The following steps should be performed on the target server.
1. If a failure occurs, you will want the DB2 services to start on the target machine automatically.
To do this, create a batch file called failover.bat using the sample batch file below. The
following script should be run after failover has completed. Save the batch file to the same directory
where your Storage Mirroring files are installed.
NOTE:
These sample batch files are available on the Storage Mirroring Software support web site 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.
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.
Guidelines for using IBM® DB2® Universal Database® (UDB) with HP StorageWorks Storage Mirror-
ing 15