<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=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Arial Rounded MT Bold";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-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;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></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="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">RDB? Oracle? Or straight RMS/ISAM…<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">About 2 years ago we went through the same process (Large Powerhouse application => Alpha->Itanium).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">App was a mix of Oracle and RMS/ISAM (mostly Oracle with a few legacy RMS files hanging around…). (No RDB).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Near Zero problems with the OS/Shell. (Alpha by default ran a stable sort, Itanium ran a unstable sort, so if
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Your quiz/qtp runs were sorting down x levels, and detail lines were at x+1, the order of the detail lines was
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Undetermined. (Subtotals were ok, ie Sort down to the level of a “parent company”, (say Home Depot), then<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Display sales to each individual store, subtotals/grand totals would all be good, but the order in which individual<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Stores printed out was random, (oracle returns data in a random order if you don’t explicitly sort, if you are using pure<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">RMS/ISAM you would be fine as RMS runs indexes and retrieves in order). “I think” there was a logical you could set<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">To force the old behavior, but as this only affected about 4 quiz/qtp runs out of hundreds, we simply added the last sort
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">level to reports. (Cleaner and easier to understand in the long run than using an invisible logical name out at the system level…).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">This was pretty much the only problem we ran into on this. (course we had moved from various VAXes in the past, and from
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">VAX to Alpha, so there is/was a pretty good abstraction layer setup in logical names to hide the physical hardware…).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">“@com:proc2.com”;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Is the @com in the above an “inhouse” symbol/procedure to run a command file? You might want to look at it if so, and see if it’s your problem…<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">If your routine is not too involved, you might want to step through processing one step at a time at the DCL command line to see if something
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Is getting trapped out (and/or confused) by something in the com file wrapper/driver…<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Just a few random thoughts… </span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> powerh-l-bounces+herald.kaffka=westfraser.com@lists.sowder.com [mailto:powerh-l-bounces+herald.kaffka=westfraser.com@lists.sowder.com]
<b>On Behalf Of </b>Thomson, Martyn<br>
<b>Sent:</b> Monday, August 24, 2015 12:03 PM<br>
<b>To:</b> 'powerh-l@lists.sowder.com' <powerh-l@lists.sowder.com><br>
<b>Subject:</b> Alpha to Itanium DCL issue<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-CA">Moving a large PowerHouse app from Alpha to Itanium. Getting strange behaviour with a DCL procedure terminating prematurely.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">DCL procedure proc1.com submitted;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Does a few things then executes proc2.com i.e. “@com:proc2.com”;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Proc2.com runs a dozen QTP programs then drops out to proc1.com prematurely! The QUIZ programs don’t get run; the reports aren’t printed;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">On returning to proc1.com it immediately exits, not executing the remainder of proc1.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">All QTP/QUIZ were recompiled.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">I added “on error then goto err_handler” to both procedures to display $status. Proc2 is terminating with %X1900802A. That’s a QTP error “A file access error has been detected, but the QTP program did write to the database
the number of records shown in the log. The protection on all tables it references is correct. There are no subfiles involved.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Has anyone seen this before? Very puzzled. Any insights, suggestions, etc much appreciated.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">I should point out I searched the logs on the Alpha for this job. It happened once last month for the first time ever.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">OpenVMS 8.4<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Oracle Rdb SQL V7.3-100<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">PowerHouse 8.40G<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-top:6.0pt"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-CA">Regards,
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA" style="font-family:"Arial Rounded MT Bold";color:#1F497D;mso-fareast-language:EN-CA">Martyn Thomson<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA" style="font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-CA">Senior Technical Analyst, Development Services</span><span lang="EN-CA" style="font-family:"Arial Rounded MT Bold";color:#1F497D;mso-fareast-language:EN-CA"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA" style="font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-CA">Information Technology Services<o:p></o:p></span></p>
<p class="MsoNormal"><b><i><span style="font-size:14.0pt;color:#003D83;mso-fareast-language:EN-CA">HP Advanced Solutions Inc.<o:p></o:p></span></i></b></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-CA">phone: 250.405.4555 | fax: 250.405.4422</span><span lang="EN-CA" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-CA"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-CA">email:<a href="mailto:martyn.thomson@hpadvancedsolutions.com">martyn.thomson@hpadvancedsolutions.com</a>
</span><span lang="EN-CA" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-CA"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-CA">web:
<a href="http://www.hpadvancedsolutions.com/">www.hpadvancedsolutions.com</a> <o:p>
</o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
</div>
<p><br>
<br>
-------------EOP--------------- <br>
<br>
This e-mail message and any attachments are confidential. Any dissemination or use of this information by a person other than the intended recipient is unauthorized. If you are not the intended recipient, please notify me by return e-mail, do not open any attachment
and delete this communication and any copy. <br>
<br>
Thank you </p>
</body>
</html>