PH and DB2 on HPUX Problems
Richard Sheehan
sheerich at isu.edu
Thu Mar 30 17:42:05 CST 2006
I'm not fully into understanding this whole request; but I will offer a
little bit of insight that seems far too obvious to me.
I don't believe that ../../../pahpux/bin//libcogudasql.sl is a valid
path for the file
libcogudasql.sl
It appears that there is an extra '/' in the path between "bin" and the
shared library "libcogudasql.sl".
Peter Bateman wrote:
> 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!
>
--
Richard Sheehan
IT Programmer Analyst
208-282-4430
Office of Institutional Research
Idaho State University
Pocatello, ID 83209-8368
More information about the powerh-l
mailing list