Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
o_neill — — source: Informix-list mailing list archive (1991-1998)
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.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.