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/