SEO

This is a multipart message in MIME format.
--=_alternative 005149EC85256FBA_=
Content-Type: text/plain; charset="US-ASCII"

All,

Does anyone have a rule of thumb or words of wisdom regarding additonal
btree cleaners?
Looking at the output below it seems I could benefit from adding an
additional cleaner

Stats reset at 8:30 AM
HPUX 11
$ onstat -C

IBM Informix Dynamic Server Version 9.40.FC2W4 -- On-Line -- Up 3 days
14:50:17 -- 4460564 Kbytes

Btree Cleaner Info
BT scanner profile Information
==============================
Active Threads 1
Global Commands 0
Number of partition scans 23
Main Block 0xc0000000e0a97cc8
BTC Admin 0x0000000000000000


BTS info id Prio Partnum Key Cmd
0xc0000000e0eb58b0 0 Low 0x055007F4 1 100000 Scan index
Number of leaves pages scanned 10623920
Number of leaves with deleted items 122292
Time spent cleaning (sec) 22243
Number of index compresses 39214
Number of deleted items 4660843
Number of index range scans 0
Number of index leaf scans 259
Scan Type Leaf
--=_alternative 005149EC85256FBA_=
Content-Type: text/html; charset="US-ASCII"


<br><font size=2 face="sans-serif">All,</font>
<br>
<br><font size=2 face="sans-serif">Does anyone have a rule of thumb or
words of wisdom regarding additonal btree cleaners? &nbsp;</font>
<br><font size=2 face="sans-serif">Looking at the output below it seems
I could benefit from adding an additional cleaner</font>
<br>
<br><font size=2 face="sans-serif">Stats reset at 8:30 AM</font>
<br><font size=2 face="sans-serif">HPUX 11</font>
<br><font size=2 face="sans-serif">$ onstat -C</font>
<br>
<br><font size=2 face="sans-serif">IBM Informix Dynamic Server Version
9.40.FC2W4 &nbsp; -- On-Line -- Up 3 days 14:50:17 -- 4460564 Kbytes</font>
<br>
<br><font size=2 face="sans-serif">Btree Cleaner Info</font>
<br><font size=2 face="sans-serif">BT scanner profile Information</font>
<br><font size=2 face="sans-serif">==============================</font>
<br><font size=2 face="sans-serif">Active Threads &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; 1</font>
<br><font size=2 face="sans-serif">Global Commands &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp;0 &nbsp;</font>
<br><font size=2 face="sans-serif">Number of partition scans &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23</font>
<br><font size=2 face="sans-serif">Main Block &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0xc0000000e0a97cc8</font>
<br><font size=2 face="sans-serif">BTC Admin &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0x0000000000000000</font>
<br>
<br>
<br><font size=2 face="sans-serif">BTS info &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; id &nbsp; Prio &nbsp; &nbsp;Partnum &nbsp; &nbsp; &nbsp;Key
&nbsp; &nbsp; Cmd &nbsp;</font>
<br><font size=2 face="sans-serif">0xc0000000e0eb58b0 &nbsp; &nbsp;0 &nbsp;
&nbsp;Low &nbsp; 0x055007F4 &nbsp; &nbsp; 1 &nbsp; 100000 &nbsp;Scan index</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; Number of leaves pages
scanned &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
10623920</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; Number of leaves with
deleted items &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;122292</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; Time spent cleaning (sec)
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; 22243</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; Number of index compresses
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp;39214</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; Number of deleted items
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; 4660843</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; Number of index range
scans &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; 0</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; Number of index leaf scans
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp;259</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; Scan Type &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Leaf</font>
--=_alternative 005149EC85256FBA_=--
sending to informix-list