Oninit cdi / Archive
Talk to an expert →

RE: Oncheck failure: The file is locked

Posted in 1999

Topics: Storage & Space Management, Error Codes & Troubleshooting, Versions, Editions & End-of-Life

Murray Wood — — source: Informix-list mailing list archive (1991-1998)

You cannot oncheck a table that is open. Close the table (by closing the application running) then oncheck it. Murray Wood -----Original Message----- From: Huy Vu [SMTP:huyv@usa.net] Sent: Tuesday, December 07, 1999 7:19 AM To: informix-list@iiug.org Subject: Oncheck failure: The file is locked Hi all, I ran oncheck everynight on IDS 7.30UC2 under UW7.0.1. Sometime the oncheck not successful with error messages: Validating indexes for db_main:informix.tab_main. oncheck failure: sqispnlock() ISAM error: the file is locked. TBLspace data check for db_main:informix.tab_main Does someone see this problem before? Thanks in advance for any help. H.V

↪ replying to Murray Wood
martyn.ayshford@orange.co.uk — — source: Informix-list mailing list archive (1991-1998)

I thought you could do an oncheck on open tables in the newer versions isn't there an additional option now? Can't for the life of me remember what it was though and seem to remember it basically just skipped bits.... I'd do an oncheck -- and check the options available to you on your version of oncheck. cheers mja In article <82hapj$c9u$1@news.xmission.com>, "murray@quanta.co.nz" <murray@quanta.co.nz> wrote: > > > You cannot oncheck a table that is open. Close the table (by closing the application running) then oncheck it. > > Murray Wood > > -----Original Message----- > From: Huy Vu [SMTP:huyv@usa.net] > Sent: Tuesday, December 07, 1999 7:19 AM > To: informix-list@iiug.org > Subject: Oncheck failure: The file is locked > > Hi all, > > I ran oncheck everynight on IDS 7.30UC2 under UW7.0.1. Sometime the oncheck> not successful with error messages: > > Validating indexes for db_main:informix.tab_main. > oncheck failure: sqispnlock() ISAM error: the file is locked. TBLspace data > check for db_main:informix.tab_main > > Does someone see this problem before? > > Thanks in advance for any help. > > H.V > > Sent via Deja.com http://www.deja.com/ Before you buy.

Glossary