What are the Ways to Back Up a CA View Database, and What Would be Their Recovery Steps?

Products

• Deliver
• View

Issue/Introduction

What are the ways to back up a CA View database, and what would be the corresponding recovery steps?

Environment

CA View - All Releases

Resolution

There are multiple ways to bring back an entire View database. 

The method to use depends on whether the following is done:

 

 . If a View standard backup is run, based on the SARINIT parameters DAYS and TIME, a SARDBASE RESTORE can be done from a backup of the View index.

 . . If Forward Recovery is used (i.e., non-default values used for the SARINIT RCVPRIM, RCVSEC, RCVUNIT,  and RCVSPACE parameters), those reports written can be added in the RESTORE process, to bring the database back to full content.

 . If full-volume backups are done (using DFDDS, FDR, etc.), databases can be loaded from the backups.

 . If the View SARDBASE UNLOAD utility is used, a SARDBASE LOAD can be done to restore the database.

 

Notes:

 . In the use of Forward Recovery, currently only reports collected by the SARSTC are written to the Forward Recovery dataset.

   This does not include any reports directly-written by the Deliver RMOSTC task or those reports collected by SARFSS tasks. 

 

 . If full-volume backups or a SARDBASE UNLOAD is done, the back up (a snapshot) must begin with all tasks against the database being stopped.

   These tasks include: SARSTC, SARFSS, SARXMS, and any CA Deliver RMOSTC tasks that do direct-writing to the database.

 

 . With use of full-volume backups or SARDBASE UNLOAD, any reports collected after the backup is performed will not appear on the database.