I use CS and update a page. Will the lock be released after
I am done with that page?
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 a plan and how do you refer the plan in the program?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
what is Static and dynamic linking
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
What is an instance in db2?
What is a result table?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What is DCLGEN ?
What is difference between rollback and commit?
What is a predicate?
What do you mean by NOT NULL? When will you use it?
What is page size in db2?