Difference between revisions of "Vital Signs Restore Prior Months"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
>Jeremyb
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
#Configure the Restore Eloquence Instance
+
Step 1. Configure the Restore Eloquence Instance
  
- 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]
  
##Restore the membrs.report and membr2.report databases to the Eloquence instance you selected in the prior step.
+
<pre>
###Extract multiple EOMs
+
[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>
  
- login as bolive
+
Step 2. Restore the desired membrs.report and membr2.report databases to the Eloquence instance you selected in the prior step.
- run the LOAD script with the restore parameter for the earliest month:
+
 
 +
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
  
 
<pre>
 
<pre>
 
   ./JVSLOAD_MBRSHLN restore CCYYMMDD
 
   ./JVSLOAD_MBRSHLN restore CCYYMMDD
 
</pre>
 
</pre>
(''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.
+
(''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.
  
#Still logged in as bolive re-run the month-end job:
+
Step 5. Still logged in as bolive re-run the month-end job to merge all of the extracted months into Vital Signs.
  
 
<pre>
 
<pre>
./JVSLOAD_MBRSHLN eom
+
./JVSLOAD_MBRSHLN eom CCYYMMDD
 +
(''WHere CCYYMMDD is the prior EOM'')
 
</pre>
 
</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'')