Vital Signs Restore Prior Months

From Vital Soft Wiki
Revision as of 22:25, 22 August 2012 by >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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
  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
Retrieved from "https://wiki.vital-soft.com/index.php?title=Vital_Signs_Restore_Prior_Months&oldid=384"