Nicholas ( any newbies listening in),
Just to make sure all bases are covered:
1. LIST.READU's EVERY keyword.
Besides showing group locks, it will also, at the very end, show who is
waiting on a lock.
If there are 2 lines where waiter lock-holder are reversed on the 2nd
line, you have a
Thanks Guys
I think I will see if I come up something along the lines with the suggestion
given by Wjhonson of scouring the lock table, and updating a lock table history
file. The issue here is to try and monitor for deadlocks.
Nedbank Limited Reg No 1951/09/06. The
I don't know about Universe but UniAdmin displays the time the lock was
set in UD.
On 23/03/2012 06:06, Namacha, N. (Nicholas) wrote:
Is it possible to know for how long a record has been locked in universe?
Kind Regards
Nicholas Namacha
Nedbank Limited Reg No
Subject: Re: [U2] Record lock
I don't know about Universe but UniAdmin displays the time the lock was
et in UD.
On 23/03/2012 06:06, Namacha, N. (Nicholas) wrote:
Is it possible to know for how long a record has been locked in universe?
Kind Regards
Nicholas Namacha
...
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, March 23, 2012 12:23 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Record lock
There is no way of which I know, in Universe
: [U2] Record lock
Problem is if a lock was set multiple times within that 5 minute interval, it
ould look like
t had been setup for 5 minuteswhen in reality, it could have only been
ocked for a couple seconds
his time.
I guess you could always make that five minutes, down to like 10 seconds
Not paying much attention to this thread so perhaps I missed
something, but...
That's not a problem, every application has code that does rapid
lock/write/release operations on the same record. George's scenario
was common and perfectly reasonable.
T
(And dude, you really need to do something
Your answer is not related to the main thrust of this thread.
-Original Message-
From: Tony Gravagno 3xk547...@sneakemail.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Fri, Mar 23, 2012 11:11 am
Subject: Re: [U2] Record lock
Not paying much attention to this thread so perhaps
.
The OP needs a process that handles the 98 percent, not the 2 percent.
-Original Message-
From: Wjhonson wjhon...@aol.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Fri, Mar 23, 2012 11:18 am
Subject: Re: [U2] Record lock
our answer is not related to the main thrust
I whole-heartedly disagree...
1) I have numerous processes that lock/update/release the same record
repeatedly running 24x7 - on the sale process id.
2) I don't want code that works 98% of the time - that's unacceptable. I don't
want calls in the middle of the night because it appears
] Record lock
I whole-heartedly disagree...
) I have numerous processes that lock/update/release the same record repeatedly
unning 24x7 - on the sale process id.
) I don't want code that works 98% of the time - that's unacceptable. I don't
ant calls in the middle of the night because it appears
] Record lock
I whole-heartedly disagree...
1) I have numerous processes that lock/update/release the same record
repeatedly running 24x7 - on the sale process id.
2) I don't want code that works 98% of the time - that's unacceptable.
I don't want calls in the middle of the night because it appears
*sigh*
*putting the pop-corn back up*
On 3/23/2012 3:00 PM, Woodward, Bob wrote:
Come on, people! Let's not get into another pissing contest of who
programs the right way and who doesn't. As stated, the original
question was if there is a way to tell how long a lock has been in
place.
, Mar 23, 2012 12:01 pm
Subject: Re: [U2] Record lock
Come on, people! Let's not get into another pissing contest of who
rograms the right way and who doesn't. As stated, the original
uestion was if there is a way to tell how long a lock has been in
lace. Nothing else was given so the assumption
I am retrofitting an application which today looks something like this...
BEGIN TRANSACTION
READU REC FROM F.FILE, ITEM.ID THEN
REC = DATE()
WRITE REC ON F.FILE, ITEM.ID THEN
COMMIT
END ELSE
RELEASE
END
END ELSE
15 matches
Mail list logo