The onstat -g dic table Option

Without any parameters the onstat -g dic option prints one line of information for each table cached in the shared-memory dictionary. If a table name is specified, prints internal SQL information for that table.

Example Output

Figure 43. onstat -g dic Output

IBM Informix Dynamic Server Version 10.00.UC1   -- On-Line -- Up 18:47:42 
-- 101376 Kbytes

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:viagra.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