Table Lock error when trying Repair

georgepuli · Apr 10, 2002

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

olded · Apr 10, 2002

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Table Lock error when trying Repair

georgepuli

Programmer

olded

Programmer

Similar threads

Part and Inventory Search

Sponsor