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. 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