onstat -g dsc command: Print distribution cache information

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

Read syntax diagramSkip visual syntax diagram
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

Copyright© 2019 HCL Technologies Limited