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.
Release : 14.0
Component : CA View
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.