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!
Can't connect to Informix
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 34
- Joined: Tue May 31, 2005 8:17 pm
- Location: ShangHai,China
Hi,
For starters you say
IHTH,
For starters you say
F as in 64 bit client when you need the H version which is a 32 bit client on a 64 bit machine.INFORMIXDIR=/home/inf930FC5; export INFORMIXDIR
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](http://www.worldcommunitygrid.org/images/logo.gif)
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](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Charter Member
- Posts: 34
- Joined: Tue May 31, 2005 8:17 pm
- Location: ShangHai,China