Datastage Update
Posted: Thu Jan 09, 2014 1:53 pm
Hi Gurus,
I have encountered issues while doing an update on one of my DB2 tables. The problem is job gets aborted if the execution mode is set to "Parallel", while doing an update. But when the execution mode is set to "Sequential" update is happening fine.
Below is the error I am getting:
"DB2 reported: SQLSTATE = 40506: Native Error Code = -1,476: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL1476N The current transaction was rolled back because of error "-911". SQLSTATE=40506 ". According to my understanding -911 stands for dead lock.
In fact this is not a problem that I encountered on one particular table, but a couple of tables. Update query is the normal update query
Ex : Update tablename set PROCESSED = ORCHESTRATE.PROCESSED
where ID = ORCHESTRATE.ID ;
Can anyone help me with this?
Thanks,
I have encountered issues while doing an update on one of my DB2 tables. The problem is job gets aborted if the execution mode is set to "Parallel", while doing an update. But when the execution mode is set to "Sequential" update is happening fine.
Below is the error I am getting:
"DB2 reported: SQLSTATE = 40506: Native Error Code = -1,476: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL1476N The current transaction was rolled back because of error "-911". SQLSTATE=40506 ". According to my understanding -911 stands for dead lock.
In fact this is not a problem that I encountered on one particular table, but a couple of tables. Update query is the normal update query
Ex : Update tablename set PROCESSED = ORCHESTRATE.PROCESSED
where ID = ORCHESTRATE.ID ;
Can anyone help me with this?
Thanks,