DSXchange

I need to connect to the following databases:
Informix Dynamic Server 9.4
DB2 UDB 8.1.6

We are using the Data Direct Wire Protocol 4.2 drivers.

We want to use the bulk loader stages for these databases (DB2 Load and Informix Loader stages).

Strange thing is we can connect using the ODBC stage, but cannot connect sing the Informix CLI stage or the DB2 stage. (ODBC will not do bulk loading).

Can anyone point me in the right direction. If anyone would be prepared to share their dsenv and odbc.ini setup it would be greatly appreciated.

In order to configure DB2 plug-in, you need to do the following as of my best knowledge.

1. Install DB2 client in DS server.

2. Configure DB2 in DSENV file. DB2 libraries and binary folder (Look at the PDFs and this configuration is clearly mentioned in that) in the library path. The Shared library path differs from platform to platform.

3. Restart DS.

4. Run . ./dsenv from DSHOME directory to ensure the variables are set properly.

I have no idea in configuring informix and hope that should be straightforward.

HTWH.

Regards
Saravanan