Implementing the db2 fuctionality REOPT(ALWAYS) in Datastage

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
AccentureTA
Premium Member
Premium Member
Posts: 17
Joined: Wed Dec 05, 2007 5:47 pm

Implementing the db2 fuctionality REOPT(ALWAYS) in Datastage

Post by AccentureTA »

Hi all,

We have been suffering from poor performance of several queries against DB2 UDB invoked by DataStage. We are using DataStage 7.5.1.A and use the ODBC Stage to access DB2 through the Data Direct driver.

We have a DB2 solution to use the REOPT(ALWAYS) funtion for these queries. From a pure DB2 perspective, it is great, and we get the performance we need. However, with the Data Direct driver, it is not clear how we would go about enabling this.

Can you provide DataStage guidance as to how to enable this DB2 functionality through the ODBC Stage?

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

Post by ray.wurlod »

Assuming you mean the ODBC Enterprise stage, could you not execute this command via the Open Command property?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”