Table Lock error when trying Repair
Table Lock error when trying Repair
(OP)
I am trying to run a REPAIR TABLE <tablename> ; but the B-tree check always comes back with "ISAM error: the file is locked" , along with the path of the data file. I tried to run an UPDATE on the same table, both inside and outside a transaction, and it went thru fine.
I'm working on Informix SE & Informix SQL Version 6.04
Any help will be greatly appreciated
I'm working on Informix SE & Informix SQL Version 6.04
Any help will be greatly appreciated
RE: Table Lock error when trying Repair
It's been years since I've run Standard Engine. I receiving an error like this when the raw data file permissions/ownership was changed.
I'd start by checking there.
Regards,
ed
schaefer