Job error: ds_ipcgetnext waiting for mutex

jjsyht · Post by **jjsyht** » Mon Mar 02, 2009 10:03 pm

I'm getting the following error when running a job (STP stage) that is calling a procedure. The procedure has several selects that inputs into variables and a final select that inserts into a table.

It fails after 2 minutes in the job. Usually after 2 minutes, the final select (insert) has started.

Code: Select all

Abnormal termination of stage LOD_INCOME_EXPENSE_INTER_FEE_L..DTM_CUPP_PRC_ICEX_INTER_FEE detected

LOD_INCOME_EXPENSE_INTER_FEE_L..DTM_CUPP_PRC_ICEX_INTER_FEE.out: ds_ipcgetnext - timeout waiting for mutex

Attempting to Cleanup after ABORT raised in stage LOD_INCOME_EXPENSE_INTER_FEE_L..Trans

Database is DB2
Calling the procedure from WinSQL gives no errors. And no other related jobs was running at the same time. The job just basically calls the procedure and write the return code to a file.

The job has no hash files & no IPC stages and 'Enable Row Buffer' is unchecked.
Any ideas?