No. An update takes an exclusive lock. These persist until commit. Only

I use CS and update a page. Will the lock be released after
I am done with that page?

Question Posted / m4io

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

Please Help Members By Posting Answers For Below Questions

Explain correlated sub-queries.

587

How can deadlocks be resolved?

542

List out the data types available.

702

What is data manager?

607

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

585

What do you mean by cursor?

586

What is ibm db2 database?

536

What are db2 tables?

647

What is the syntax for FETCH in DB2 ?

673

What are the contents of dclgen?

658

What are the 2 sqlcodes that are returned?

641

How can you quickly find out the # of rows updated after an update statement?

632

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

748

What is runstats utility in db2?

569

What is ibm db2 connect?

573