Difference between revisions of "Vital Signs Restore Prior Months"
>Jeremyb (Created page with "# Configure the Restore Eloquence Instance * Login as askplus * Modify the Eloquence Instance set for EQ_DBSERVER in the vsrvtcp.ini profile [vsdata_live_restore] # Resto...") |
>Jeremyb |
||
| Line 1: | Line 1: | ||
# Configure the Restore Eloquence Instance | # Configure the Restore Eloquence Instance | ||
| − | + | ||
| − | + | Login as askplus | |
| + | Modify the Eloquence Instance set for EQ_DBSERVER in the [[vsrvtcp.ini]] profile [vsdata_live_restore] | ||
# Restore the membrs.report and membr2.report databases to the Eloquence instance you selected in the prior step. | # Restore the membrs.report and membr2.report databases to the Eloquence instance you selected in the prior step. | ||
# Extract multiple EOMs | # Extract multiple EOMs | ||
| − | + | ||
| − | + | login as bolive | |
| + | run the LOAD script with the restore parameter for the earliest month: | ||
| + | |||
<pre> | <pre> | ||
./JVSLOAD_MBRSHLN restore CCYYMMDD | ./JVSLOAD_MBRSHLN restore CCYYMMDD | ||
Revision as of 22:30, 22 August 2012
- Configure the Restore Eloquence Instance
Login as askplus Modify the Eloquence Instance set for EQ_DBSERVER in the vsrvtcp.ini profile [vsdata_live_restore]
- Restore the membrs.report and membr2.report databases to the Eloquence instance you selected in the prior step.
- Extract multiple EOMs
login as bolive run the LOAD script with the restore parameter for the earliest month:
./JVSLOAD_MBRSHLN restore CCYYMMDD
(Where CCYYMMDD are the appropriate month-end values for the data that you restored)
Repeat steps 2 and 3 for all the months that you want to load (Jan to June). Based on the stdlist that I ran looked at, the job should take around 15 mins, maybe a little longer during the day. (I modified JVSLOAD_MBRSHLN so that it only does the host extract and ftp - it does not refresh all of the Vital Signs files.
- Still logged in as bolive re-run the month-end job:
./JVSLOAD_MBRSHLN eom
