Creating a clone database with a snapshot

After having created a snapshot, you can use the snapshot to create a clone database. The cloned database can be used for decision-making and testing that cannot be done on your production database.

Prerequisites

  • Make sure you have enough disk space to create a clone database on your system.

  • You must have an existing snapshot.

To create a clone database with a snapshot

  1. Click the database object DB2 icon in the object tree. (You may need to expand the tree view to find the icon.)

  2. Access the Create Snapshot Database wizard.

    See Accessing FlashSnap tasks in the Java GUI.

    See Accessing database tasks in the Web GUI.

  3. In the "Authentication" section, enter the Unix user name and password.

  4. For the primary database, enter the DB2 Instance and DB2 Database information.

  5. Select whether you are recovering the database or restarting the database by clicking the appropriate radio button.

    Select Startup database if you are restarting a new snapshot database based on a snapshot.

    Select Restart database if you are restarting a snapshot database that has already been created.

  6. For the snapshot database, enter the new DB2 Database, Snapplan file, volume name, Snapshot disk group name, and Relocate path in the appropriate fields.

    To start an on-host snapshot database, the Relocate path is required. To start an off-host snapshot database, the volume name field is required. You can obtain this information by viewing the details after you create a snapshot. If you did not retain the information from the snapshot creation, you can use the db2ed_vmchecksnap command or use Viewlog via the GUI to retrieve the information.

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

  7. Click Start Database.

  8. At the confirmation prompt, click Yes to confirm that you want to start the database.

    If the snapshot database was successfully started, confirmation message displays. Click OK to continue.