CA View - Moving CA-View/CA-Deliver databases

Products

• Deliver
• View

Issue/Introduction

The client needs to move their CA View and CA Deliver databases from one set of DASD volumes to another, and would like to know how to go about it.

Environment

Release : 14.0

Component : CA View

Resolution

Before backing up or moving any View or Deliver database extents, ensure that all tasks are down against the database that is being moved. 

This includes, for View database extents, that all Deliver RMOSTC tasks be down, that do direct writing to View (RMOPARM ARCHn=DIRECT[/...]).

FDR or DFDSS can be used to move View and Deliver database extents from one volume to another. 

To do so requires that the track architectures be the same across the volumes. 

When moving anything View, ensure that the first index extent of a database (....SARDBASE.I0000001) is not on the same volume as the first data extent of that database (....SARDBASE.D0000001).  

This would also hold true for the first extent of a Deliver database (...RMODBASE.D0000001), and the Deliver checkpoint file (....RMODBASE.C0000001). 

Here is a method of backing up a View database:

 . Shut down all activity to the database. 

 . Run SARINIT, with FORM=9999.

 . Start the SARSTC task (at this time, report collection should not take place).

 . Issue "/F sarstc,NEW", to perform a backup to a new tape. 

 . Bring down the SARSTC task. 

With the above, every report will then be on tape. 

Another method of backing up a View database is to:

 . Shut down all activity to the database. 

 . Run SARDBASE UNLOAD. 

A method to create a new View database, from an index backup, is as follows:

 . Run SARDBASE ADDDS, to create a new database. 

 . Run a SARDBASE RESTORE to the database. 

 . Run SARDBASE OLOAD. 

 . Run SARDBASE BLOAD. 

 . Run SARINIT, to analyze the parameters. 

 . Run SARRSP, to move reports to the disk layer. 

A method to create a new View database, from an UNLOAD file, is as follows:

 . Run SARDBASE ADDDS, to create a new database. 

 . Run a SARDBASE LOAD to the database. 

 . Run SARINIT, to analyze the parameters. 

Depending on the size of the database, you would need to decide whether doing the 

View-backup/RESTORE, or the SARDBASE UNLOAD would serve best.