onstat -g dsc command: Print distribution cache information

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

Figure 1. Syntax

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       heap_ptr       distribution name 
--------------------------------------------------------------

0    0    0    0    300        d1567a438      testdb:informix.holding.h_t_id
0    0    0    0    6298       d0db27c38      testdb:informix.trade.th_t_id
0    0    0    0    4499       d089d6838      testdb:informix.security.s_co_id
0    0    0    0    4050       d086d9438      testdb:informix.customer.ca_c_id

1    0    0    0    900        d0c01e038      testdb:informix.compet.cp_comp_id
1    0    0    0    4049       cf99894d0      testdb:informix.customer.ca_id

3    0    0    0    900        d15674038      testdb:informix.industry.in_name
3    0    0    0    1794       d0db0f038      testdb:informix.news_xref.nx_id

4    0    0    0    1800       d12663838      testdb:informix.history.hh_h_id

5    0    0    0    900        d08cb1838      testdb:informix.watch_item.wi_id
5    0    0    0    1800       d08b95c38      testdb:informix.address.ad_zc_code

6    0    0    0    1050       d0b68d038      testdb:informix.ctaxrate.cx_c_id
6    0    0    0    1050       d0b683038      testdb:informix.taxrate.tx_id

...

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

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

Distribution Cache:
    Number of lists             : 31
    DS_POOLSIZE                 : 50
    Number of entries           : 0
    Number of entries in use    : 0
Distribution Cache Entries: 

list#  id  ref_cnt   dropped?   heap_ptr        distribution name

-----------------------------------------------------------------
Distribution Cache is empty.

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