Difference between revisions of "Vital Signs Restore Prior Months"
>Jeremyb |
>Jeremyb |
||
| Line 1: | Line 1: | ||
| − | + | 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] | |
| − | + | 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 | ||
<pre> | <pre> | ||
./JVSLOAD_MBRSHLN restore CCYYMMDD | ./JVSLOAD_MBRSHLN restore CCYYMMDD | ||
</pre> | </pre> | ||
| − | |||
| − | Repeat steps 2 and 3 for all the months that you want to load | + | (''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. | |
<pre> | <pre> | ||
| − | ./JVSLOAD_MBRSHLN eom | + | ./JVSLOAD_MBRSHLN eom CCYYMMDD |
| + | (''WHere CCYYMMDD is the prior EOM'') | ||
</pre> | </pre> | ||
Revision as of 22:38, 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]
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'')
