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.
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 or more.
Stats reset at 8:30 AM or 6 hrs ago.
HPUX 11
$ onstat -CIBM Informix Dynamic Server Version 9.40.FC2W4 -- On-Line -- Up 4 days
14:58:57 -- 4460564 Kbytes
Btree Cleaner Info
BT scanner profile Information
==============================
Active Threads 1
Global Commands 0
Number of partition scans 34
Main Block 0xc0000000e0a97cc8
BTC Admin 0x0000000000000000
BTS info id Prio Partnum Key Cmd
0xc0000000e0eb58b0 0 Low 0x0600003D 1 100000 Scan index
Number of leaves pages scanned 10803470
Number of leaves with deleted items 68590
Time spent cleaning (sec) 22302
Number of index compresses 11354
Number of deleted items 1269652
Number of index range scans 0
Number of index leaf scans 509
Scan Type Leaf
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.