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
Is DB Client required for Configuring DSN on ETL Server?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 41
- Joined: Fri Jun 04, 2004 5:52 am
- Location: Bangalore
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.
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.
-
- Premium Member
- Posts: 41
- Joined: Fri Jun 04, 2004 5:52 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.