Lock termination with RR isolation Level

Manojtyagi1979 · New User Joined: 25 Jan 2010 Posts: 11 Location: Noida

Hi all,

As we know , RR isolation level Locks are terminated after the COMMIT is performed.

Suppose, my program is reading some data from from Db2 table twice, once for creating a Detailed report and again for creating some summary report. Program Does not have ANy COMMIT statement, as it is only reading from the Db2 table.

So when the lock will be terminated - At end of program or at some other point ?

Please reply.

Thanks
manoj

GuyC · Posted: Mon Dec 13, 2010 10:16 pm

if bound with RR : at the end of the program.