RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Mike Randall
Think LIST.READU is what you are looking for. LIST.LOCKS only displays the 64 semaphore locks which I don't think are too common anymore. Trick with LIST.READU was equating the file number to the proper data file if you were doing it programmatically. -Original Message- From: [EMAIL

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Kevin King
rg Subject: RE: [U2] Locks, releases and STATU() (oh my) Think LIST.READU is what you are looking for. LIST.LOCKS only displays the 64 semaphore locks which I don't think are too common anymore. Trick with LIST.READU was equating the file number to the proper data file if you were doing it pr

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Larry Hiscock
Try LIST.READU instead. LIST.LOCKS lists the semaphore locks, LIST.READU lists file and record locks. Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Thursday, April 14, 2005 8:33 AM To: u2-use

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Lance Jahnke
On Universe LIST.LOCKS shows task locks (i.e. LOCK 5 in UVBASIC )- I have to use LIST.READU EVERY to get readu locks. Does UniData have a LIST.READU command? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Thursday, April 14, 2005 10:33

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Wally Terhune
other resources include: LIST.QUEUE and related GETQUEUE() UniBasic function - both show users queued up for a lock (those users would not be using the LOCKED clause). LIST.READU (noted) and GETREADU() function. Don't forget the DETAIL keyword on LIST.READU and LIST.QUEUE to show full data - not tr

Re: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Richard Sammartino
Susan, Try LIST.READU. This will list the readu locks. LIST.LOCKS lists the semaphore locks. The result from the STATUS() should tell you who has the record locked. Translating that into an actual usr can be tricky as this may be the process id (?). You should see the results from STATUS()

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Bob Woodward
Hi Susan. You're in UD and I'm coming from a UV system so your mileage may vary. LIST.LOCKS is just a semaphore table, not an actual listing of record locks. The LOCK command is used for setting the entries in that table. Not seeing your code snippet, I offer this in an attempt to present my kno

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Mark Olarte
Susan, I think what you're looking for is LIST.READU and / or LIST.READU DETAIL. HTH Mark > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Susan Joslyn > Sent: Thursday, April 14, 2005 7:33 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] Locks, r

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread John Cassidy
LIST.READU DETAIL >>> [EMAIL PROTECTED] 4/14/05 10:47:31 AM >>> Think LIST.READU is what you are looking for. LIST.LOCKS only displays the 64 semaphore locks which I don't think are too common anymore. Trick with LIST.READU was equating the file number to the proper data file if you were doi

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Alfke, Colin
Like Mike said, you want to use LIST.READU (or LIST.QUEUE) to see the locks. However, UniData, unlike UniVerse does have the file name and not just the number. The Status() after a readu gives you the UID (pid) of the process that has the record locked. You can parse it out of the array returned w

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Alfke, Colin
Ooops, I thing I forgot to mention. On some versions of UniData (5.2.4?) doing a /TCL in SB+ will cause UniData to not output information with LIST.READU. I don't recall if there is also a problem with GETREADU() - plus it's already in an array so you don't have to trim and parse (truncated) data (

Re: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Jeffrey Butera
Attached is a small UD program that nicely formats the output from GETREADU. As most Datatel clients know, if you have a UD table buried down one (or more) directories, the output from LIST.READU is almost useless because it shows the relative pathname (which doesn't fit in 8 characters). The

Re: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Dianne Ackerman
Is that DETAIL keyword for LIST.READU just for Unidata? Doesn't seem to work on Universe. -Dianne Wally Terhune wrote: other resources include: LIST.QUEUE and related GETQUEUE() UniBasic function - both show users queued up for a lock (those users would not be using the LOCKED clause). LIST.READ

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Marilyn Hilb
PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Locks, releases and STATU() (oh my) Attached is a small UD program that nicely formats the output from GETREADU. As most Datatel clients know, if you have a UD table buried down one (or more) directories, the output from LIST.READU is a

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Rod Hills
We are running Avante, on Universe, on HPUX so I developed this small program to grab the LIST.READU output, locate the filenames (it only looks at production files) and display the lines with the filenames. Since the part number is also an important field for us, I display it rather then the inter

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Bob Woodward
server.u2ug.org > Subject: Re: [U2] Locks, releases and STATU() (oh my) > > Is that DETAIL keyword for LIST.READU just for Unidata? Doesn't seem to > work on Universe. > -Dianne > > Wally Terhune wrote: > > >other resources include: > >LIST.QUEUE an

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Kevin King
, releases and STATU() (oh my) Ooops, I thing I forgot to mention. On some versions of UniData (5.2.4?) doing a /TCL in SB+ will cause UniData to not output information with LIST.READU. I don't recall if there is also a problem with GETREADU() - plus it's already in an array so you don't h

Re: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Jeffrey Butera
> Jeff.. Can't do attachments here. It the code reasonable length where you > can just included it in the body of an email? R.PH = GETREADU() P= -1 Y = 25 PRINT @(-1): MAX = COUNT(R.PH,@FM) + (R.PH #'') FOR CNT = 1 TO MAX Y += 1 IF Y > 21 THEN P += 1 IF P > 0 THEN

Re: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Dianne Ackerman
f Of Dianne Ackerman >>Sent: Thursday, April 14, 2005 10:25 AM >>To: u2-users@listserver.u2ug.org >>Subject: Re: [U2] Locks, releases and STATU() (oh my) >> >>Is that DETAIL keyword for LIST.READU just for Unidata? Doesn't seem >> >> >to >

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Alfke, Colin
Yes, it was really bizarre. I pulled out my support call and found I was wrong about the versions - it was broken in 6.0.2 and fixed after (at least on Windows). Here are my testing notes: The only pattern I've found is that if I use SBClient and start a GUI session then use "0" to get the com

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-20 Thread Claus Derlien
If the OS is a redhat linux then LIST.READU looks like this : >LIST.READU DETAIL Active Record Locks: Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 2065 33259650 16 11 RU 26105 LP xx*13442*09:36:55*ME 2065 3325