Hi !
What my possibiliteies to connect to DB2 on AS400 .
Can I use DB2 UDB API ?
DB2 UDB API Connection
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 1
- Joined: Wed Jul 07, 2004 6:58 pm
I am getting the same error but on AIX. It's complaining aobut not being able to load drsdb2.so. Anyone know how to fix this?garthmac wrote:Sorry, I don't think I'll be of much help with your setup because our DataStage installation is on Unix. Have you done a search on the internet to help diagnosing your Win32 error?
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Have you gone through the DB2 installation steps in the DataStage Installation guide? You need to make sure the correct settings have been applied to the dsenv file and the setup and grant scripts have been run.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes, you need DB2 connect installed on the datastage sever. You only need the client installed on the DataStage server. The server or Gateway (that's what the DB2 connect person here calls it) piece resides on a seperate server in our house.
Then you need to change your dsenv file to add the path to where DB2 connect is installed, and of course stop and restart DataStage.
Have a great day,
Then you need to change your dsenv file to add the path to where DB2 connect is installed, and of course stop and restart DataStage.
Have a great day,