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

What is the cobol picture clause of the db2 data types date, time, timestamp?

1040

How does cobol compile db2 program?

1034

What is difference between isnull and coalesce?

1037

What is table space in db2?

1002

What are the rules for db2 programming?

1071

What does db2 mean?

990

Describe major components of db2?

1082

What is access path in db2?

965

How do you find the maximum value in a column in db2?

1089

Are view updateable?

1020

What is the difference between db2 and oracle?

1103

Mention data types used in db2 ?

1140

What is the difference between drop table and delete table?

1179

What is difference between alias and synonym in db2?

1118

What kind of database is db2?

1021