PH and DB2 on HPUX Problems

Wed Mar 29 18:37:10 CST 2006

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060329/25a7f09c/attachment-0001.html