Re: Informix halts for no obvious reason ?!

In article <5v685l$ca1@cssun.mathcs.emory.edu>, Milen Metodiev <dbadmin@svilosa.bis.bg> writes >Hi guys! > >Thanks for all helpfull information which you posted to me. >There was really some holes in our Informix configuration. >But, however, our Informix server doesn't stop >falling into its bottle neck. I hope when we buy 5.08 most >of the problems will be solved by themselves. > >I'm waiting again for a checkpoint which was never completed. Answer: check that ther is not an archive running which has got stuck. E.g. tbtape not clokcing up any CPU time. Once had a system where the tape drive had got "stuck". Since tbtape was inside a system call at the time it could not be killed. I think we eventually rebooted to solve the problem. This may be the problem...can't remember the exact problem but certainly no new checkpoints were occuring.. >Thanks again. You are most useful source of information >in managing Informix related products. > > >Best regards, >Milen. >(No longer a so confused dbadmin) >:) > >====================================================== >Database: Informix OnLine 5.0.2.UC6 >OS : SCO OpenServer Enterprise System Release 3.0 >E-mail : dbadmin@svilosa.bis.bg >====================================================== > -- David Williams