DSXchange

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.

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

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.