Re: Table locked by user, but who?

charleen@presto.ig.com (Charleen Stoner) writes: > We're running INFORMIX-SQL Version 2.10.03. After six weeks of consulting > with users on changes to one (1) table and one (1) screen form, I was > finally ready to make the changes to the table with 7 pages of SQL commands. > > Only I got a "table locked by user" message. Consulted the Informix-SQL > manuals. Consulted the Informix-4GL manuals (wrong product, but they're > better written and often offer useful clues). Nothing. Attempting to > unlock it brings the information that I am not the locker. > > Is there a way to find out who has a table locked? > > Charleen Having encountered this problem a very long time ago, it seems to me I poked thru the sys files (tables with tab_id > 99) to find out the user id's (from /etc/passwd). Try using the id's you find. It may be that it was a user who has since been removed from the system. Try doing a hexdump on sysusers.dat. You may be able to pg it as well. Don't quite remember anymore, as it's been a while. I think there was also a systabauth table as well. Good luck! | Marc Siegel N3MCR | | Emtronix Data Services, Inc. | | Baltimore, Maryland | | {uunet}!wb3ffv!mas!smarc | | smarc@mas.wb3ffv.AMPR.ORG |