Difference between revisions of "Vital Signs Restore Prior Months"
>Jeremyb |
>Jeremyb |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Step 1. Configure the Restore Eloquence Instance | Step 1. Configure the Restore Eloquence Instance | ||
| − | + | * Login as askplus | |
| − | + | * Modify the Eloquence Instance set for EQ_DBSERVER in the [[vsrvtcp.ini]] profile [vsdata_live_restore] | |
| + | |||
| + | <pre> | ||
| + | [vsdata_live_restore] | ||
| + | login=bolive | ||
| + | Directory=/home/users/bolive/vsdata | ||
| + | TEMP=/home/users/bolive/vsdata/temp | ||
| + | EQ_DBSERVER=localhost:eloq-TEST | ||
| + | script_path=/ASKPLUS/vsdata/scripts | ||
| + | custom_path=/ASKPLUS/vsdata/custom/live | ||
| + | Vmgr=/ASKPLUS/vsdata/custom/live/vmgr_eom | ||
| + | </pre> | ||
Step 2. Restore the desired membrs.report and membr2.report databases to the Eloquence instance you selected in the prior step. | Step 2. Restore the desired membrs.report and membr2.report databases to the Eloquence instance you selected in the prior step. | ||
| Line 8: | Line 19: | ||
Step 3. Extract multiple EOMs | Step 3. Extract multiple EOMs | ||
| − | + | * Login as bolive | |
| − | + | * Run the LOAD script with the restore parameter followed by the CYMD date for the reports databases that were restored in step 2 | |
<pre> | <pre> | ||
Latest revision as of 22:41, 22 August 2012
Step 1. Configure the Restore Eloquence Instance
- Login as askplus
- Modify the Eloquence Instance set for EQ_DBSERVER in the vsrvtcp.ini profile [vsdata_live_restore]
[vsdata_live_restore] login=bolive Directory=/home/users/bolive/vsdata TEMP=/home/users/bolive/vsdata/temp EQ_DBSERVER=localhost:eloq-TEST script_path=/ASKPLUS/vsdata/scripts custom_path=/ASKPLUS/vsdata/custom/live Vmgr=/ASKPLUS/vsdata/custom/live/vmgr_eom
Step 2. Restore the desired membrs.report and membr2.report databases to the Eloquence instance you selected in the prior step.
Step 3. Extract multiple EOMs
- Login as bolive
- Run the LOAD script with the restore parameter followed by the CYMD date for the reports databases that were restored in step 2
./JVSLOAD_MBRSHLN restore CCYYMMDD
(Where CCYYMMDD is the appropriate month-end value for the data that was restored)
Step 4. Repeat steps 2 and 3 for all the months that you want to load.
Step 5. Still logged in as bolive re-run the month-end job to merge all of the extracted months into Vital Signs.
./JVSLOAD_MBRSHLN eom CCYYMMDD
(''WHere CCYYMMDD is the prior EOM'')
