DataStage with DB2
Posted: Fri Sep 28, 2007 1:41 am
Hi All,
How does DataStage interact with DB2 ?
Thanks.
How does DataStage interact with DB2 ?
Thanks.
Exceedingly well, since they're both IBM products and the DB2 partitioning algorithm can therefore be made available within the DB2/UDB Enterprise stage.
The only "glitch", in version 7.x, is that you can not use the Enterprise stage if DB2 is not on the same platform as DataStage. In this case you need to use the DB2 API stage communicating via DB2 Connect client software.
You can also interact with DB2 via ODBC if you really must.