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.
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
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.
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.