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.
Jobs aborting with error code "-911". SQLSTATE=40
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 37
- Joined: Tue Nov 30, 2010 10:51 am
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
Are you sure you are doing update on Primary key column,to test just run the db2 connector stage in sequential mode.
Are you sure you are doing update on Primary key column,to test just run the db2 connector stage in sequential mode.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: