Page 1 of 1

Regarding Connecting to iseries data from Datastage

Posted: Fri Sep 16, 2011 1:53 pm
by bgudapati
Hi Experts,


I do have question regarding connecting to iseries data from Datastage V8.5

The client company has purchased DB2 Connect for iseries processor.

I have Infosphere information server installed on Aix 6.1
Do I have to install DB2 connect server as well as client on Aix 6.1 and also what I have to configure on iseries for the connection.

can anyone give ideas or links


Thanks
bgudapati

Posted: Fri Sep 16, 2011 3:48 pm
by lstsaur
You only need to install the DB2 Connect client on your AIX box, then you have to catalog the server and the database in oder to be able to establish a connection to your iSeries box.

Posted: Sun Sep 18, 2011 1:32 am
by ppgoml
the best way to acsess data on iseries is to use ODBC.

Posted: Sun Sep 18, 2011 3:03 pm
by qt_ky
It's been a while since accessing iSeries for me. I recall using a DataDirect ODBC driver called SequeLink ODBC, an add-on product, with the client on DataStage and server on AS/400. I think if you have DB2 Connect then you can use DB2 instead of ODBC.