Jobs aborting with error code "-911". SQLSTATE=40

[informdaya@gmail.com]

detail error message from a db2 connector stage:
IIS-CONN-DB2-000013] DB2 information: 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

see first in target table only primary key was defined,update/insert defined on based on primary key.

now we added some extra uniq index on that table. update/insert on primary key only.

now when ever we run the job table is -911 that is dead lock stage.

please help.

[prasson_ibm]

Hi,
Are you sure you are doing update on Primary key column,to test just run the db2 connector stage in sequential mode.

[ray.wurlod]

Are your data partitioned by the primary key prior to sending to DB2? If not you may be attempting to update the same key from more than one node.