Search found 8 matches

by SohelPR
Sun Nov 28, 2010 11:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Use DB2 Connect for Extracting DB2 / Mainframe Data
Replies: 6
Views: 3562

Any luck??

Even im looking for the same db2connect and i-series server access from datastage ??
by SohelPR
Mon Nov 22, 2010 4:42 am
Forum: General
Topic: Connecting to DB2 on AS400 from DataStage
Replies: 5
Views: 7008

Need urgent help!!

Hi,

I have a copy of db2connect now, can anyone tell me what components or how to install db2connect on linux and then how to establish the connection using db2connect from Datastage to DB2/AS400


Regards
by SohelPR
Wed Nov 10, 2010 12:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DB2/AS400 to Linux
Replies: 1
Views: 1424

DB2/AS400 to Linux

Im trying to establish a connection between IBM Datastage & DB2/AS400 Im able to make the connection if Datastage is hosted on Windows using I-Series Access Client. However if Datastage on Linux it does not work, Someone told me if Datastage on Linux i will require DB2Connect. Is there are worka...
by SohelPR
Wed Nov 10, 2010 12:42 am
Forum: General
Topic: Connecting to DB2 on AS400 from DataStage
Replies: 5
Views: 7008

DB2/AS400

Im trying to establish a connection between IBM Datastage & DB2/AS400 Im able to make the connection if Datastage is hosted in Windows using I-Series Access Client. However if Datastage on Linux it does not work, Someone told me if Datastage on Linux i will require DB2Connect. Is that Correct ??...
by SohelPR
Tue Sep 21, 2010 12:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage connection to DB2 on AS400
Replies: 5
Views: 7135

Re: Datastage connection to DB2 on AS400

Also, Is it mandatory to have DB2 connect ? Is DB2 connect trial download available ?? wat are the benefits to use DB2 connect against odbc??
by SohelPR
Tue Sep 21, 2010 12:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage connection to DB2 on AS400
Replies: 5
Views: 7135

Datastage connection to DB2 on AS400

Try DB2 connect or catalog tcp. Wat i understand is you have mention You need to install the DB2 Connect on the Unix side. Then from the db2 command prompt you issue the following: db2 => catalog tcpip node r2e6 remote r2e6.mkm.com server 6534 db2 => catalog db SKR2 at node r2e6 I dont have DB2 con...
by SohelPR
Mon Sep 20, 2010 1:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage connection to DB2 on AS400
Replies: 5
Views: 7135

Hi lstsaur , I cannot find your post with "catalog node" , please provide me with the link or url. Thank u!! Also, could you please explain wat wl be the advantage of using DB2 connect against odbc for DB2 AS400 and whether it is worth a purchase Also, can i use a trial DB2 connect for my ...
by SohelPR
Sat Sep 18, 2010 1:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage connection to DB2 on AS400
Replies: 5
Views: 7135

Datastage connection to DB2 on AS400

Hi, Im trying to connect DS 7.5.2 to DB2 on AS400, however with no success. DS server is hosted on RHEL 5.0 I have installed ibm i-series access client on my RHEL and able to connect to db2 with cwbrunsql /DSN:DB2AS400 /I:test.sql command frm OS level however does not connect frm DS giving me error ...