Archives of the TeradataForum

Message Posted: Wed, 16 Feb 2005 @ 15:12:05 GMT

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

<-- Anonymously Posted: Wednesday, February 16, 2005 10:01 -->

Hi,

We have noticed some deadlocks on our system when doing deletes from certain tables.

The tables in questions are all unique to the particular jobs which run them (so nothing else, apart from the job running the delete script) would ever access these tables.

Why then, are we getting a deadlock, and with what??

Any any entries made anywhere in DBC when you delete all rows from a table? (The explain doesn't show any).

Thanks.

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