<HTML >
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4943.400" name=GENERATOR></HEAD>
<BODY >
<DIV>
<DIV><SPAN class=350353800-30032006><FONT face=Arial color=#0000ff size=2>1. We
support DataDirect ODBC to SQL Server. This is not what you want. Use a native
connect to DB2.</FONT></SPAN></DIV>
<DIV><SPAN class=350353800-30032006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=350353800-30032006><FONT face=Arial color=#0000ff size=2>2.
Time to contact Customer Support.</FONT></SPAN></DIV>
<DIV><SPAN class=350353800-30032006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=350353800-30032006><FONT face=Arial color=#0000ff
size=2>Bob</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com]<B>On Behalf
Of </B>Jim Ranger<BR><B>Sent:</B> March 29, 2006 6:14 PM<BR><B>To:</B> Peter
Bateman<BR><B>Cc:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> Re: PH and
DB2 on HPUX Problems<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV> This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you. </DIV></BODY></HTML>