Skip to Content
Former Member
May 27, 2010 at 09:26 AM

Using lock objects



I have a table T and two programs P1 and P2. P1 sets a lock on table T and P2 has a simple MODIFY statement to insert/update data in T (no locking).

I executed P1 till the call to the enqueue function module and then had the program wait in debug mode. In another session, I executed P2. What I saw was that P2 had updated T inspite of the lock issued by P1.

On the other hand, when I tried to issue a lock on T from within P2, it failed (since P1 had already locked the table).

Is this normal behaviour?