<div>Hi all and Thank you very much all for help and your suggestions so far ... :-) </div>
<div> </div>
<div>1. ODBC. Can you use ODBC on HPUX? We would prefer to connect via native mode, but will consider all options available once we've exhausted native mode db2.</div>
<div> </div>
<div>2. Peter/Bob: I checked over what the installation people did and we were missing $PH_USR/lib in our SHLIB_PATH. We've now added this and now the DME-E-YV./*W* SQL START DBE error (TEST) .. error is gone because it can now locate the
<a href="http://d2dba.sl">d2dba.sl</a> shared library. Thanks for that...</div>
<div> </div>
<div>But (and there's always a but ;-)...)</div>
<div> </div>
<div>1. I re-compiled a simple dictionary with 2-3 sequential tables and 2-3 tables from the DB2 database</div>
<div>2. I go in quiz</div>
<div>3. I type SHOW FILES</div>
<div>3. At this point, my 3 sequential tables are shown, then when it tries to open the DB2 database (to get metadata i presume), quiz hangs..</div>
<div> </div>
<div>By hanging, I mean it is still accepting input from stdin, but seems to be lost somewhere looking for something...Ctrl-D, Ctrl-Y, Ctrl-Anything does not kill it. Only closing reflections kills it.</div>
<div> </div>
<div>I am not sure how I can determine if we are using the 32-bit or 64-bit client. I have set SHLIB_PATH pointing to the </div>
<div> </div>
<div> /opt/IBM/db2/V8.1/lib directory (NOT the lib64 directory)</div>
<div> </div>
<div>Questions:</div>
<div> </div>
<div>a) Bob, does PH support the 64-bit DB2, 32-bit DB2 or both ?</div>
<div> </div>
<div>b) Peter: I changed to the $PH_USR/lib directory and typed:</div>
<div> </div>
<div> ld <a href="http://d2dba.sl">d2dba.sl</a></div>
<div> </div>
<div> And gor the following error</div>
<div> </div>
<div> ld: Can't open ../../../pahpux/bin//libcogudasql.sl</div>
<div> ld: No such file or directory.</div>
<div> </div>
<div>Sorry for the long winded e-mail, but figured more info would be best.</div>
<div> </div>
<div>Any ideas?</div>
<div> </div>
<div>We appreciate all your help.</div>
<div> </div>
<div>Regards,</div>
<div> </div>
<div>Jim</div>
<div><br><br> </div>
<div><span class="gmail_quote">On 3/29/06, <b class="gmail_sendername">Peter Bateman</b> <<a href="mailto:pfbcs@hotmail.com">pfbcs@hotmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"> Jim:<br><br> I think PowerHouse gives you the message,<br> "DMS-E-YV_LOADSGIFAILED, Unable to load the 'd2dba' gateway."
<br> when it can't find db2dba or when it can't load the DB2 client.<br><br> Did you have any luck getting this to work?<br><br> My guess is that 64 bit DB2 client has been installed on your<br>server.<br>
<br> The UNIX command 'ld' applied to db2dba may give you a clue<br> as to what it is looking for. Check 'man ld' for the syntax.<br><br> I would try a 32 bit client.<br><br><br><a href="http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0410evans/">
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0410evans/</a><br><br>Regards,<br>Peter Bateman<br><br><br> *Subject:* PH and DB2 on HPUX Problems<br>> ><br>> > Hi all,<br>> ><br>> > I am new to this list and I was wondering is anyone could help me out.
<br>> ><br>> > We are migrating from an HP3000 PH 8.19.C1/IMAGE/KSAM to PH on the 9000<br>> > version 8.43.D1<br>> ><br>> > We have also decided to go with DB2 as the back end database.<br>> >
<br>> > DB2 Version is: DB2/HP64 8.2.3<br>> ><br>> > We are getting the following error when we try to access a table in the<br>> > Database.<br>> ><br>> > *W* SQL START DBE error (TEST)
<br>> ><br>> > DMS-E-YV_LOADSGIFAILED, Unable to load the 'd2dba' gateway. Please<br>>ensure<br>> > that<br>> ><br>> > the database software is configured correctly and is supported on this
<br>> > version<br>> ><br>> > of the operating system.<br>> ><br>> > This is the dictionary DATABASE statement in the PDL file.<br>> ><br>> > *Dictionary Statement:*<br>> >
<br>> > DATABASE TEST TYPE DB2 &<br>> ><br>> > OPEN "TESTA" &<br>> ><br>> > USERID "user" PASSWORD "password"
<br>> ><br>> > Has anyone here come across this on the list?<br>> ><br>> > Does anyone have any suggestions on how we can solve this problem<br>>connect<br>> > PH to the DB2 database?<br>> >
<br>> > Thank you all in advance and we look forward to your advice.<br>> ><br>> > Regatds,<br>> ><br>> > Jim<br>> ><br><br><br>>--<br>>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
<br>>Mailing list: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>>Subscribe: "subscribe" in message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com
</a><br>>Unsubscribe: "unsubscribe <password>" in message body to<br>><a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>><a href="http://lists.sowder.com/mailman/listinfo/powerh-l">
http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>>This list is closed, thus to post to the list you must be a subscriber.<br><br>_________________________________________________________________<br>Take advantage of powerful junk e-mail filters built on patented Microsoft®
<br>SmartScreen Technology.<br><a href="http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines">http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
</a><br>Start enjoying all the benefits of MSN® Premium right now and get the<br>first two months FREE*.<br><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com">
powerh-l@lists.sowder.com</a><br>Subscribe: "subscribe" in message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: "unsubscribe <password>" in message body to
<a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a href="http://lists.sowder.com/mailman/listinfo/powerh-l">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>This list is closed, thus to post to the list you must be a subscriber.
<br></blockquote></div><br>