Informix9.3 Configuration for DS 7.5 on hp 11i
Posted: Tue Jul 19, 2005 2:21 am
Hi,all
I have installed datasatge7.5 in hp unix 11i with informix9.3 db on the same mache.
The problem is I can't use informix cli to acess informix db.
The following are the entries in the dsenv file:
*************************************************
#!/bin/sh
set +u
if [ -z "$DSHOME" ] && [ -f "/.dshome" ]
then
DSHOME=`cat /.dshome`
export DSHOME
fi
if [ -z "$DSHOME" ]
then
DSHOME=/home/dsadm/Ascential/DataStage/DSEngine; export DSHOME
fi
if [ -z "$UDTHOME" ]
then
UDTHOME=/home/dsadm/Ascential/DataStage/ud41; export UDTHOME
UDTBIN=/home/dsadm/Ascential/DataStage/ud41/bin; export UDTBIN
fi
if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then
ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
HOME=${HOME:-/}; export HOME
#LANG="<langdef>";export LANG
#LC_ALL="<langdef>";export LC_ALL
#LC_CTYPE="<langdef>";export LC_CTYPE
#LC_COLLATE="<langdef>";export LC_COLLATE
#LC_MONETARY="<langdef>";export LC_MONETARY
#LC_NUMERIC="<langdef>";export LC_NUMERIC
#LC_TIME="<langdef>";export LC_TIME
#LC_MESSAGES="<langdef>"; export LC_MESSAGES
#LD_PRELOAD must be unset on HP-UX 11.00
if [ 1111 -le `uname -r | cut -f2 -d.``uname -r | cut -f3 -d.` ]
then
SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC2.0:$DSHOME/java/jre/lib/PA_RISC2.0/hotspot:/home/oracle/OraHome1/lib32:/home/oracle/OraHome1/lib:$SHLIB_PATH
export SHLIB_PATH
LD_PRELOAD=$DSHOME/java/jre/lib/PA_RISC2.0/hotspot/libjvm.sl
export LD_PRELOAD
else
# SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC:$DSHOME/java/jre/lib/PA_RISC/hotspot:$SHLIB_PATH
SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC2.0:$DSHOME/java/jre/lib/PA_RISC2.0/hotspot:$SHLIB_PATH
export SHLIB_PATH
fi
fi
# /home/dsadm is client path ; /home/informix is informix db path ,INFORMIXDIR and INFORMIXBIN must be db path,other is client path
INFORMIXDIR=/home/informix; export INFORMIXDIR
INFORMIXSERVER=his_server_alias; export INFORMIXSERVER
INFORMIXSQLHOSTS=/home/dsadm/etc/sqlhosts; export INFORMIXSQLHOSTS
INFORMIXBIN=/home/informix/bin; export INFORMIXBIN
INFORMIXC=/home/dsadm/lib; export INFORMIXC
# onconfig should point client onconfig file
ONCONFIG=onconfig.solnew2; export ONCONFIG
SHLIB_PATH=/home/dsadm/lib/esql:/home/dsadm/lib/cli:/home/dsadm/lib:$SHLIB_PATH; export SHLIB_PATH
PATH=$INFORMIXDIR/bin:$PATH; export PATH
LANG=C;export LANG
****************************************
is it right
I sure .odbc.ini and uvodbc.config is set right,who can help me!
thanks a lot!
I have installed datasatge7.5 in hp unix 11i with informix9.3 db on the same mache.
The problem is I can't use informix cli to acess informix db.
The following are the entries in the dsenv file:
*************************************************
#!/bin/sh
set +u
if [ -z "$DSHOME" ] && [ -f "/.dshome" ]
then
DSHOME=`cat /.dshome`
export DSHOME
fi
if [ -z "$DSHOME" ]
then
DSHOME=/home/dsadm/Ascential/DataStage/DSEngine; export DSHOME
fi
if [ -z "$UDTHOME" ]
then
UDTHOME=/home/dsadm/Ascential/DataStage/ud41; export UDTHOME
UDTBIN=/home/dsadm/Ascential/DataStage/ud41/bin; export UDTBIN
fi
if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then
ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
HOME=${HOME:-/}; export HOME
#LANG="<langdef>";export LANG
#LC_ALL="<langdef>";export LC_ALL
#LC_CTYPE="<langdef>";export LC_CTYPE
#LC_COLLATE="<langdef>";export LC_COLLATE
#LC_MONETARY="<langdef>";export LC_MONETARY
#LC_NUMERIC="<langdef>";export LC_NUMERIC
#LC_TIME="<langdef>";export LC_TIME
#LC_MESSAGES="<langdef>"; export LC_MESSAGES
#LD_PRELOAD must be unset on HP-UX 11.00
if [ 1111 -le `uname -r | cut -f2 -d.``uname -r | cut -f3 -d.` ]
then
SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC2.0:$DSHOME/java/jre/lib/PA_RISC2.0/hotspot:/home/oracle/OraHome1/lib32:/home/oracle/OraHome1/lib:$SHLIB_PATH
export SHLIB_PATH
LD_PRELOAD=$DSHOME/java/jre/lib/PA_RISC2.0/hotspot/libjvm.sl
export LD_PRELOAD
else
# SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC:$DSHOME/java/jre/lib/PA_RISC/hotspot:$SHLIB_PATH
SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC2.0:$DSHOME/java/jre/lib/PA_RISC2.0/hotspot:$SHLIB_PATH
export SHLIB_PATH
fi
fi
# /home/dsadm is client path ; /home/informix is informix db path ,INFORMIXDIR and INFORMIXBIN must be db path,other is client path
INFORMIXDIR=/home/informix; export INFORMIXDIR
INFORMIXSERVER=his_server_alias; export INFORMIXSERVER
INFORMIXSQLHOSTS=/home/dsadm/etc/sqlhosts; export INFORMIXSQLHOSTS
INFORMIXBIN=/home/informix/bin; export INFORMIXBIN
INFORMIXC=/home/dsadm/lib; export INFORMIXC
# onconfig should point client onconfig file
ONCONFIG=onconfig.solnew2; export ONCONFIG
SHLIB_PATH=/home/dsadm/lib/esql:/home/dsadm/lib/cli:/home/dsadm/lib:$SHLIB_PATH; export SHLIB_PATH
PATH=$INFORMIXDIR/bin:$PATH; export PATH
LANG=C;export LANG
****************************************
is it right
I sure .odbc.ini and uvodbc.config is set right,who can help me!
thanks a lot!