Can't connect to Informix

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
daniel0623
Charter Member
Charter Member
Posts: 34
Joined: Tue May 31, 2005 8:17 pm
Location: ShangHai,China

Can't connect to Informix

Post by daniel0623 »

Hi all,
It's my first time to connect Informix Server.OS:AIX 5.2 Informix:9.3 Datastage EE:7.5
I added environment variables in $DSHOME/dsenv as follows:


INFORMIXDIR=/home/inf930FC5; export INFORMIXDIR

PATH=$PATH:$INFORMIXDIR/bin; export PATH

INFORMIXSERVER=udi_etl_kf_tcp; export INFORMIXSERVER

ONCONFIG=onconfig.udi_etl_kf; export ONCONFIG

INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts; export INFORMIXSQLHOSTS

LIBPATH=$APT_ORCHHOME/lib:$INFORMIXDIR/lib:`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic:$DSHOME/java/jre/bin:$INFO
RMIXDIR/lib:$INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/esql:$LIBPATH; export LIBPATH

LANG=C; export LANG

INFORMIXC=CC; export INFORMIXC

THREADLIB=POSIX; export THREADLIB

But when using Informix Enterprise Stage, I can't view data.The log as follows:

##W TCOS 000049 14:35:59(006) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TOSH 000205 14:35:59(007) <main_program> PATH search failure:
>##E TOSH 000000 14:35:59(008) <main_program> Error loading "orchinformix": Could not load "orchinformix": Could not load module /home/udi_etl/dsadm/Ascential/DataStage/PXEngine/lib/liborchinformixaix3.so.
> Dependent module /home/inf930FC5/lib/libnetstub.so could not be loaded.
> The module has an invalid magic number.
>System error: Exec format error
>##E TOSH 000000 14:35:59(009) <main_program> Could not locate operator definition, wrapper, or Unix command for "hplread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
>##E TCOS 000029 14:35:59(010) <main_program> Creation of step finished with status = FAILED

Do I need modify any other files?Who can mail a document about connecting Informix to me?
Email:hyl0623@hotmail.com Please help me!


Thank you!
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
For starters you say
INFORMIXDIR=/home/inf930FC5; export INFORMIXDIR
F as in 64 bit client when you need the H version which is a 32 bit client on a 64 bit machine.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
daniel0623
Charter Member
Charter Member
Posts: 34
Joined: Tue May 31, 2005 8:17 pm
Location: ShangHai,China

Post by daniel0623 »

Hi roy,
Thank you for your help.I have resolved problem.I download a new client 2.9-32bit.And successfully connect to informix.
Post Reply