 |
 |
Archives of the TeradataForum
Message Posted: Fri, 12 Nov 2010 @ 17:48:11 GMT
| Subj: | | Re: ABORTed due to deadlock issue |
| |
| From: | | Faible Mou |
Shindhe, Naveen wrote:
| | We do have ETL jobs running parallel, if at a time 5 to 6 jobs run at a time, which INSERT into the same table at a time we do get the
deadlock issue. | |
Apparently this is the cause of the dead lock. I.e., the time lag between the data is prepared and inserted caused the dead lock.
A very basic question, have you ever considered upgrading from the default TD lock to avoid the dead lock? Eg,
LOCKING ROW FOR WRITE INSERT INTO ...
Or, even
LOCKING TABLE FOR WRITE INSERT INTO ...
if the above fails as well?
| |
