read data in tables stored in DB2 on iSeries

[LAS]

Hi
I have a DB2 database on iSeries.
I want to read datas to load them in an Oracle database.
I don't know how to connect to DB2/400.

This morning, I tried to use DB2 UDB API stage but it didn't work. I got the message "ds_loadlibrary: error in dlopen of dsdb2.so - libdb2.so.1: cannot open shared object file: No such file or directory"
Reading several posts, I realized that I need to set LD_LIBRARY_PATH.
But I don't know how to set it.
1) Do I have to install something on DataStage server ?
2) Do I have to install something on iSeries server ?
3) DataStage documentation explains that "The IBM DB2 plug-in has the following functionality : Connects to IBM DB2 on an AS/400 system by using the DRDA protocol (TCP/IP)." What is DRDA ?
4) Another documentation explain that "The IBM DB2 plug-in needs Client Application Enablers if datas are on an AS/400 system". What is CAE ?

Anybody to help me ?

[ArndW]

Your best best is to get a DB2 dba. Then see if you can successfully do a "db2 connect" from your UNIX machine (DataStage server); once that functions you know that, when correctly configured, DataStage will also be able to.

[LAS]

Yes, in a perfect world, I would have a DB2 DBA but ... I don't.
I thought I could find here some people who have succeed in connecting DB2/400 from DataStage.
DataStage server is on Linux. I don't know if it is important.

Regards

[chulett]

Your LD_LIBRARY_PATH is set in the dsenv file in $DSHOME. You need to edit it to include the folder where the ".so" file mentioned lives and then stop/restart DataStage.

[LAS]

Hi

On my Datastage server, I can find the file dsdb2.so into 2 folders :

• - InformationServer/Server/StagingArea/Installed/DSDB2/Server/linux
  - InformationServer/Server/DSComponents/bin

I imagine that theses files have been installed with the DataStage installation.

But I can't find the file libdb2.so
That's why I ask if I have to install something on the DataStage Server or the DB2/400 server.

[chulett]

That could very well be. Perhaps, like Oracle, you need a DB2 'client' installed on the DataStage server? No clue, personally, as I've never DB2'd but that would be my guess.

[LAS]

you need a DB2 'client' installed on the DataStage server

That's what I guess too.
But there are several DB2 client :
- DB2 Connect Personnal Edition
- DB2 Connect Enterprise Edition
- DB2 Connect Application Server Edition
...
I don't know which to choose.

DB2 Connect documentation explains that you can make direct access to DB2/400 or you can use a DB2 gateway. What is the best practice ?

I have more questions than answers. That's why I look for people who would have done such a connection.

[chulett]

And there are many, I'm just not one. Be patient, they will show up. Eventually.