Archives of the TeradataForum
Message Posted: Wed, 23 Apr 2003 @ 17:33:09 GMT
<-- 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;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|