Home > Veritas Storage Foundation™ for DB2 Manual Pages

DB2ED_VMSNAPPLAN (4)
Devices

Table of contents

NAME

db2ed_vmsnapplan - the file containing a snapplan for a DB2 database

DESCRIPTION

The db2ed_vmsnapplan file specifies the snapshot scenarios for a DB2 database (such as offline, online_snapshot, or online_mirror). The file name of the db2ed_vmsnapplan file is specified by the user. Before using the db2ed_vmsnap(1M) command to create the snapshot image, a db2ed_vmsnapplan file needs to be validated by running the db2ed_vmchecksnap(1M) command. Each entry in the db2ed_vmsnapplan file is a line in key=value format.

PARAMETERS

The following parameters are specified in the db2ed_vmsnapplan file:
.B
SNAPSHOT_VERSION Specifies the snapshot version for this release of Veritas Storage Foundation for DB2.
PRIMARY_HOST
Specifies the name of the host where the primary database resides.
SECONDARY_HOST
Specifies the name of the host where the clone database will reside. When the primary and secondary hosts are the same, the snapshot volumes will not be deported.
PRIMARY_DG
Specifies the name of the Volume Manager disk group used by the primary database.
SNAPSHOT_DG
Specifies the name of the disk group containing the snaphot volumes. The snapshot volumes will be put into this disk group on the primary host and deported. The secondary host will import this disk group to start a clone database.
DB2DATABASE
Specifies the name of the DB2 database.
DB2HOME
Specifies the home directory of the database.
REDOLOG_DEST
Specifies the full path of the redo logs.
SNAPSHOT_MODE (offline | online_snapshot | online_mirror)
Specifies whether the database should be offline, online_snapshot, or online_mirror when the snapshot is created. If the snapshot is created while the SNAPSHOT_MODE for the database is set to online_snapshot or online_mirror, the db2ed_vmsnap command will first put the database into WRITE SUSPEND mode. After db2ed_vmsnap finishes creating the snapshot, it will take the database out of WRITE SUSPEND mode. If the database is offline, it is not necessary to put the database into WRITE SUSPEND mode.
SNAPSHOT_PLAN_FOR (database)
The default value is database and cannot be changed. Specifies the database object to create a snapshot of. To clone a database using a snapshot image, set SNAPSHOT_PLAN_FOR=database.
SNAPSHOT_PLEX_TAG
Specifies the name of the tag set to the plexes that will be used by db2ed_vmsnap to take the snapshot. The db2ed_vmchecksnap command will use this tag name to search if all the volumes in the database have the plexes with this tag name set.
SNAPSHOT_VOL_PREFIX
Specifies the snapshot volume prefix. Use this variable to specify a prefix for the snapshot volumes split from the primary disk group. A volume name cannot be more than 32 characters.
ALLOW_REVERSE_RESYNC
By default, reverse resynchronization is off (set equal to NO). If it is set to YES, this parameter allows you to restore the original volume from a snapshot. The original database, however, must be down for this operation.
SNAPSHOT_MIRROR
Specifies the number of snapshot mirrors. The default value is 1. To make the snapshots highly available, the snapshot volume should contain more than one mirror. Multiple mirrors allow the snapshot volume to be available even if one of the mirrors is disabled. Before taking a snapshot, make sure all tagged snapshot mirrors are in the SNAPDONE state.

EXAMPLE

The following example shows how to create a snapplan and set the default values for a single host. In this example, the working directory is /export/snap_dir. 


$ /opt/VRTS/bin/db2ed_vmchecksnap -D PROD \.br
-f snap1 -o setdefaults -t host2 -p PRODtag


Snapplan snap1 for PROD.


=====================================================


SNAPSHOT_VERSION=5.0


PRIMARY_HOST=host1


SECONDARY_HOST=host1


PRIMARY_DG=PRODdg


SNAPSHOT_DG=SNAP_PRODdg


DB2DATABASE=PROD


REDOLOG_DEST=/PRODhome/inst1/NODE00001/SQL00001/SQLOGDIR/


SNAPSHOT_MODE=online_snapshot


SNAPSHOT_PLAN_FOR=database


SNAPSHOT_PLEX_TAG=PRODtag


SNAPSHOT_VOL_PREFIX=SNAP_


ALLOW_REVERSE_RESYNC=no


SNAPSHOT_MIRROR=1

SEE ALSO

db2ed_vmchecksnap(1M), db2ed_vmsnap(1M), db2ed_vmclonedb(1M)

Veritas Storage Foundation for DB2 Administrator's Guide

Last updated: 13 Dec 2004
Copyright ©2009 Symantec Corporation
All rights reserved.