I recall sometime back that someone was going to generate a paper on tuning
the b-tree scanner. Anyone recall who it was? Jerry, weren't you
interested in this too?

Art, was it you by chance?

peace




TBP
<TheBigPotato@Not
Here.Co.Uk> To
Sent by: informix-list@iiug.org
informix-list-bou cc
nces@iiug.org
Subject
Re: Checking indexes after large
06/07/2006 02:30 deletes
PM









Adam Tauno Williams wrote:
>> I can't seem to get "onstat -g btc" to return anything in 9.21 FC4 or
>> 10.0 FC4.
>
> It doesn't do anything on my "10.00.UC4" box.
>
> There is "btree cleaner info", with "onstat -C". Is that the same
> thing?
>
Yes ...

onstat -C

Use the -C option to print the file information about the B-tree scanner
subsystem and each B-tree scanner thread. The following options are
available with the onstat -C command:

prof
Prints the profile information for the system and each B-tree
scanner thread
hot
Prints the hot list index key in the order to be cleaned
part
Prints all partitions with index statistics
clean
Prints information about all the partitions that were cleaned or
need to be cleaned.
range
Prints the savings in pages processes by using index range scanning
all
Prints all onstat -C options
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list