In a Parellel job
to 4 different streams of update, insert and delete records in a table at the same time. IS IT leads dead lock
Contstaints
Source DB2---------Transformer Conditon1------- DB2 ( TABLE A INSET)
--------Conditon2--------------- DB2 ( TABLE A UPDAT)
--------Conditon3--------------- DB2 ( TABLE A UPDAT)
--------Conditon4---------------- DB2 ( TABLE A DELET)
Targed is DB2 partion,
Please anybody let me know whether this job may leads deadlock on the table A ,
DB2 error
Aborting because of following error: [IBM][CLI Driver][DB2/AIX64] SQL1476N The current transaction was rolled back because of error "-911". SQLSTATE=40506
DB2 STAGE deadlock issue
Moderators: chulett, rschirm, roy
DB2 STAGE deadlock issue
Rhaddur
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: