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