onstat -g dic command: Print table information

Use the onstat -g dic command to display a line of information about each table that is cached in the shared-memory dictionary. If you specify a table name, this command prints internal SQL information about that particular table.

Figure 1: Syntax:

1  onstat   -g dic

Example output

Figure 2: onstat -g dic command output
Dictionary Cache:  Number of lists: 31, Maximum list size: 10                  
list#  size  refcnt  dirty?  heapptr        table name                         
--------------------------------------------------------                       
   1     3      1      no     14b5d890   wbe@oninit_shm:informix.t0010url      
                1      no     14cbb820   wbe@oninit_shm:informix.t9051themeval 
                0      no     14b63c20   wbe@oninit_shm:informix.t0060hits     
                                                                               
   2     2      0      no     14b97420   wbe@oninit_shm:informix.t0120import   
                1      no     14b6c820   wbe@oninit_shm:informix.t9110domain   
                                                                               
   3     3      0      no     14bce020   wbe@oninit_shm:informix.t0150url      
                0      no     14d3d820   contact@oninit_shm:informix.wbtags    
                0      no     14c87420   wbe@oninit_shm:informix.wbtags        
                                                                               
   4     1      0      no     14b7a420   drug@oninit_shm:abcdef.product      ..
Total number of dictionary entries: 36

Output description

list#
Data dictionary hash chain ID
size
Number of entries in this hash
refcnt
Number of SQL statements currently referencing one of the cache entries.
dirty?
Whether the entry has been modified since last written to disk.
heapptr
Address for the heap used to store this table
table name
Name of table in cache