onstat -g dsc command: Print distribution cache information

Use the onstat -g dsc command to display information about the distribution cache.

Figure 1: Syntax

1  onstat   -g dsc

Example output

Figure 2: onstat -g dsc command output
Data Distribution Cache:
    Number of lists         : 31
    DS_POOLSIZE             : 127

Distribution Cache Entries:
list id   ref  drop hits       last_access          heap_ptr         distribution name
--------------------------------------------------------------------------------

3    0    0    0    42         2020-05-12 10:36:36  4d6b7838         sysadmin:informix.aus_work_info.aus_info_tabid
3    0    0    0    192        2020-05-12 10:36:36  45c264d8         sysadmin:informix.aus_work_dist.aus_dist_tabid

6    0    0    0    204        2020-05-12 10:36:36  45c268d8         sysadmin:informix.aus_work_icols.aus_icols_tabid


Total number of distribution entries: 58
    Number of entries in use        : 0

Output description

Number of lists
Number of lists in the distribution cache
DS_POOLSIZE
Number of entries that can be cached at one time
Number of entries
Number of entries in the distribution cache
Number of entries in use
Number of entries that are being used
list
list#
Distribution cache hash chain ID
id
Number of hash entries
ref
ref_cnt
Number of statements that reference a cache entry
drop
dropped?
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
distribution name
The name of the distribution in the cache
Total number of distribution entries
Number of entries in the distribution cache
Number of entries in use
Number of entries that are being used