informix - problem with locked records (systables)

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 107records 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.