Re: Help! Locks

Um, I demur to mention it but, um, are you perhaps trying to lift the rug on which you stand? If you, for example, do: dbaccess mydatabase - Database selected. > drop database mydatabase; 359: Cannot drop or rename current database. Error in line 1Near character position 24 > You must: > close database; Database closed. > drop database mydatabase;Database dropped. >^D^D I know it's obvious but hey... You do not stat ANY details, like error number, what front-end tool you are trying to use to drop the database, server type (SE, IDS, XPS, UDO), versions, etc so this only answer we have sufficient information to return. Post the items above along with the database's sysmaster:sysdatabases record printout and onstat -k output and we'll see what else we can come up with. Art S. Kagel bullmkt123@my-deja.com wrote: > > Informix Gurus: > > I am trying to drop a database and I am getting an error because someone > has a lock on a table or a session is just open within this database. > I've tried using onstat -g sql and onstat -u to track down the lock, but > no luck! I also tried selecting from syslocks in the sysmaster database, > once again, no luck! Is there another script out there that can help me > locate this invisible lock :-) > > Thanks in advance! > > bullmkt123@yahoo.com > > Sent via Deja.com http://www.deja.com/ > Before you buy.

In article <37F8FE85.ABB351E6@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Um, I demur to mention it but, um, are you perhaps trying to lift the rug >on which you stand? If you, for example, do: > >dbaccess mydatabase - >Database selected. > >> drop database mydatabase;> > 359: Cannot drop or rename current database. >Error in line 1>Near character position 24 >> > A bit like trying to unmount a file system you are still in! -- David Williams