Implementing the db2 fuctionality REOPT(ALWAYS) in Datastage
Posted: Wed Apr 02, 2008 8:34 pm
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
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