write lock is compatiable with which type of lock?
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
EXCLUSIVE LOCK - NONE
WRITE LOCK - ACCESS
READ - READ, ACCESS
ACCESS - READ,WRITE,ACCESS
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / yuvaevergreen
Adding to above, teradata locks objects on first come first
serve basis. write locks are generally used for dmls like
insert,update,delete. select statement uses access lock.
exclusive locks are used for ddls like create,alter. Pseudo
lock is a concept by which teradata assigns one amp to take
care of locking the rows of the table in other amps. This
amp makes sure that other amps lock the table.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / tdguy
exclusive lock - not compatible with other locks.
write lock - compatible with access lock
read - compatible with read,access
access - compatible with write,read,access
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / etlguy
exclusive lock - none.
write lock - access lock
read - read,access
access - write,read,access
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shaik mahamad rafi
write lock applying on table level ,we don't have read and exclusive .... both are in queue .
Is This Answer Correct ? | 0 Yes | 0 No |
Is multi insert ansi standard?
How to identify ppi columns?
When tpump is used instead of multiload?
Can we collect statistics on table level?
What are the joins in teradata?
How to run the Teradata jobs in unix environment ???
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
How is the teradata different from oracle?
How a Referential integrity is handled in Teradata?
What is spool space? Why do you get spool space errors?
If a Node is busy what are the steps you can take to avoid ?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?