Interested to Buy Any Domain ? << Click Here >> for more details...
I use CS and update a page. Will the lock be released after
I am done with that page?
- 2 Answers
- 9736 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / m4io
No.
An update takes an exclusive lock. These persist until
commit.
Only shared locks will be released when you move away from
the page.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / s
Yes, the CS lock is held until the application locks the
next page.
| Is This Answer Correct ? | 2 Yes | 4 No |
What is the default page size of buffer pools?
Can we delete records from view?
What is db2 purescale?
can we drop column from a table
Where is the access path logic created by the DB2 Optimizer stored?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
wht are the restrictions for union ?
Can I use LOCK TABLE on a view?
What is a bind in db2?
Name the different types of Table spaces.
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
List out the three types of page locks that can be held.
COBOL 
