DB2 STAGE deadlock issue

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rhaddur
Participant
Posts: 52
Joined: Mon Mar 13, 2006 7:33 am
Location: mumbai

DB2 STAGE deadlock issue

Post by rhaddur »

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
Rhaddur
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Find out what error code -911 is in DB2.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply