Re: Oncheck failure: The file is locked

It just means that oncheck couldn't get it's lock on the table. You either ignore it or retry on the table later. Once you hit large systems especially in 24x7 operations then regular oncheck can become a problem Huy Vu wrote: > > 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 -- Paul Watson # WF Software # It said use Windows95 or better Tel ++44 1436 674729 # So I used Unix Fax ++44 1436 678693 # www.wfsoftware.com/informix #

I notice that after a spell of being MISTER Paul Watson, you've returned to being plain old Paul Watson. Have you been through a difficult period? Paul Watson wrote in message <82ikvo$rsj$1@news.xmission.com>... > >It just means that oncheck couldn't get it's lock on the table. You >either ignore it or retry on the table later. Once you hit large >systems especially in 24x7 operations then regular oncheck can become a >problem > > > >Huy Vu wrote: >> >> 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 > >-- >Paul Watson # >WF Software # It said use Windows95 or better >Tel ++44 1436 674729 # So I used Unix >Fax ++44 1436 678693 # >www.wfsoftware.com/informix #