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
- 9687 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 |
wht happens if we close cursor with cursor with hold option?
Explain various types of locks in db2?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
what is difference between Static call and Dynamic call? How does it function?
How can record locking be achieved in those DB2 versions which do not support it?
What are the 4 environments which can access DB2 ?
Q4. How will you get the count of record without using COUNT verb in query?
Can a Db2 table data be retrived through JCL?
What does a deadlock mean in DB2?
What keyword does an SQL SELECT statement use for a string search?
What is load utility in db2?
How do I add a column to a table in db2?
COBOL 
