I am attempting to drop a table via dbaccess, but I keep
getting the following error messages:
214: Cannot remove file for table (sapr3.moni).
106: ISAM error: non-exclusive access.
I am trying to reorganize the table to free up some space. I
have unloaded it, and recreated the schema. Now, when I try to
drop it, it looks as if someone has a lock on the table.
However, when I ran the following query from dbaccess:
select * from syslocks;
I did not find any locks on the table I am trying to drop.
I have tried logging onto dbaccess as the owner of the table,
but I still get the same error message.
When I try an onstat -k, I do not find the tblsnum of the table
I am trying to drop.
Does anyone have any ideas/suggestions?
Bob Walters
walterba@norand.com
Operating Environment:
HP/UX 10.01
INFORMIX-OnLine Version 7.20.EV3P3
SAP 3.0c