On UV I don't seem to have a LIST.QUEUE command; is it possible that this is a UD feature? I wish there were a UV equivalent, like the D3 LIST-LOCKQ command. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006
On Mon, Feb 23, 2009 at 10:11 AM, Nick Gettino <nick.gett...@enroute911.com>wrote: > Use this verb. > LIST.QUEUE [USERNAME user_name | FILENAME filename | > user_number][DETAIL] > Synonym > LIST-QUEUE > > Description > > The ECL LIST.QUEUE command lists processes that currently waiting > for locks. If a process is waiting for a lock, LIST.QUEUE displays > information about the holder of the lock and processes waiting for > the lock. Locks are set by each udt process through the general lock > manager (GLM) module. > UniBasic commands that check for locks, such as READU and READVU, > cause processes to wait for locks to be released before proceeding. > > Nicholas M Gettino | Director of Development | EnRoute Emergency > Systems, an Infor company | office: 813-207-6998 | fax: 678-393-5389 > nick.gett...@infor.com | www.enroute911.com > -----Original Message----- > From: owner-u2-us...@listserver.u2ug.org > [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jacques G. > Sent: Monday, February 23, 2009 11:24 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UV] Deadlock report ? > > I'm already familiar with the -r option of analyse.shm but it is the > equivalent to: LIST.READU EVERY. I only need this part: > > > Active Read Waiters: Owner Waiter > Device.... Inode.... Userno Userno > 1074003970 41292 671 547 > > I an extract this part from the output of analyse.shm but this report > takes a lot of time producing all of the grouplock and record lock > information. Ideally, i'd need a switch to give me only this part + the > key or group where the problem is occuring. > > > > ----- Original Message ---- > From: David Scoggins <dscogg...@gmail.com> > To: u2-users@listserver.u2ug.org > Sent: Monday, February 23, 2009 9:59:29 AM > Subject: Re: [U2] [UV] Deadlock report ? > > Take a look at analyze.shm (see the 'Administering Universe" manual), > IIRC the -r option in particular should give you just the record > locks. > > On Sun, Feb 22, 2009 at 2:00 PM, Jacques G. <jacque...@yahoo.com> wrote: > > Hello, > > > > I was wondering if there is a deadlock report feature in Universe. > We have web services that need to call legacy subroutines and these > sometimes make use of READU clauses without the locked statements. > > > > Since our pooled webservices have to run between 14 and 92 > transactions a minute these READU statements can cause timeouts for > transactions waiting in line. > > > > The transactions causing the blockage do not necessarely remain > blocked for very long. It can be anywhere from 30 seconds to half an > hour however between the time the problem occurs and is detected and > reported by our clients. It has usually passed before we can do a > LIST.READU EVERY to detect which file is the one being blocked. > > > > I am only interested in the list of deadlocks that show "blocked" > users at the end of the LIST.READU command (the list of users running a > READU and waiting to obtain the lock) and not the huge GROUP locks > report which preceeds it and which takes time to produce. There does > not appear to be a switch to LIST.READU to only show the deadlock > section. > > > > I've thought of running periodic LIST.READU EVERY every 2 minutes but > with over 800 users online + the numerous webservices transactions, it > just takes to long (over 4 minutes) to produce the list. > > > > So I've wondered if there isn't a reporting feature I could turn on so > that I could see the deadlocks that occured during the day. This way, I > could cross-reference the timeout problems with the deadlock list and > see which file being accessed is behind the blockage. > > > > The info I'd need is: > > Time, blocked User, File, Key, Id of blocking user > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
