Archives of the TeradataForum
Message Posted: Wed, 10 Jun 2015 @ 08:52:55 GMT
| Subj: || || Re: Write Lock - Partition level |
| From: || || Anomy Anom |
<-- Anonymously Posted: Tuesday, June 09, 2015 21:28 -->
You probably meant to say:
In DEV they were updating a non PI column which was placing table locks (so updates took turns but succeeded) and in PROD the updates were on
PI column which is a RowHash level lock leading to Deadlock (due to the application design holding some locks already and requesting others).