<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Shruti;
panose-1:2 0 5 0 0 0 0 0 0 0;}
@font-face
{font-family:Shruti;
panose-1:2 0 5 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{mso-style-priority:99;
mso-style-link:"E-mail Signature Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.E-mailSignatureChar
{mso-style-name:"E-mail Signature Char";
mso-style-priority:99;
mso-style-link:"E-mail Signature";
font-family:"Calibri","sans-serif";}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Arial","sans-serif";
color:navy;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I have solved the same problem, I think, by using two databases.
One as a front end, performing basic validations and data collection, for the web-pages
to communicate with, and one being the main database holding data and doing
calculations. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>The two databases are connected by DB LINKs and processing of
data, done by packaged pl/sql procedures and functions, is run by the built-in
scheduler with short intervals, like a queueing system.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Both DB Links and the scheduler are in 10g stable technologies
and works OK - though database stops and restarts require specific focus on the
scheduler which not in all cases restart as expected.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>It was fairly easy to get the solution up and running, but the
downside is on follow-up in production. It required quite an effort and to
minimize hands on controls I had to build a very basic admin-tool which took
quite a lot of programming – much more than setting up the required
functionality in the first place. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Like John Penney, I would recommend using a queueing tool, if possible,
because so much of the administration of the application in production is
handled. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal style='text-autospace:none'><span style='font-family:"Arial","sans-serif";
color:navy'>Sincerely,<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><b><span style='font-family:
"Arial","sans-serif";color:navy'>Kim Bjørn Jensen</span></b><span
style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-family:"Arial","sans-serif";
color:navy'>Principal Consultant</span><span style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><b><span style='font-size:11.0pt;
color:navy'>Tel:</span></b><span style='font-size:11.0pt;color:navy'> (+47) 23
21 18 37 <b>Mob:</b> (+47) 911 15 313<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:11.0pt;
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=NO-BOK style='font-size:24.0pt;font-family:Webdings;
color:green'>P</span><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:green'> Please consider the environment before printing this e-mail</span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:navy'> </span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><b><span style='font-family:
"Arial","sans-serif";color:navy'><o:p> </o:p></span></b></p>
<p class=MsoNormal style='text-autospace:none'><b><span style='font-family:
"Arial","sans-serif";color:navy'>LINDORFF</span></b><b><span style='font-family:
"Arial","sans-serif";color:#1F497D'> </span></b><i><span style='font-family:
"Arial","sans-serif";color:#1F497D'>- Confidence in Commerce and Credit</span></i><span
style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=NO-BOK
style='font-size:11.0pt;color:navy'>Box 4, NO-3833 Bø i Telemark, Norway <br>
Visiting address: Hellandtunet, Kyrkjevegen, Bø i Telemark <o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><b><span style='font-size:11.0pt;
color:navy'>Tel:</span></b><span style='font-size:11.0pt;color:navy'> (+47) 35
06 15 00 Fax: (+47) 35 06 15 01<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:
6.0pt;margin-left:0cm;text-autospace:none'><span style='font-size:11.0pt;
color:navy'><a href="blocked::http://www.lindorff.no/"><span style='color:navy'>www.lindorff.no</span></a></span><span
style='font-size:11.0pt;font-family:"Arial","sans-serif";color:navy'> </span><span
style='font-size:11.0pt;color:navy'>/ <a
href="blocked::http://www.lindorff.com/"><span style='color:navy'>www.lindorff.com</span></a>
<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:
6.0pt;margin-left:0cm;text-autospace:none'><span style='font-size:11.0pt;
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
color:#1F497D'>** This message including any attachments may <br>
contain confidential and/or priveleged information <br>
intended only for the person or entity to which it is<br>
addressed. If you are not the intended recipient <br>
you should delete this message. Any printing, copying, <br>
distribution or other use of this message is strictly <br>
prohibited. If you have received this message in <br>
error, please notify the sender immediately by telephone, <br>
fax or e-mail and delete all copies of this message and <br>
any attachments from your system. Thank you.<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> powerh-l-bounces+kim-bjorn.jensen=lindorff.com@lists.sowder.com
[mailto:powerh-l-bounces+kim-bjorn.jensen=lindorff.com@lists.sowder.com] <b>On
Behalf Of </b>cfinley<br>
<b>Sent:</b> 13. august 2009 23:48<br>
<b>To:</b> 'Penney, John'; powerh-l@lists.sowder.com<br>
<b>Subject:</b> RE: Database to database communications over LAN<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>I would think that Websphere MQ would be the best choice and
require the least amount of programming. By that I mean, the problem with
sockets in any solution is that it is up to the developer to take care of error
correction, outages, etc. Websphere MQ has much of that built in.
Moreover there are multiple API’s you can use to write the application
including COBOL. Also, there are many free and low cost commercial tools
that can help you with troubleshooting and debugging.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>There are several choice available to you to create such a
solution. One that comes to mind is that Oracle side would use a
combination of stored procedures, triggers and perhaps transactions. The VMS
side will require some sort of simple server application to manage the
communications with the Oracle host and the making of the changes to the RDB
database. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>If this sounds appealing, please contact me directly and I will
brainstorm some implementation ideas with you.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<div>
<p class=MsoAutoSig><span style='color:navy'>Charles Finley<o:p></o:p></span></p>
<p class=MsoAutoSig><span style='color:navy'>(619) 795-0720<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<div>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
powerh-l-bounces+cfinley=xformix.com@lists.sowder.com
[mailto:powerh-l-bounces+cfinley=xformix.com@lists.sowder.com] <b>On Behalf Of </b>Penney,
John<br>
<b>Sent:</b> Thursday, August 13, 2009 2:20 PM<br>
<b>To:</b> powerh-l@lists.sowder.com<br>
<b>Subject:</b> Database to database communications over LAN</span><o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0>
<tr>
<td valign=top style='padding:0cm 0cm 0cm 0cm'>
<div>
<p class=MsoNormal>Hello Powerhouse-l:<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>I need some ideas and this was one of the Forums that came
immediately to mind.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Conceptually we have an application running in JSP, HTML,
Oracle 10g,etc. that has to send information across the LAN to a native
OpenVMS Server running Oracle Rdb and of course PowerHouse. I won't reveal
the version numbers to save people falling off their chairs.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>On VMS in Real Time we need to have a method of receiving
the transmitted data stream, posting ENTRY-FIND-CHANGE transactions to the
Rdb and sending back an acknowledgement that we were (or were not)
successful.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>We're talking 20 - 30 tables with about 1,300 online users
at this point. Order Entry is my main concern. Record maintenance of existing
customers is low volume.<br>
<br>
Already Considered:<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Batch processing is not a solution. Too time consuming and
potential for Network performance issues. Maybe even locking problems on VMS
side?<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>I thought about using MBXs but how you can access MBXs
through a LAN I am unaware of how-to. <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Using one central Oracle 10g database for both sides of
the house - politically sensitive issue - plus the data migration from
Database A to B is probably not feasible.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Socket solution- in the mix.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>MQ messaging- in the mix.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Anybody have any experience conceptually with any of my
issues I'd appreciate a post.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Thanks for all your help in the past ladies and gents.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Cheers!<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><strong>John M Penney</strong><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><strong>(360)789-8159 cellular</strong><o:p></o:p></p>
</div>
</td>
</tr>
</table>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>