View Single Post

   
  #4 (permalink)  
Old 02-26-2008, 03:59 PM
Joachim Banzhaf
 
Posts: n/a
Default Re: Federated Informix - how to djxlink?

Some additions:

I did some digging in the docs about db2dj.ini:
It should have the correct entries for the informix server, since the
informix server was installed at time of instance creation/db2
installation.
But I got the same error messages with the informix server. That was what
made me install the informix client sdk...

By the way, I tested the informix server config with dbaccess to see if
everything is configured correctly on the informix side. What would you
suggest to use to test the configuration of the informix client (I found no
dbacces or anything else I could use for this)

Thanks again,

Joachim Banzhaf

I wrote:

> Aakash Bordia wrote:
>
>> I am trying to find out the answer for your question, please hold on. In
>> the meanwhile, what is in your db2dj.ini file. Is it something like:
>> INFORMIXDIR=/informix
>> INFORMIXSERVER=inf93
>>
>> Thanks
>> Aakash

>
> Hi Aakash,
>
> I did not find a reference that I have to change it, so I did not touch
> db2dj.ini until now. If no tool (e.g. db2cc) touches the file behind the
> scenes, it contains what is in by default, after installation of db2 (or
> creation of the instance). Since at the time of instance creation the
> informix client wasn't installed yet, but a slightly older informix server
> I guess it does not contain valid settings.
> But I do set those variables via ~/.profile for the instance owner and
> root. They contain
>
> INFORMIXDIR=/informix/clientsdk
> INFORMIXSERVER=mysrv
>
> In addition I set INFORMIXSQLHOSTS=/informix/clientsdk/etc/sqlhosts.db2
> and of course PATH=$INFORMIXDIR/bin:$PATH (all exported)
>
> I'm sorry, I can't give you the contents of db2dj.ini because I cannot
> acces the server right now.
>
> Meanwhile: thanks for trying
>
> Joachim Banzhaf


Reply With Quote