Thats for the responses Wol and Martin!
Wol - the lock and the write are in the same program so there is no
execute involved.
Martin - I need to look up the archives that previously talked about
the query processor holding a group lock but that is exactly the lock
we are seeing (a group lock). This is a very promising lead and if its
the problem I MAY have to go to where you are and buy you a steak dinner!
thanks guys!
dougc
Martin Phillips wrote:
Hi Doug,
has anybody run across/seen an issue where a process sets a lock via
READU and then when it tries to write back the record cannot
because the record is locked but somehow "lost" the fact that the
process trying to write the record is the process that created the lock?
My money (but not too much!) is on this being a group lock problem.
As discussed recently on this list, the query processor holds a read
group lock on the group it is processing when on the "press return to
continue" prompt. Quite why, I have never worked out.
If a program tries to write to this group, it will hang until the user
running the query moves on to the next page or until the group lock
times out.
Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200 -------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
