search cancel

CA View - How to Migrate Reports that Went to Another Database

book

Article ID: 133462

calendar_today

Updated On:

Products

Deliver View

Issue/Introduction

Due to an incorrect setting in CA Deliver, reports were sent to an unintended View database. 

The client has two View databases, and reports were collected to a wrongly-assigned database. 

They want to move those reports to the proper database. 


Environment

Release : 14.0

Component : CA View

Resolution

To move some reports from one database to another database, here is the process: 

 . With all tasks down, run a SARDBASE Selective, or full, UNLOAD on the database that has, but should not have, the reports.   

 . With all tasks down, run a SARDBASE full UNLOAD on the database that should have been the target.

 . Create a new database.

 . Run a SARINIT, with only the NAME=... card, against the current database.

 . Run a SARINIT, with only the NAME=... card, against the database that should not have the reports.   

  . Run a SARDBASE MERGE to the new database, using inputs of the UNLOADS done above.  

 . SARDBASE RENAME the current database to another name.

 . SARDBASE RENAME the new database to the current database name.

 . Run a SARINIT, with only the NAME=... card, against the (new) current database.

 . Compare the parameters of the original database to those of the current database.

 . Make any changes, if needed, and update the current database accordingly.

. Start the tasks against the current database.  

 . Run SARPAC on the current database, so that its reports go to new tapes.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Notes: 

 . The above list should be evaluated for time, as there will need to be outages for both of the databases.  

. To prepare, run a SARDBASE UNLOAD against the databases, to get an idea of how long it will take, however the output will be of no use.   

 . For timing purposes, consider that the MERGE could take as long as the timing of the UNLOADS combined.