Difference between revisions of "Vital Signs Restore Prior Months"
>Jeremyb |
>Jeremyb |
||
| 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] | |
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 8: | ||
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 | |
| − | < | + | <nowiki> |
./JVSLOAD_MBRSHLN restore CCYYMMDD | ./JVSLOAD_MBRSHLN restore CCYYMMDD | ||
| − | </ | + | </nowiki> |
(''Where CCYYMMDD is the appropriate month-end value for the data that was restored'') | (''Where CCYYMMDD is the appropriate month-end value for the data that was restored'') | ||
| Line 21: | Line 21: | ||
Step 5. Still logged in as bolive re-run the month-end job to merge all of the extracted months into Vital Signs. | Step 5. Still logged in as bolive re-run the month-end job to merge all of the extracted months into Vital Signs. | ||
| − | < | + | <nowiki> |
./JVSLOAD_MBRSHLN eom CCYYMMDD | ./JVSLOAD_MBRSHLN eom CCYYMMDD | ||
(''WHere CCYYMMDD is the prior EOM'') | (''WHere CCYYMMDD is the prior EOM'') | ||
| − | </ | + | </nowiki> |
Revision as of 22:39, 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'')
