Difference between revisions of "Vital Signs Restore Prior Months"
>Jeremyb |
>Jeremyb |
||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
* Login as askplus | * Login as askplus | ||
* Modify the Eloquence Instance set for EQ_DBSERVER in the [[vsrvtcp.ini]] profile [vsdata_live_restore] | * 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 11: | Line 22: | ||
* Run the LOAD script with the restore parameter followed by the CYMD date for the reports databases that were restored in step 2 | * Run the LOAD script with the restore parameter followed by the CYMD date for the reports databases that were restored in step 2 | ||
| − | < | + | <pre> |
./JVSLOAD_MBRSHLN restore CCYYMMDD | ./JVSLOAD_MBRSHLN restore CCYYMMDD | ||
| − | </ | + | </pre> |
(''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 32: | ||
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. | ||
| − | < | + | <pre> |
./JVSLOAD_MBRSHLN eom CCYYMMDD | ./JVSLOAD_MBRSHLN eom CCYYMMDD | ||
(''WHere CCYYMMDD is the prior EOM'') | (''WHere CCYYMMDD is the prior EOM'') | ||
| − | </ | + | </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'')
