Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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 -CIBM 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
Darren Jacobs/Carmax
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.