Creating a snapplan

A snapplan specifies snapshot scenarios for the DB2 database (such as online, offline, and instant). The snapplan is used as a basis for creating a snapshot. You must either create or validate a snapplan before you can create the snapshot image.

Prerequisites

  • You must be logged in as the DB2 database administrator.

  • The disk group must be version 110 or higher.

  • Persistent FastResync must be enabled.

  • To set up your snapplan for online snapshots, the database must be in archive log mode.

Usage notes

  • Database FlashSnap functionality is not supported on cloned (duplicated) databases.

  • The snapplan name is user-defined.

  • Each entry in the snapplan is a line in parameter=argument format.

    See the db2ed_vmsnapplan(1M) and db2ed_vmchecksnap(1M) manual page for more information.

To create a snapplan

  1. Access the Create Snapplan wizard.

    See Accessing FlashSnap tasks in the Java GUI.

    See Accessing database tasks in the Web GUI.

  2. Confirm the Database Name. This is a read-only field.

  3. Enter the full path of the snapplan file.

  4. Enter the name of the secondary host.

  5. Enter the snapshot plex tag.

  6. Click Next to continue.

    The Validate/Modify Snapplan screen is displayed with default values set.

  7. If needed, modify any incorrect settings. Then, click Validate to ensure that the settings have been configured correctly.

    For more information regarding the snapplan parameters:

    See "Creating and Working with Snapplans Using dbed_vmchecksnap" in the Veritas Storage Foundation for DB2 Administrator's Guide.

  8. At the confirmation prompt, click Yes to confirm that you want to validate the snapplan.

    If the snapplan was successfully validated, you will receive a confirmation message.

  9. To see the snapplan details, click the Show details checkbox. The snapplan details are displayed in the pop-up window.

    When you have finished reviewing them, click OK.

Snapplan details:

SNAPSHOT_MODE is online_snapshot

PRIMARY_HOST is host1

SECONDARY_HOST is host2

The version of PRIMARY_DG-DB2dg is 110.

SNAPSHOT_DG is SNAP_DB2dg

SNAPSHOT_PLAN_FOR is database

Examining DB2 volume and disk layout for snapshot.

Volume testvol01 on DB2dg is ready for snapshot.
Original plex and DCO log for testvol01 is on DB2dg01 DB2dg02.
Snapshot plex and DCO log for testvol01 is on DB2dg03.

Volume testvol02 on DB2dg is ready for snapshot.
Original plex and DCO log for testvol02 is on DB2dg01 DB2dg02.
Snapshot plex and DCO log for testvol02 is on DB2dg03.

Volume testvol03 on DB2dg is ready for snapshot.
Original plex and DCO log for testvol03 is on DB2dg01 DB2dg02.
Snapshot plex and DCO log for testvol03 is on DB2dg03.

Volume testvol04 on DB2dg is ready for snapshot.
Original plex and DCO log for testvol04 is on DB2dg01 DB2dg02.
Snapshot plex and DCO log for testvol04 is on DB2dg03.

Volume testvol05 on DB2dg is ready for snapshot.
Original plex and DCO log for testvol05 is on DB2dg01 DB2dg02.
Snapshot plex and DCO log for testvol05 is on DB2dg03.

Volume udb_home on DB2dg is ready for snapshot.
Original plex and DCO log for udb_home is on DB2dg01 DB2dg02.
Snapshot plex and DCO log for udb_home is on DB2dg03.

SNAP_DB2dg for snapshot will include: DB2dg03

ALLOW_REVERSE_RESYNC is yes

The snapplan sp1 has been created.