PH and DB2 on HPUX Problems
Peter Bateman
pfbcs at hotmail.com
Thu Mar 30 13:19:24 CST 2006
Jim:
I am between engagements. So I don't have a machine to try this stuff.
I agree with Bob. It is time to talk to support.
Ask them What is ../../../pahpux/bin//libcogudasql.sl? and when should it
have been install?
Maybe they can send you a zipped version if you don't have one.
I didn't look very hard at IBM article. I thought it would show you which
client you have.
There maybe a call that you could make to one of the IBM command line
utilities that would show
that information. It has been awhile since I have used DB2.
Regards,
Peter
>
>1. We support DataDirect ODBC to SQL Server. This is not what you want. Use
>a native connect to DB2.
>
>2. Time to contact Customer Support.
>
>Bob
>
>-----Original Message-----
>From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
>[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com]On Behalf
>Of Jim Ranger
>Sent: March 29, 2006 6:14 PM
>To: Peter Bateman
>Cc: powerh-l at lists.sowder.com
>Subject: Re: PH and DB2 on HPUX Problems
>
>
>Hi all and Thank you very much all for help and your suggestions so far ...
>:-)
>
>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.
>
>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 d2dba.sl shared library. Thanks for that...
>
>But (and there's always a but ;-)...)
>
>1. I re-compiled a simple dictionary with 2-3 sequential tables and 2-3
>tables from the DB2 database
>2. I go in quiz
>3. I type SHOW FILES
>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..
>
>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.
>
>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
>
> /opt/IBM/db2/V8.1/lib directory (NOT the lib64 directory)
>
>Questions:
>
>a) Bob, does PH support the 64-bit DB2, 32-bit DB2 or both ?
>
>b) Peter: I changed to the $PH_USR/lib directory and typed:
>
> ld d2dba.sl
>
> And gor the following error
>
> ld: Can't open ../../../pahpux/bin//libcogudasql.sl
> ld: No such file or directory.
>
>Sorry for the long winded e-mail, but figured more info would be best.
>
>Any ideas?
>
>We appreciate all your help.
>
>Regards,
>
>Jim
>
>
>
>On 3/29/06, Peter Bateman < pfbcs at hotmail.com> wrote:
>
> Jim:
>
> I think PowerHouse gives you the message,
> "DMS-E-YV_LOADSGIFAILED, Unable to load the 'd2dba' gateway."
> when it can't find db2dba or when it can't load the DB2 client.
>
> Did you have any luck getting this to work?
>
> My guess is that 64 bit DB2 client has been installed on your
>server.
>
> The UNIX command 'ld' applied to db2dba may give you a clue
> as to what it is looking for. Check 'man ld' for the syntax.
>
> I would try a 32 bit client.
>
>
>http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0410evans/
>
>Regards,
>Peter Bateman
>
>
> *Subject:* PH and DB2 on HPUX Problems
> > >
> > > Hi all,
> > >
> > > I am new to this list and I was wondering is anyone could help me out.
> > >
> > > We are migrating from an HP3000 PH 8.19.C1/IMAGE/KSAM to PH on the
>9000
> > > version 8.43.D1
> > >
> > > We have also decided to go with DB2 as the back end database.
> > >
> > > DB2 Version is: DB2/HP64 8.2.3
> > >
> > > We are getting the following error when we try to access a table in
>the
> > > Database.
> > >
> > > *W* SQL START DBE error (TEST)
> > >
> > > DMS-E-YV_LOADSGIFAILED, Unable to load the 'd2dba' gateway. Please
> >ensure
> > > that
> > >
> > > the database software is configured correctly and is supported on this
> > > version
> > >
> > > of the operating system.
> > >
> > > This is the dictionary DATABASE statement in the PDL file.
> > >
> > > *Dictionary Statement:*
> > >
> > > DATABASE TEST TYPE DB2 &
> > >
> > > OPEN "TESTA" &
> > >
> > > USERID "user" PASSWORD "password"
> > >
> > > Has anyone here come across this on the list?
> > >
> > > Does anyone have any suggestions on how we can solve this problem
> >connect
> > > PH to the DB2 database?
> > >
> > > Thank you all in advance and we look forward to your advice.
> > >
> > > Regatds,
> > >
> > > Jim
> > >
>
>
> >--
> >= = = = = = = = = = = = = = = = = = = = = = = = = = = =
> >Mailing list: powerh-l at lists.sowder.com
> >Subscribe: "subscribe" in message body to
>powerh-l-request at lists.sowder.com
><mailto:powerh-l-request at lists.sowder.com>
> >Unsubscribe: "unsubscribe <password>" in message body to
> > powerh-l-request at lists.sowder.com
> > <http://lists.sowder.com/mailman/listinfo/powerh-l>
>http://lists.sowder.com/mailman/listinfo/powerh-l
> >This list is closed, thus to post to the list you must be a subscriber.
>
>_________________________________________________________________
>Take advantage of powerful junk e-mail filters built on patented Microsoft
>SmartScreen Technology.
>http://join.msn.com/?pgmarket=en-ca
><http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines>
>&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
>Start enjoying all the benefits of MSN Premium right now and get the
>first two months FREE*.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
> 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.
_________________________________________________________________
Don't just Search. Find! http://search.sympatico.msn.ca/default.aspx The new
MSN Search! Check it out!
More information about the powerh-l
mailing list