Archives of the TeradataForum

Message Posted: Fri, 11 Aug 2006 @ 20:04:35 GMT

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

I would like to understand if an AMP allocates an AWT to lock a table if the table is already locked by another query. Let's say that 2 transactions need to acquire table level lock on the same table. The first transaction acquires the lock, and the queries from this transactions hold on to the lock for a while. When the second transaction comes along while the first one is still running, then does the AMP first check the lock table before allocating an AWT to lock the table, or does it allocate the AWT to lock the table anyway? In the latter case, the AWT will be wasted until the first transaction completes and releases the table level lock.

Cheers

Bharat Verma

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