Re: [U2] Record lock

2012-03-27 Thread Charles Stevenson
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

Re: [U2] Record lock

2012-03-26 Thread Namacha, N. (Nicholas)
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

Re: [U2] Record lock

2012-03-23 Thread Mecki Foerthmann
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

Re: [U2] Record lock

2012-03-23 Thread Wjhonson
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

Re: [U2] Record lock

2012-03-23 Thread George Gallen
... 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

Re: [U2] Record lock

2012-03-23 Thread Wjhonson
: [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

Re: [U2] Record lock

2012-03-23 Thread Tony Gravagno
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

Re: [U2] Record lock

2012-03-23 Thread Wjhonson
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

Re: [U2] Record lock

2012-03-23 Thread Wjhonson
. 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

Re: [U2] Record lock

2012-03-23 Thread Robert Porter
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

Re: [U2] Record lock

2012-03-23 Thread Wjhonson
] 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

Re: [U2] Record lock

2012-03-23 Thread Woodward, Bob
] 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

Re: [U2] Record lock [irrelevant commentary]

2012-03-23 Thread Glen Batchelor
*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.

Re: [U2] Record lock

2012-03-23 Thread Wjhonson
, 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

[U2] Record Lock Outside of Transaction

2006-05-20 Thread Perry Taylor
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