Table Lock error when trying Repair

[georgepuli]

I am trying to run a REPAIR TABLE <tablename> ; but the B-tree check always comes back with &quot;ISAM error: the file is locked&quot; , 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

 

[olded]

george:

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