Home | Previous Page | Next Page   Administrative Utilities > The onstat Utility >

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
Example Output

Figure 33. onstat -C Output 
IBM Informix Dynamic Server Version 10.00.UC1       -- On-Line -- Up 03:59:17 -- 15360 
Kbytes

Btree Cleaner Info
BT scanner profile Information
==============================
Active Threads                               1
Global Commands                          20000   Building hot list
Number of partition scans                    0
Main Block                          0x0a69cc08
BTC Admin                           0x0a4d9248


BTS info     id   Prio    Partnum      Key     Cmd  
0xa69cd58     0    Low   0x00000000     0       40  Yield N
   Number of leaves pages scanned                          0
   Number of leaves with deleted items                     0
   Time spent cleaning (sec)                               0
   Number of index compresses                              0
   Number of deleted items                                 0
   Number of index range scans                             0
   Number of index leaf scans                              0
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]