Re: Q:-How to show locked tables ?

cherylk@spamis.jcdc.doleta.gov wrote: > onstat -ust --- will show you user's locks and tables. You will need to> tie all of this via the address and user fields. Get Joe's book! DBA > Survial Guide. Lot if not most still applies for 7 engine. Good advice for OnLine users but... > On 14 Dec 1995, Johan Andersson wrote: > > } Help needed > } The easiest way to check which tables that are locked? > } Informix SE-7.1 ...Johan is using SE. That uses an O/S file locking system and will be specific to the platform involved. You don't say what machine or O/S you are using so I couldn't speculate far. You may be lucky enough to find the vendor has given you a way to access the kernel lock structures (try crash for instance) or you may have to write something yourself to read the kernel memory and dump outthe info. For a very basic guess try fuser to see who has the file open - often a good indication of who also could have a lock on it. Good luck! Cosmo