.odbc.ini and dsenv setup

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ewartpm
Participant
Posts: 97
Joined: Wed Jun 25, 2003 2:15 am
Location: South Africa
Contact:
Contact ewartpm

.odbc.ini and dsenv setup

Post by ewartpm »

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. :)
Top
elavenil
Premium Member
Premium Member
Posts: 467
Joined: Thu Jan 31, 2002 10:20 pm
Location: Singapore

Post by elavenil »

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
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”