Re: BTSCANNER defaults

10.0.UC5 here. Thanks for the info, what you say makes sense. The threads were very active and probably dynamically changed themselves to run at a high priority. We are upgrading our last 9.3 instances to 10.0 tonight and I am explicitly setting the BTSCANNER onconfig parameter to low priority. I will see if it changes to high on the fly. Do you know of any guidelines as to when an ALICE scan would be preferred over a leaf or range scan? Andrew ----- Original Message ----- From: Mark Jamison To: Andrew Ford ; informix-list@iiug.org Sent: Tuesday, December 05, 2006 9:58 AM Subject: Re: BTSCANNER defaults Sorry for the repeat I forgot to include the whole list Inlater versions of 10, 10.00.FC5 and greater I believe, the Default is still LOW, but now it will actually switch to High to run any critical sections, like compresses. It will reset back to LOW when doing scans, or while at rest, but if the threads are doing a lot of compresses, or a lot of cleaning, then the threads will appear to be HIGH all the time. ----- Original Message ---- >What is an alice scan? ALICE stands for (A)daptive (L)inear (I)ndex (C)l(E)aning. It's new functionality that begins in 10.00.xC5. It is disabled by default. You can turn it on by including the value alice=<1-9> at the end of your BTSCANNER entry in onconfig. You can look at the results of the work ALICE does by using the following commands onstat -C alice Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list