Page 1 of 1
DB2 UDB API Connection
Posted: Thu Nov 17, 2005 1:50 am
by snassimr
Hi !
What my possibiliteies to connect to DB2 on AS400 .
Can I use DB2 UDB API ?
Posted: Thu Nov 17, 2005 9:08 am
by garthmac
Yes! I use the DB2 plugin to access DB2 on Unix and AS400.
Posted: Thu Nov 17, 2005 9:17 am
by snassimr
Can you post basic configuration generated wiith tool of designer ?
I get errror Win32 error in Load Library dsdb2.dll
what does it mean ?
Posted: Thu Nov 17, 2005 9:30 am
by garthmac
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?
Posted: Mon Nov 28, 2005 2:51 pm
by grnelson75
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?
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?
Posted: Mon Nov 28, 2005 4:57 pm
by vmcburney
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.
Posted: Wed Nov 30, 2005 12:46 am
by ray.wurlod
I believe you will need to have DB2 Connect installed to be able to use the DB2 UDB API from a UNIX machine to access tables on an AS/400 machine.
Posted: Wed Nov 30, 2005 8:55 am
by DaleK
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,