PH and DB2 on HPUX Problems
Peter Bateman
pfbcs at hotmail.com
Sun Apr 2 12:33:23 CDT 2006
Hi Richard:
Although the extra / is redundant , the path is still valiad.
Regards,
Peter
>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
>
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.
_________________________________________________________________
Take charge with a pop-up guard built on patented Microsoft® SmartScreen
Technology
http://join.msn.com/?pgmarket=en-ca&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*.
More information about the powerh-l
mailing list