RE: [U2] How to release locks (LIST.READU)
I dont believe LIST.LOCKS shows READ locks. Use LIST.READU EVERY to see all READU locks. Two commands for two different things. I dont know of any commands to release READU locks. The MASTER LOCKS command will release the synchronization locks, but not READU. One thing you could do is to MASTER OFF the user. This is not always the best thing. You could walk over to their terminal and back them out of what they are doing. You could also make use of TANDEM to take control of the terminal and do the same thing (if you dont like walking). If it is a deadlock, shown by LIST.READU 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 (LIST.READU) 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 which are displayed in LIST.READU output? Thanks in advance. Regards, Pankaj Gupta *** CAUTION - Disclaimer ** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 6/8/2005 -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 6/8/2005 --- 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)
Have a look at the UNLOCK command. This allows the system administrator in the UV account to unlock any lock set by a READU. Before you go round unlocking records make sure you know why the locks are there. Has someone just walked away from their screen for a while? Unlocking records can lead 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 READU locks. Two commands for two different things. I dont know of any commands to release READU locks. The MASTER LOCKS command will release the synchronization locks, but not READU. One thing you could do is to MASTER OFF the user. This is not always the best thing. You could walk over to their terminal and back them out of what they are doing. You could also make use of TANDEM to take control of the terminal and do the same thing (if you dont like walking). If it is a deadlock, shown by LIST.READU 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 (LIST.READU) 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 which are displayed in LIST.READU output? Thanks in advance. Regards, Pankaj Gupta *** CAUTION - Disclaimer ** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 6/8/2005 -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 6/8/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://virus.e2e-filter.com/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- 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)
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.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 which are displayed in LIST.READU output? Thanks in advance. Regards, Pankaj Gupta *** CAUTION - Disclaimer ** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- 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/
RE: [U2] How to release locks (LIST.READU)
Hi, The LIST.LOCKS command lists tasks synchronization locks. The LIST.READU command lists record and group locks. To release record and group locks you need the UNLOCK command. This is (normally) only available in the uv account, and has various options for unlocking different sets of locks,e.g. 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 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 which are displayed in LIST.READU output? Thanks in advance. Regards, Pankaj Gupta *** CAUTION - Disclaimer ** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- 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/
RE: [U2] How to release locks (LIST.READU)
Hi, This is two different things LIST.LOCKS shows file locks and can only be released by the session or user that locked that file. To see record locks use LIST.READU EVERY this shows all locks set by a user Active Group Locks, Active Record locks and Active Semaphore locks as well. To release a lock you can use UniAdmin or from the UV account but you will need 'root' permissions to unlock the user, use UNLOCK command to release the locks. Type at TCL if in the UV account 'UNLOCK RECORD record.id ALL' this will release the locks held by that record, but note it will 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 (LIST.READU) 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 which are displayed in LIST.READU output? Thanks in advance. Regards, Pankaj Gupta *** CAUTION - Disclaimer ** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- 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/
Re: [U2] How to release locks (LIST.READU)
--- 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)
You can go to the UV account and do an UNLOCK. UNLOCK Use UNLOCK to clear file, group, and update record locks. You must be a UniVerse Administrator logged in to the UV account to execute UNLOCK. Syntax UNLOCK [NODE node] [USER user.number] [FILE pathname | [DEVICE device.number] [INODE i.node.number]] [GROUP group.address] [RECORD record.ID] {FILELOCK | GROUPLOCK | READULOCK | READLLOCK | ALL} Parameters The following table describes each parameter of the syntax. Parameter Description NODE node Restricts lock removal to the specified node. UNIX. This must be the network node number, which is the last part of the TCP/IP host number specified in the /etc/hosts file. Windows NT. If valid for Windows NT, the path of the hosts file is /Windows/System32/Drivers/etc/hosts where Windows is the Windows NT installation directory. On Windows NT systems, you can also use the LAN Manager node name. USER user.number Restricts lock removal to locks owned by the specified user. You can get the user number from the output of LIST.READU. FILE pathname Restricts lock removal to a file or device specified by the pathname. You cannot specify DEVICE or INODE clauses in an UNLOCK statement that uses the FILE clause. DEVICE device.number Restricts lock removal to a file or a device specified by the device number. UNLOCK Parameters 1-604 UniVerse User Reference /productinfo/alldoc/UNIVERSE10/userref/Ch1 1/8/02 Specify the lock type as one of the following: Description You can specify ID numbers (that is, the node number, device number, or record ID) in either decimal or hexadecimal format. Precede the number with 0x to specify it as hexadecimal. INODE i.node.number Restricts lock removal to a file or a device specified by the i-node number. GROUP group.address Restricts lock removal to the group specified by group.address. The group address appears in hexadecimal format on the LIST.READU report. RECORD record.ID Restricts lock removal to the record specified by the record ID. Lock Type Description FILELOCK Removes only file locks. GROUPLOCK Removes only group locks and update record locks associated with the group. READULOCK Removes only update record locks. READLLOCK Removes only shared record locks. ALL Removes all locks. UNLOCK Lock Types Parameter Description UNLOCK Parameters (Continued) Thanks, 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 EVERY to see all READU locks. Two commands for two different things. I dont know of any commands to release READU locks. The MASTER LOCKS command will release the synchronization locks, but not READU. One thing you could do is to MASTER OFF the user. This is not always the best thing. You could walk over to their terminal and back them out of what they are doing. You could also make use of TANDEM to take control of the terminal and do the same thing (if you dont like walking). If it is a deadlock, shown by LIST.READU 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 (LIST.READU) 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 which are displayed in LIST.READU output? Thanks in advance. Regards, Pankaj Gupta *** CAUTION - Disclaimer ** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- u2-users mailing list u2-users@listserver.u2ug.org
Re: [U2] How to release locks (LIST.READU)
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 same record simultaneously and, far worse, releasing group locks can cause file corruption. Whenever I come across a user who has had a backward link error, my first question is do you use UNLOCK ALL. If they say yes, they are on their own! Always use the opions of UNLOCK to identify the exact lock you want to clear. Even then, you need to think about the application level impact of releasing a lock. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- 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)
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 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 same record simultaneously and, far worse, releasing group locks can cause file corruption. Whenever I come across a user who has had a backward link error, my first question is do you use UNLOCK ALL. If they say yes, they are on their own! Always use the opions of UNLOCK to identify the exact lock you want to clear. Even then, you need to think about the application level impact of releasing a lock. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- 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/
Re: [U2] How to release locks (LIST.READU)
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 wished to clear all locks, but the very nature of his original question showed he appeared to have minimal knowldge of the various locking mechanisms, and therefore IMHO any and all whoa! and lesser cautionary messages, are indeed, more than apt! How many times have we all heard But, he said to do ... just after a catastrophe? -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.5/18 - Release Date: 15/06/05 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.5/18 - Release Date: 15/06/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/