Search found 2 matches
- Mon Mar 14, 2011 3:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job hangs on Database Update
- Replies: 1
- Views: 1030
Solved by disabling Diagnostics in ODBC Datasource
It turns out that the job finishes nicely if "Enable Job Trace" is unticked in the Diagnostic tab of the ODBC Configuration of the used ODBC Datasource.
- Mon Mar 14, 2011 3:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job hangs on Database Update
- Replies: 1
- Views: 1030
Parallel job hangs on Database Update
We have a parallel job which does an update in a DB2 database table, on an iSeries. This is done in an ODBC Enterprise Stage. The problem is that the job keeps running, and is only stopped by aborting the job manually. The SQL is as follows: UPDATE MITBAL SET MBPOOT = CASE WHEN Trim(CAST(ORCHESTRATE...