The onstat -g dsc Option

Home | Previous Page | Next Page Administrative Utilities > The onstat Utility > onstat -g Monitoring Options >

The onstat -g dsc Option

Prints a list of distribution cache information.

Example Output

Figure 47. onstat -g dsc Output

IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 01:54:52 
-- 101376 Kbytes

Distribution Cache:
    Number of lists             : 31
    PC_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

The first section of output describes the distribution cache.

Number of lists: Number of lists in the distribution cache
PC_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 being used

The second section of output describes the distribution cache entries.

list#: Distribution cache hash chain ID
id: Number of hash entries
ref_cnt: Number of statements referencing a cache entry
dropped?: Whether this entry has been dropped since being added to the cache
heap_ptr: Heap address used to store this entry
distribution name: The name of the distribution in the cache