PREPARE DATABASE is an online method of taking a snapshot of Sybase devices.
The advantage of this method is that it does not quiesce the databases. Users connected to the databases remain online, and can perform read and write operations on the databases.
PREPARE DATABASE is supported on Sybase ASE version 15.7 SP130, Sybase ASE version 16.0 SP01 and later.
Before You Begin
Procedure
-
To the client computer, add the sSybUsePrepareCmd additional setting as shown in the following table.
For instructions about adding an additional setting from the CommCell Console, see Adding or Modifying Additional Settings from the CommCell Console.
Property
Value
Name
sSybUsePrepareCmd
Category
SybaseAgent
Type
String
Value
Y
-
From the CommCell Browser, expand Client Computers > client > Sybase > instance.
-
Right click the subclient, and click Backup.
The Backup Options for Subclient dialog box appears.
-
In the Backup Type section, select Full.
-
In the Job Initiation section, choose whether to run the backup job immediately or on a schedule.
-
Click OK.
Note
If you use a third party vendor solution that integrates SAP ASE, the vendor software must guarantee that the snapshot does not include any disk blocks that were changed after the snapshot was taken. If the storage vendor cannot guarantee this, you run the risk of database corruption of the snapshots when you mount them or bring them online. As per SAP only EMC Enginuity, is currently certified to work with ASE.
This is independent of the physical storage architecture such as file system, raw, and so on. This is also independent of the deployment architecture such as a single or multiple SAN, filer or NFS host.
For more information, go to Performing a Database Copy Without Suspending Transaction Activity on the SAP documentation website.