ISOLATION LEVEL doubt

dnivara11 · #1 (**permalink**) 10-21-03, 06:26

Hi
I bind a program with ISOLATION LEVEL of CS. Does the lock get released if the page locked for update is updated? Will it be available for the other user to view or update even if the program has not run completely?

Please help.

Thanks, Arvind.

sathyaram_s · #2 (**permalink**) 10-21-03, 06:29

Any chance you have information on the Operating System and the version of db2 you use ?

Cheers
Sathyaram

Quote:

Originally posted by dnivara11
Hi
I bind a program with ISOLATION LEVEL of CS. Does the lock get released if the page locked for update is updated? Will it be available for the other user to view or update even if the program has not run completely?

Please help.

Thanks, Arvind.

Marcus_A · #3 (**permalink**) 10-21-03, 06:35

Since you mentioned page locks, I assume it is DB2 for OS/390.

The update lock should get released at commit time.

(I have edited this message becasue it originaly contained errors.)

Internet Services

Web Development

Digital Marketing

Consumer Tech