Re: On long checkpoints (again) under IDS 10

HI. Thank you. Indeed, I ran update statistics for user tables, but not for system catalog ones. Should I use high mode, or low is enough? I'll get documentation on BTREE cleaner configuration. Later Omar --- On Tue, 7/21/09, Art Kagel <art.kagel@gmail.com> wrote: > From: Art Kagel <art.kagel@gmail.com> > Subject: Re: On long checkpoints (again) under IDS 10 > To: "Omar Muñoz" <omarmun@yahoo.com> > Date: Tuesday, July 21, 2009, 5:02 PM > Could be the BTREE Cleaners.  They > behave differently under 10 than under 9.40.  Try > configuring the BTREE cleaner settings in your ONCONFIG file > to use the new ALICE mode which is first available in > 10.00.xC5 or so.  That's the most efficient cleaner. > Also, have you updating stats on all your tables and stored > procedures since the upgrade?  On the system catalog tables > in each database as well?  This can make a difference if > you have not. > > > > Art > > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my > own opinions and do not reflect on my employer, Oninit, the > IIUG, nor any other organization with which I am associated > either explicitly or implicitly.  Neither do those opinions > reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities > themselves. > > > > > > > On Tue, Jul 21, 2009 at 5:56 PM, > Omar Muñoz <omarmun@yahoo.com> > wrote: > > > > > Hi. > > > >   We have just migrated an instance from 9.40 FC6 to IDS > 10 FC8 on an Solaris9 - sparc server. > > > >   Prior to this, we had a lot of problems with long > checkpoints which finally could solve. But suddenly, after > migrations, long checkpoints got back. Nothing changed, > neither data, activity nor onconfig file (We haven't > change some onconfig parameters which differ on syntax, but > IBM's partnerships said there wasn't problem), so I > suppose there are some standard tunning We have to do. What > can I do to overcome this trouble? > > > > > >   Thanks in advance > > > >                 Omar > > > > > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > >