Difference between revisions of "Vital Signs Restore Prior Months"

From Vital Soft Wiki
Jump to: navigation, search
>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]
+
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:
+
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

  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