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
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.