Difference between revisions of "Vital Signs Restore Prior Months"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
>Jeremyb
 
(One intermediate revision by the same user not shown)
Line 3: Line 3:
 
* Login as askplus
 
* Login as askplus
 
* Modify the Eloquence Instance set for EQ_DBSERVER in the [[vsrvtcp.ini]] profile [vsdata_live_restore]
 
* Modify the Eloquence Instance set for EQ_DBSERVER in the [[vsrvtcp.ini]] profile [vsdata_live_restore]
 +
 +
<pre>
 +
[vsdata_live_restore]
 +
login=bolive
 +
Directory=/home/users/bolive/vsdata
 +
TEMP=/home/users/bolive/vsdata/temp
 +
EQ_DBSERVER=localhost:eloq-TEST
 +
script_path=/ASKPLUS/vsdata/scripts
 +
custom_path=/ASKPLUS/vsdata/custom/live
 +
Vmgr=/ASKPLUS/vsdata/custom/live/vmgr_eom
 +
</pre>
  
 
Step 2. Restore the desired membrs.report and membr2.report databases to the Eloquence instance you selected in the prior step.
 
Step 2. Restore the desired membrs.report and membr2.report databases to the Eloquence instance you selected in the prior step.
Line 11: Line 22:
 
* Run the LOAD script with the restore parameter followed by the CYMD date for the reports databases that were restored in step 2
 
* Run the LOAD script with the restore parameter followed by the CYMD date for the reports databases that were restored in step 2
  
<nowiki>
+
<pre>
 
   ./JVSLOAD_MBRSHLN restore CCYYMMDD
 
   ./JVSLOAD_MBRSHLN restore CCYYMMDD
</nowiki>
+
</pre>
  
 
(''Where CCYYMMDD is the appropriate month-end value for the data that was restored'')
 
(''Where CCYYMMDD is the appropriate month-end value for the data that was restored'')
Line 21: Line 32:
 
Step 5. Still logged in as bolive re-run the month-end job to merge all of the extracted months into Vital Signs.
 
Step 5. Still logged in as bolive re-run the month-end job to merge all of the extracted months into Vital Signs.
  
<nowiki>
+
<pre>
 
./JVSLOAD_MBRSHLN eom CCYYMMDD
 
./JVSLOAD_MBRSHLN eom CCYYMMDD
 
(''WHere CCYYMMDD is the prior EOM'')
 
(''WHere CCYYMMDD is the prior EOM'')
</nowiki>
+
</pre>

Latest revision as of 22:41, 22 August 2012

Step 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]
[vsdata_live_restore]
login=bolive
Directory=/home/users/bolive/vsdata
TEMP=/home/users/bolive/vsdata/temp
EQ_DBSERVER=localhost:eloq-TEST
script_path=/ASKPLUS/vsdata/scripts
custom_path=/ASKPLUS/vsdata/custom/live
Vmgr=/ASKPLUS/vsdata/custom/live/vmgr_eom

Step 2. Restore the desired membrs.report and membr2.report databases to the Eloquence instance you selected in the prior step.

Step 3. Extract multiple EOMs

  • Login as bolive
  • Run the LOAD script with the restore parameter followed by the CYMD date for the reports databases that were restored in step 2
  ./JVSLOAD_MBRSHLN restore CCYYMMDD

(Where CCYYMMDD is the appropriate month-end value for the data that was restored)

Step 4. Repeat steps 2 and 3 for all the months that you want to load.

Step 5. Still logged in as bolive re-run the month-end job to merge all of the extracted months into Vital Signs.

./JVSLOAD_MBRSHLN eom CCYYMMDD
(''WHere CCYYMMDD is the prior EOM'')