DSXchange

Netezza connector stage is used to load Facts table into Dimensional layer. We are using a generic job that has one row generator stage connected to a Netezza Connector stage. Facts loading logic is written in SQL scripts and called within the Netezza stage as passing the script name in parameter. This job mostly runs fine but sometimes kept on running for hours without fetching a single records and after few hours it started fetching records.

In director log, it shows "Timed out " while data is being fetched. In an IBM post I found that Netezza opens a pipe to load the data creating an external table and there is a bug on the Netezza side that process hangs, which is not a DataStage issue.

Any suggestions? Can we use ODBC stage in place of Netezza stage?
Though native DB stage is usually better than ODBC I am wondering what could be an optimal solution here.

Thanks for any help.

By all means try ODBC. If there's a bug in the Netezza stage, then ODBC will be a valid workaround (that is, it works and the NZ stage doesn't).

Thanks Ray..We are also thinking in the same line.