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
Implementing the db2 fuctionality REOPT(ALWAYS) in Datastage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 17
- Joined: Wed Dec 05, 2007 5:47 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: