Dear All,
I want to connect to my DB2 present on AS/400 and Mainframe.
Can you please tell me how to configure my DataStage parallel edition (7.5) lying on AIX Unix for this?
I know that one has to use DB2 API stage for connecting to DB2 on AS400 or Mainframe.
But before even proceeding for that we have to create a ODBC or some other thing, so that DataStage can connect to that server. Please guide me for setting my the DataStage server or UNIX and further.
Please Help Me.
Configuring DS for connecting to DB2 AS/400 and Mainframe
Moderators: chulett, rschirm, roy
Configuring DS for connecting to DB2 AS/400 and Mainframe
Pratim Chaudhuri
Senior Project Leader - BI Specialist (DataStage/J2EE)
Senior Project Leader - BI Specialist (DataStage/J2EE)
Re: Configuring DS for connecting to DB2 AS/400 and Mainfram
Pratim,
To etablish a communication between UNIX and As/400, the middleware DB2 connect will be installed on Datastage UNIX server before.
After that, DB2 connect will be parameterized to declare As/400 or mainframe server and to be see by datastage unix server.
Do not use ODBC connection, it will not be efficient.
I don't know unix administration command for DB2 connect administration.
If you need, I can ask that to our aS/400 RDBMS administrator.
With regards
stephane.
To etablish a communication between UNIX and As/400, the middleware DB2 connect will be installed on Datastage UNIX server before.
After that, DB2 connect will be parameterized to declare As/400 or mainframe server and to be see by datastage unix server.
Do not use ODBC connection, it will not be efficient.
I don't know unix administration command for DB2 connect administration.
If you need, I can ask that to our aS/400 RDBMS administrator.
With regards
stephane.
pratimdc wrote:Dear All,
I want to connect to my DB2 present on AS/400 and Mainframe.
Can you please tell me how to configure my DataStage parallel edition (7.5) lying on AIX Unix for this?
I know that one has to use DB2 API stage for connecting to DB2 on AS400 or Mainframe.
But before even proceeding for that we have to create a ODBC or some other thing, so that DataStage can connect to that server. Please guide me for setting my the DataStage server or UNIX and further.
Please Help Me.
Stephane LADINI
IT manager BI project
IT manager BI project
Re: Configuring DS for connecting to DB2 AS/400 and Mainfram
Hello,
I will probably go for the DB2 connect as well but I would also like to consider the ODBC option...
Can anyone give me more inputs on why the ODBC "Will not be efficient" and in which situations I should go for it?
We are also using the 8.0 now.. Is there any sensible changes compared to the 7.5 regarding the DB2 connection?
Any inputs are welcome!
Thanks in advance,
Remi
I am also planning to establish a connection between my UNIX DS Server and an AS/400... Which is a pretty new thing for us.LADINI wrote:Pratim,
Do not use ODBC connection, it will not be efficient.
I will probably go for the DB2 connect as well but I would also like to consider the ODBC option...
Can anyone give me more inputs on why the ODBC "Will not be efficient" and in which situations I should go for it?
We are also using the 8.0 now.. Is there any sensible changes compared to the 7.5 regarding the DB2 connection?
Any inputs are welcome!
Thanks in advance,
Remi