DB2 connector stage -911 deadlock error
Posted: Tue Oct 11, 2011 2:42 pm
Hi, thanks for reading.
Getting the following error. Using a DB2 connector stage.
db2IIW_Bus_Key_Xref_OUT,5: DB2 information: SQLSTATE = 40506: Native Error Code = -1476: Msg = [IBM][CLI Driver][DB2/AIX64] SQL1476N The current transaction was rolled back because of error "-911". SQLSTATE=40506
I have searched the forum and found the issue can be resolved by switching the stage to run in sequential mode instead of parallel. However I really don't want to switch the stage from Parallel to Sequential because I want to maximize performance. Can anyone offer another solution. Working with the DBA's but they are not finding anything on their end. I'm using a db2 connector stage. Write mode is insert then update. Transaction record count is 2000. Auto commit is off.
Getting the following error. Using a DB2 connector stage.
db2IIW_Bus_Key_Xref_OUT,5: DB2 information: SQLSTATE = 40506: Native Error Code = -1476: Msg = [IBM][CLI Driver][DB2/AIX64] SQL1476N The current transaction was rolled back because of error "-911". SQLSTATE=40506
I have searched the forum and found the issue can be resolved by switching the stage to run in sequential mode instead of parallel. However I really don't want to switch the stage from Parallel to Sequential because I want to maximize performance. Can anyone offer another solution. Working with the DBA's but they are not finding anything on their end. I'm using a db2 connector stage. Write mode is insert then update. Transaction record count is 2000. Auto commit is off.