I use CS and update a page. Will the lock be released after
I am done with that page?
Answer Posted / 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 |
Post New Answer View All Answers
Explain correlated sub-queries.
How can deadlocks be resolved?
List out the data types available.
What is data manager?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What do you mean by cursor?
What is ibm db2 database?
What are db2 tables?
What is the syntax for FETCH in DB2 ?
What are the contents of dclgen?
What are the 2 sqlcodes that are returned?
How can you quickly find out the # of rows updated after an update statement?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is runstats utility in db2?
What is ibm db2 connect?