DB2 UDB API Connection

snassimr · Post by **snassimr** » Thu Nov 17, 2005 1:50 am

Hi !

What my possibiliteies to connect to DB2 on AS400 .

Can I use DB2 UDB API ?

garthmac · Post by **garthmac** » Thu Nov 17, 2005 9:08 am

Yes! I use the DB2 plugin to access DB2 on Unix and AS400.

snassimr · Post by **snassimr** » Thu Nov 17, 2005 9:17 am

Can you post basic configuration generated wiith tool of designer ?

I get errror Win32 error in Load Library dsdb2.dll

what does it mean ?

garthmac · Post by **garthmac** » Thu Nov 17, 2005 9:30 am

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?

grnelson75 · Post by **grnelson75** » Mon Nov 28, 2005 2:51 pm

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?

vmcburney · Post by **vmcburney** » Mon Nov 28, 2005 4:57 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 30, 2005 12:46 am

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.

DaleK · Post by **DaleK** » Wed Nov 30, 2005 8:55 am

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,