FW: BTREE SCANNER monitoring and tuning.

Sam, BTScanner is one of very poorly documented aspects of Informix. Some information was available on Neil's site, but it's not here any more. I can just give You a 'rule of a thumb' of some initial $ONCONFIG configuration parameters: BTSCANNER num=1,priority=low,threshold=50000,rangesize=10000 This parameters are *much* better then the default ones - for machnes with 1-4 GB of memory. -Alexey > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On > Behalf Of Gentsch, Sam > > I understand there are several onstat options, > > onstat -C prof/hot/part/clean/range/all> > But are there any whitepapers, or any kind of documentation that tells > you what > all this information means, what is good what is bad, and how to tune > the > darn things (I know the onconfig entry, but again, guidelines) ? > > I have looked through the manuals....unless I missed something. > > IF nothing exists....would there be any interest in this as a Chat with > the Labs or something? > > Not that I have the power to make that happen, but maybe one of you > IBM-ers can :) > > > > -- > Sam > > sending to informix-list sending to informix-list

"Alexey Sonkin" <alexeys@cidc.com> wrote in message news:1123191451.463032d9745d3db55c8a2ef3928fe560@teranews... > > > Sam, > > BTScanner is one of very poorly documented aspects of Informix. > Some information was available on Neil's site, but it's not here any > more. You can still find it here: http://www.informix-support.co.uk/940_testing.htm