PH and DB2 on HPUX Problems

[Jim Ranger]

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
> >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 advantage of powerful junk e-mail filters built on patented
> Microsoft(r)
> 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(r) 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060329/c2e3d4ee/attachment.htm