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
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
> 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
-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
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
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
.
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)
>
&
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
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
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
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
11 matches
Mail list logo