DataStage with DB2

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
pravin1581
Premium Member
Premium Member
Posts: 497
Joined: Sun Dec 17, 2006 11:52 pm
Location: Kolkata
Contact:

DataStage with DB2

Post by pravin1581 »

Hi All,

How does DataStage interact with DB2 ?

Thanks.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dspxguy
Participant
Posts: 156
Joined: Thu May 24, 2007 4:09 pm
Location: Simi Valley, CA

Post by dspxguy »

here is a link regarding DB2 and DataStage.

http://www-128.ibm.com/developerworks/d ... #dseestep1
Post Reply