onstat -g dsc command: Print distribution cache information

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


Syntax

>>-onstat-- -g--dsc--------------------------------------------><

Example output

Figure 1. 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

Output description

Number of lists: Number of lists in the distribution cache
DS_POOLSIZE: Number of entries that can be cached at one time
list: Distribution cache hash chain ID
id: Number of hash entries
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
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