Interested to Buy Any Domain ? << Click Here >> for more details...
What are the various locks available?
- 5 Answers
- 12193 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lakshmisudha
locks are 2 types
1.explicet locks
cs,rr,ur,rs
2.implicet locks
shared,exclusive,update
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nag(igate)
They are the 3 types of locks
1.Mode:share,exclusive,update intent
2.Size:tablespace,table,page,row
3.Duration: Acquire,release
| Is This Answer Correct ? | 1 Yes | 1 No |
what is difference between Static call and Dynamic call? How does it function?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
How do we specify index to include or not during bind process.
what are extents?
Is there any advantage to denormalizing DB2 tables?
What is a storage group (stogroup)?
What is buffrpool? Where we use it ?
What does it mean if the null indicator has -1, 0, -2?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
Name some fields from SQLCA.
Can any one tell me about Restart logic in DB2.
COBOL 
