Page 1 of 1
Is DB Client required for Configuring DSN on ETL Server?
Posted: Wed Feb 01, 2006 1:33 am
by tombastian
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
Posted: Wed Feb 01, 2006 7:27 am
by kduke
Yes, you always need the client loaded. The DataStage server becomes a client to the database during loading or retrieving data.
Posted: Wed Feb 01, 2006 7:30 am
by ml
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.
Posted: Wed Feb 01, 2006 3:42 pm
by tombastian
Thanks Kim and Mathias for your valuable inputs.
Posted: Wed Feb 01, 2006 5:53 pm
by ray.wurlod
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).
Posted: Thu Feb 02, 2006 7:09 am
by gbusson
Yes u have to install the sb2 client and set the .profile of the user who launches the jobs.