Re: [U2] How to release locks (LIST.READU)

2005-06-15 Thread Bruce Nichol
Goo'day, At 10:44 15/06/05 -0400, you wrote: Hi Martin, I agree. Personally, I always use UNLOCK USER [userno] [option]. The poster stated: >I tried to CLEAR all the locks but was not able to do that. The poster seemed to state that he wished to clear all locks. He might've stated that he

Re: [U2] How to release locks (LIST.READU)

2005-06-15 Thread Brian Grayson
Hi Martin, I agree. Personally, I always use UNLOCK USER [userno] [option]. The poster stated: >I tried to CLEAR all the locks but was not able to do that. The poster seemed to state that he wished to clear all locks. Brian Grayson Martin Phillips wrote: > > Try: > > >UNLOCK ALL > > to remove

Re: [U2] How to release locks (LIST.READU)

2005-06-15 Thread Martin Phillips
> Try: > >UNLOCK ALL > to remove all locks. No! No! No! This command should never have been allowed. As another response said, this clears all locks (record, file, group, etc) for all users. It is highly likely to result in data integrity problems as processes find themselves updating the sa

RE: [U2] How to release locks (LIST.READU)

2005-06-15 Thread Nick Cipollina
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz Sent: Wednesday, June 15, 2005 7:01 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] How to release locks (LIST.READU) I dont believe LIST.LOCKS shows READ locks. Use LIST.READU

Re: [U2] How to release locks (LIST.READU)

2005-06-15 Thread Lembit Pirn
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] How to release locks (LIST.READU)

2005-06-15 Thread Sunny Matharoo
l also release other locks like the semaphore and groups locks as well. Hope this helps R, Sunny -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pankaj Gupta04 Sent: 15 June 2005 10:21 To: u2-users@listserver.u2ug.org Subject: [U2] How to release locks (LI

RE: [U2] How to release locks (LIST.READU)

2005-06-15 Thread Brian Leach
. UNLOCK USER usernumber ALL Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Pankaj Gupta04 > Sent: 15 June 2005 10:21 > To: u2-users@listserver.u2ug.org > Subject: [U2] How to release locks (LIST.READU) > &

Re: [U2] How to release locks (LIST.READU)

2005-06-15 Thread Brian Grayson
Hi Pankaj, Try: >UNLOCK ALL to remove all locks. Try: >HELP UNLOCK to learn about the UNLOCK command. Brian Grayson Pankaj Gupta04 wrote: > Hi All, > I am facing a strange problem with the locks. When I executed LIST.LOCKS > at universe prompt, no locks were shown but when I executed LIST.READ

RE: [U2] How to release locks (LIST.READU)

2005-06-15 Thread Les Hewkin
to problems later on. Les -Original Message- From: Anthony Dzikiewicz [mailto:[EMAIL PROTECTED] Sent: 15 June 2005 12:01 To: u2-users@listserver.u2ug.org Subject: RE: [U2] How to release locks (LIST.READU) I dont believe LIST.LOCKS shows READ locks. Use LIST.READU EVERY to see all

RE: [U2] How to release locks (LIST.READU)

2005-06-15 Thread Anthony Dzikiewicz
EVERY, I always use the admin menu, deadlock administration to take care of it. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pankaj Gupta04 Sent: Wednesday, June 15, 2005 5:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] How to release locks

[U2] How to release locks (LIST.READU)

2005-06-15 Thread Pankaj Gupta04
Hi All, I am facing a strange problem with the locks. When I executed LIST.LOCKS at universe prompt, no locks were shown but when I executed LIST.READU, 7 records were displayed as locked. I tried to CLEAR all the locks but was not able to do that. Can someone tell me how to release the locks whic