dsenv and odbc.ini file 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

dsenv and odbc.ini file 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
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Using the native plugins requires different configuration.
search this forum and the docs that describes configuratiojn requirements for those plugins.

P.S.
As previously mentioned here invoking the native bulk load utilities of each tool might proove to be more eficiant then using the bulk load stages.

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

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