Sybase Database in a SAN Environment Using EVA Snapclone Technology (August 2007)

Advantages of Cloning a Database Using EVA Snapclone

Technology

There are business needs that require production or near-production data. These needs can

be satisfied by creating a clone of the production database. However, the added overhead

and complexities associated with the traditional method of creating a clone database pose

immense problems for database and storage administrators.

The EVA Snapclone technology, on the contrary, has made the process of cloning a

database c simple and easy. Using this technology, you can clone a database within a few

seconds without any system overhead. The cloned database created using the EVA

Snapclone feature can reside either on the same storage system as the original database, or

on a different storage system.

A database cloned using EVA Snapclone technology offers the following advantages:

• Eliminates the overhead required to create database backup images.

• Enables rapid cloning of entire systems.

• Enables quick implementation of idle standby failover.

The following key business requirements benefit from a cloned database created using EVA

Snapclone technology:

• Writeable Disaster Recovery Destination

• Reporting Environment

• Database Software and Application Upgrade Test

• Data Mining

• Standby Database

• Application Testing

• Online Database Backup

Cloning a DB2 Database Using EVA Snapclone Technology

The following sections describe how to clone a DB2 database.

Ensuring Consistency for a DB2 UDB Database (Suspended I/O)

To obtain a consistent Snapclone copy of an online recoverable DB2 UDB database, all write

operations must be suspended before creating a Snapclone. IBM DB2 UDB 7.1 (FixPak 2)