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.

Figure 1: Syntax:

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 ids_adr_1146.html.
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 Entries:

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

9    2    0    0    0          2020-05-12 10:36:34  65f1b8d0         test@informix: : secpolicyid 2

15   1    0    0    0          2020-05-12 10:36:34  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
last_access: The time at which the cache entry was last 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