IBM E16RMLL-I Implementation Guide - Page 235
Database mirroring
![]() |
View all IBM E16RMLL-I manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 235 highlights
mirror database volumes on the other. Table 5-2 shows how the volume placement would work. We assume for the UNIX examples, that /tsm and /tsm1 are file systems created on separate disks. Table 5-2 Database and recovery log volume placement on two disks Type of volume UNIX directories Windows location Database volumes /tsm/primary/database D:\TSMDATA\DBP Mirrored database volumes /tsm1/mirror/database E:\TSMDATA\DBM Log volumes /tsm1/primary/log E:\TSMDATA\RLP Mirrored log volumes /tsm/mirror/log D:\TSMDATA\RLM AIX tip: We recommend that you use Tivoli Storage Manager mirroring rather than AIX mirroring if you are using raw logical volumes. AIX tracks mirroring activity by writing control information to the first 512 bytes of the USER area in a raw volume. This is not a problem for database and recovery log volumes, but Tivoli Storage Manager control information is also written in this area. If AIX overwrites Tivoli Storage Manager control information when raw volumes are mirrored, Tivoli Storage Manager may not be able to vary the volume online. 5.6.1 Database mirroring To mirror the database, use the define dbcopy administrative command or the DSMFMT utility for each volume that you want to mirror. Example 5-12 shows how to create a mirror volume of the volume created in Example 5-1 on page 191 using define dbcopy. Example 5-12 Defining and querying database volume mirrors tsm: LOCHNESS_SERVER1>define dbcopy c:\tsmdata\dbp\dbv_01.dsm d:\tsmdata\dbm\dbm_01.dsm formatsize=1024 wait=yes ANR0984I Process 79 for DEFINE DBCOPY started in the FOREGROUND at 16:16:41. ANR2242I Database volume copy D:\TSMDATA\DBM\DBM_01.DSM defined; synchronization process started (process ID 80). ANR0986I Process 79 for DEFINE DBCOPY running in the FOREGROUND processed 1 items for a total of 1,074,790,400 bytes with a completion state of SUCCESS at 16:16:41. tsm: LOCHNESS_SERVER1>query process Process Process Description Status Chapter 5. Database and recovery log 205
![](/manual_guide/products/ibm-e16rmlli-implementation-guide-3588123/235.png)