Archives of the TeradataForum

Message Posted: Wed, 23 Apr 2003 @ 17:33:09 GMT

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

<-- Anonymously Posted: Wednesday, April 23, 2003 13:31 -->

If two-transactions are deadlocked, are both of the transactions aborted or is only 1 trans aborted and the other allowed to complete? If 1 is allowed to complete, how is it decided which one?

Any suggestions on how to prevent the deadlocks?

All INSERT/UPDATE/DELETE use views like this:
   REPLACE VIEW CUSTOMERV1
   AS SELECT
         CUST_NUMBER,
         CUST_NAME  ,
         CUST_STATUS
     FROM CUSTOMERT;

All READS use views like this:
   REPLACE VIEW CUSTOMER
   AS LOCK TABLE CUSTOMERT FOR ACCESS
         CUST_NUMBER,
         CUST_NAME  ,
         CUST_STATUS
     FROM CUSTOMERT;

Thanks.

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