RE: Long checkpoints

Full ack with OTC's advice. If you want to be sure that the btree scanners causes your issue set environment variable TRACECKPT=1; export TRACECKPT # chatty Checkpoints before starting your instance. You will see if you have write issues or critical section issues (btscanner) in online.log. HTH Reinhard. > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org]On Behalf Of Obnoxio The Clown > Sent: Wednesday, September 10, 2008 11:43 PM > To: askel > Cc: informix-list@iiug.org > Subject: Re: Long checkpoints > > > askel wrote: > > Obnoxio, > > > > Thank you for the advice. It doesn't seem to be dangerous but could > > you tell me how do I reverse the effect of executing that command or > > how do I check what is the currently used value? We do have backups > > but restoring the database is last thing I'd want to do about live > > database/system. > > > > > onstat -C tells you that the value was 500.> > onmode -C threshold 500 will re-set the value.> > -- > Cheers, > Obnoxio the Clown > > http://obotheclown.blogspot.com > > > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

On Sep 11, 3:21 am, "Habichtsberg, Reinhard" <RHabichtsb...@arz- emmendingen.de> wrote: > Full ack with OTC's advice. If you want to be sure that the btree scanners > causes your issue set environment variable TRACECKPT=1; export TRACECKPT # > chatty Checkpoints before starting your instance. You will see if you have > write issues or critical section issues (btscanner) in online.log. > > HTH > Reinhard. > > > -----Original Message----- > > From: informix-list-boun...@iiug.org > > [mailto:informix-list-boun...@iiug.org]On Behalf Of Obnoxio The Clown > > Sent: Wednesday, September 10, 2008 11:43 PM > > To: askel > > Cc: informix-l...@iiug.org > > Subject: Re: Long checkpoints > > > askel wrote: > > > Obnoxio, > > > > Thank you for the advice. It doesn't seem to be dangerous but could > > > you tell me how do I reverse the effect of executing that command or > > > how do I check what is the currently used value? We do have backups > > > but restoring the database is last thing I'd want to do about live > > > database/system. > > > onstat -C tells you that the value was 500.> > > onmode -C threshold 500 will re-set the value.> > > -- > > Cheers, > > Obnoxio the Clown > > >http://obotheclown.blogspot.com > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list Hello there, Thank you all for helping me. I found the real source of problem -- few sub-mirrors of RAID-1 disks used for dbspaces have failed. That was my mistake to check their status only now. I'm sorry for wasting everybody's time. Thank you, Alexander

askel wrote: > On Sep 11, 3:21 am, "Habichtsberg, Reinhard" <RHabichtsb...@arz- > emmendingen.de> wrote: >> Full ack with OTC's advice. If you want to be sure that the btree scanners >> causes your issue set environment variable TRACECKPT=1; export TRACECKPT # >> chatty Checkpoints before starting your instance. You will see if you have >> write issues or critical section issues (btscanner) in online.log. >> >> HTH >> Reinhard. >> >>> -----Original Message----- >>> From: informix-list-boun...@iiug.org >>> [mailto:informix-list-boun...@iiug.org]On Behalf Of Obnoxio The Clown >>> Sent: Wednesday, September 10, 2008 11:43 PM >>> To: askel >>> Cc: informix-l...@iiug.org >>> Subject: Re: Long checkpoints >>> askel wrote: >>>> Obnoxio, >>>> Thank you for the advice. It doesn't seem to be dangerous but could >>>> you tell me how do I reverse the effect of executing that command or >>>> how do I check what is the currently used value? We do have backups >>>> but restoring the database is last thing I'd want to do about live >>>> database/system. >>> onstat -C tells you that the value was 500. >>> onmode -C threshold 500 will re-set the value. >>> -- >>> Cheers,>>> Obnoxio the Clown >>> http://obotheclown.blogspot.com >>> _______________________________________________ >>> Informix-list mailing list >>> Informix-l...@iiug.org >>> http://www.iiug.org/mailman/listinfo/informix-list > > Hello there, > > Thank you all for helping me. I found the real source of problem -- > few sub-mirrors of RAID-1 disks used for dbspaces have failed. That > was my mistake to check their status only now. I'm sorry for wasting > everybody's time. > > Thank you, > Alexander We've wasted time in worst cases ;) Don't worry... -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...