onstat -g cac command: Print information about caches

Use the onstat -g cac command to see summary and detailed information about all caches or about a single cache.

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onstat-- -g--cac--+-----------------------+-----------------><
                     +-agg-------------------+   
                     +-aqt-------------------+   
                     +-am--+---------------+-+   
                     |     '-access_method-' |   
                     +-cast------------------+   
                     +-dic-------------------+   
                     +-dsc-------------------+   
                     +-ed--------------------+   
                     +-lbacplcy--------------+   
                     +-lbacusrc--------------+   
                     +-poci------------------+   
                     +-prc-------------------+   
                     +-prn-------------------+   
                     +-rr--------------------+   
                     +-ssc-------------------+   
                     +-ttype-----------------+   
                     +-typei--+---------+----+   
                     |        '-type_id-'    |   
                     '-typen--+-----------+--'   
                              '-type_name-'      

Use the onstat -g cac command without any options to see information about all caches.

Use the following options to see information about a specific cache:

agg
Prints information about the aggregate cache.
aqt
Prints information about the AQT dictionary cache. Prints the same output as the onstat -g aqt command. See onstat -g aqt command: Print data mart and accelerated query table information.
am
Prints information about the access method cache. To see information for a specific access method, include the access method name.
cast
Prints information about the cast cache.
dic
Prints information about the data dictionary cache. Prints the same output as the onstat -g dic command. See onstat -g dic command: Print table information.
dsc
Prints information about the data distribution cache. Prints the same output as the onstat -g dsc command. See onstat -g dsc command: Print distribution cache information.
ed
Prints information about the external directives cache.
lbacplcy
Prints information about the LBAC security policy information cache.
lbacusrc
Prints information about the LBAC credential memory cache.
opci
Prints information about the operator class instance cache.
prc
Prints information about the UDR cache. Prints the same output as the onstat -g prc command. See onstat -g prc command: Print sessions using UDR or SPL routines.
prn
Prints information about the procedure name cache.
rr
Prints information about the routine resolution cache.
ssc
Prints information about the SQL statement cache. Prints the same output as the onstat -g ssc command. See onstat -g ssc command: Print SQL statement occurrences.
ttype
Prints information about the secondary transient cache.
typei
Prints information about the extended type by ID cache. To see information for a specific extended type, include the extended type ID.
typen
Prints information about the extended type by name cache. To see information for a specific extended type, include the extended type name.

Example output

The output of most onstat -g cac commands contains similar format and information.

The following output is an example of the onstat -g cac lbacplcy command:

Security Policy Info Cache:
    Number of lists          : 31
    PLCY_POOLSIZE            : 127


Security Policy Info Cache Entries:

list id   ref  drop hits       heap_ptr         item
--------------------------------------------------------------

9    2    0    0    0          65f1b8d0         test@informix: : secpolicyid 2

15   1    0    0    0          65f1b4d0         test@informix: : secpolicyid 1


    Total number of entries  : 2
    Number of entries in use : 0

Output description

The output of most onstat -g cac commands contains the following fields:

Number of lists
Number of lists in the distribution cache
configuration parameter name
Number of entries that can be cached at one time
list
Distribution cache hash chain ID
id
The unique ID assigned to the cache entry
ref
Number of statements that reference a cache entry
drop
Whether this entry was dropped after it was added to the cache
hits
The number of times the cache entry is accessed
heap_ptr
Heap address that is used to store this entry
item name
The name of the item in the cache
Total number of entries
Number of entries in the cache
Number of entries in use
Number of entries that are being used

Copyright© 2019 HCL Technologies Limited