Re: informix - problem with locked records (systables)

Force the engine down to single user mode (onmode -uy) or offline (onmode -ky) and then restart it. That will clear any locks being held. Art S. Kagel o_neill wrote: > > Hello, > I am creating an informix database (Version 7.3) on an IBM RS6000, > using login Informix. I have used a SQL editor to add some table, some > worked correctly. > > I executed a number of SQL commands attempting to create tables and add > contraints to tables. I think there was an error in one of the 'add > constraint' commands and this caused the SQL editor session to hang. > (I did not used SET LOCK MODE commands) > > I would like to delete the tables, possibly delete the database to > ensure that I am not working with corrupted data. > > Select statements on tables now cause the SQL editor session to hang. > > When I tried to delete one of the tables created when the problem > happened I get the following: > > drop table <table name>; > produces the following error - Could not open database table <table > name> ISAM error 113 error: file is locked. > > Deleting a table that was created successfully gives an error: > SQL error 211: Cannot read system catalog (systables): ISAM error 107> records locked. > > drop database <database name> > produces the following error: Database is currently opened by another > user: ISAM error 107 - record locked. > > I have used onstat -u and onstat -k to examine this. There are a number > of sessions running but these do not seem to be locked. > I tried to kill sessions with my user id. using onmode -z and onmode -Z > but it didn't make any difference. I tried this with login informix and > root but no success. > > I can't use the rollback comand either. > > I tried onmode unblock and this doesn't help. > > If anyone has any help on this, I would appreciate it. > Thanks. > > v o_neill > > Sent via Deja.com http://www.deja.com/ > Before you buy.