Informix Configuration for DS 7.1

harikris · Post by **harikris** » Wed Jul 06, 2005 6:12 am

Hi,

I have my Datastage server installed in a HP unix box say, D0.

I need to access the informix database which is in another HP UX box I0.

So, I have copied all the Informix library files from I0 system to D0 system. When I try to import the table definitions of tables from Informix DB, I get an error as follows.

"DSR.MetaGeta(GET.TABLES)(SQLConnect('proj_test','user1')): BCI Error:
SQLSTATE=S1000,CODE=-1829,[DataStage][SQL Client][ODBC][DataDirect][ODBC Informix driver][Informix]Unable to load locale categories."

The following are the entries in the dsenv file.

#####Start#####

MINFX=/dstage/dsadm/informix
export MINFX

INFORMIXDIR=/informix
export INFORMIXDIR

DBSERVERNAME=test
export DBSERVERNAME

TERM=vt100
export TERM

INFORMIXSERVER=test
export INFORMIXSERVER

LD_LIBRARY_PATH=$MINFX/lib:$MINFX/lib/esql
export LD_LIBRARY_PATH

SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls
:$DSHOME/java/jre/lib/PA_RISC/hotspot:$DSHOME/java/jre/lib/PA_RISC:$MINFX/lib/cl
ient:$MINFX/lib:$MINFX/lib/esql:$MINFX/lib/cli:$MINFX/lib/dmi:$SHLIB_PATH
export SHLIB_PATH

#####End#####

The following are the entries in .odbc.ini file:

[proj_test]
Driver=/dstage/dsadm/Ascential/DataStage/branded_odbc/lib/VMinf19.sl
Description=DataDirect Informix
Database=abcd
LogonID=user1
Password=user1
ServerName=test
HostName=10.237.5.157
Service=online
Protocol=onsoctcp
EnableInsertCursors=0
GetDBListFromInformix=0
CursorBehavior=0
CancelDetectInterval=0
TrimBlankFromIndexName=1
ApplicationUsingThreads=1

Let me know what need to be done on configuration.

Regards,
Hari

roy · Post by **roy** » Wed Jul 06, 2005 7:36 am

Hi,
I don't recall the process mentioned (copying libraries) being a formal supported installation of the Informix client!
So you should first install the Informix client.

Your MINFX seems to be the INFORMIXDIR but the INFORMIXDIR points else where

try this first and post your new situation.

IHTH,

ray.wurlod · Post by **ray.wurlod** » Wed Jul 06, 2005 3:23 pm

DataStage is simply another client application as far as Informix is concerned. Therefore, it requires exactly the same configuration as any other client. In particular the relevant environment variables (including PATH, LD_LIBRARY_PATH as well as the Informix ones) must be set. For DataStage on UNIX this is done in the dsenv file. Access via ODBC also requires a data source name (DSN) to be configured. For DataStage this is done in the .odbc.ini and uvodbc.config files.

harikris · Post by **harikris** » Thu Jul 07, 2005 7:47 am

Hi Guys,
Thanks for the replies, the connection problem got resolved. I created a new entry in .odbc.ini file using "DataDirect Informix Wire Protocol" driver. Now i am able to view all the tables from the database and can import the table definition from DS Manager. But not able to run the jobs, its is giving run-time error, even i am not able to perform 'View Data' neither from the plug-in stage nor using ODBC stage.

But the ODBC connectivity is successful, i tested using the "demoodbc" exe under $DSHOME/Ascential/DataStage/branded_odbc/demo/demoodbc directory.

The following is the error message when i perform "View Data" from ODBC stage

## Start

ZZZ_ACCOUNT_EVENT_ODBC..ODBC_6.Src_Query1_Lnk: DSD.BCIOpenR call to SQLExecDirect failed.
Statement was:SELECT abcd:user1.emp.first_name, abcd:user1.emp.last_name, abcd:user1.emp.emp_id, abcd:user1.emp.hire_date, abcd:user1.emp.salary, abcd:user1.emp.dept, abcd:user1.emp.exempt, abcd:user1.emp.interests FROM abcd:user1.emp
SQLSTATE=S1000, DBMS.CODE=-256
[DataStage][SQL Client][ODBC][DataDirect][ODBC Informix Wire Protocol driver][Informix]Transaction not available.

## End

-------------------------------------------

The following is the run-time error when i execute the job (using Informix CLI stage).

## Start
Warning:
ZZZ_ACCOUNT_EVENT..Mapping_Query1_Tmr: C Stage PlugIn function "Get" required

Error:
ZZZ_ACCOUNT_EVENT..Mapping_Query1_Tmr: |-100|

Warning:
DataStage Job 2 Phantom 17171
/usr/lib/dld.sl: Unresolved symbol: _ecvt_r (code) from /usr/lib/libcl.1
/usr/lib/dld.sl: Unresolved symbol: _localtime_r (code) from /usr/lib/libcl.1
/usr/lib/dld.sl: Unresolved symbol: _ldecvt_r (code) from /usr/lib/libcl.1
/usr/lib/dld.sl: Unresolved symbol: _ctime_r (code) from /usr/lib/libcl.1
Job Aborted after Fatal Error logged.
Attempting to Cleanup after ABORT raised in stage ZZZ_ACCOUNT_EVENT..Mapping_Query1_Tmr
DataStage Phantom Aborting with @ABORT.CODE = 1

## End

Please let me how to go forward

roy · Post by **roy** » Thu Jul 07, 2005 8:14 am

You need to distingwish 2 ifferent situations:
1. using the DataDirect provided ODBC drivers that can connect using the ODBC configuration as mentioned by Ray)
2. using the Informix CLI.

the docs of plugin instalation and install & upgrade guides and the docs under the $DSHOME/../branded_odbc directory cover all the config info you need.

So my guess you configured option numnber 1.

As for the errors they will probably go away if you clear the derivations in your table definition in the ODBC stage.

As for the DB doesn't support tansactions warnings they will stay as long as you use a DB with no logs.

IHTH,

harikris · Post by **harikris** » Fri Jul 08, 2005 4:30 am

Hi Roy,
Could you please let me know how to unset the "DB with no logs" option are where to set/unset these options.

Thanks