Archives of the TeradataForum

Message Posted: Thu, 14 Jan 2016 @ 23:05:02 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

In 15.10 with Partition Level Locking, the partitioned table can solve your problem. Then the DELETE of a partition will lock on all AMPs but only the partition being deleted. As long as OGG is not updating anything in that partition, the issue will go away.

Until then the DELETE will do an all-AMP table level lock which will have a probability of deadlocking with multiple single row operations in a transaction (like PACK in TPT Streams). Partitioning the table will make the delete faster but that is not where the deadlock is occurring, it is happening at the beginning of the delete when the lock is being acquired.

Most implementations have a way to pause the OGG feed briefly to allow delete, copy,... or other all-AMP operations to go through.

	<Prev	Next>		<<First	<Prev	Next>	Last>>