Is DB Client required for Configuring DSN on ETL Server?

tombastian · Post by **tombastian** » Wed Feb 01, 2006 1:33 am

Hi,
I have configured a DSN on the ETL server for DB2 Database. But unfortunatly it's not working. I would like to know whether I should install DB2 client on ETL server to connect to the database using the DSN on my ETL Server on Unix.

Thanks in Advance,
Tom

kduke · Post by **kduke** » Wed Feb 01, 2006 7:27 am

Yes, you always need the client loaded. The DataStage server becomes a client to the database during loading or retrieving data.

ml · Post by ml » Wed Feb 01, 2006 7:30 am

Hi Tom, yes if you want to create a native connection to DB2 you need to install the Db2 client on your ETL server (or somewhere), then you will need to catalog the connections with the db2 client. (this should be your first step, check the db2 connections from db2 client).
After that you need to add the BD2DIR and DB2INSTANCE variables on your dsenv file. Then you can create/test the DSN.

Reed the manual for more detail.

Regards,

Matias.

tombastian · Post by **tombastian** » Wed Feb 01, 2006 3:42 pm

Thanks Kim and Mathias for your valuable inputs.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 01, 2006 5:53 pm

As far as DB2 is concerned, DataStage job is just another client application. Therefore the DataStage job needs to have access to the client software (DB2 Connect perhaps).

gbusson · Post by **gbusson** » Thu Feb 02, 2006 7:09 am

Yes u have to install the sb2 client and set the .profile of the user who launches the jobs.