Vital Signs Restore Prior Months

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]

1. 1. Restore the membrs.report and membr2.report databases to the Eloquence instance you selected in the prior step.
      1. 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.

1. Still logged in as bolive re-run the month-end job:

./JVSLOAD_MBRSHLN eom