Parallel job hangs on Database Update
Posted: Mon Mar 14, 2011 3:25 am
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.POOT as varchar(512))) = '' THEN MBPOOT ELSE ORCHESTRATE.POOT END
WHERE MBCONO = 200
AND MBITNO = ORCHESTRATE.ITNO
This SQL works if we execute it in an SQL tool (such as WinSQL), with ORCHESTRATE.... replaced by values.
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.POOT as varchar(512))) = '' THEN MBPOOT ELSE ORCHESTRATE.POOT END
WHERE MBCONO = 200
AND MBITNO = ORCHESTRATE.ITNO
This SQL works if we execute it in an SQL tool (such as WinSQL), with ORCHESTRATE.... replaced by values.