Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Unix SQL Advanced SQL 4GL Applications Advanced 4GL IDS Admin Migrating to V14 IDS Performance Managing & Optimising SPL and Triggers IDS V14 Upgrading Very Old Versions Custom Training
Onstat Guide Error Code Guide Reference Datablades The Dumb DBA Sysmaster Fault Finder
Co-Location Web Hosting Managed Servers Web Development
BenchMark Tookkit RegExp Datablade
Partnerships Contact
Onstat
-g act -g afr -g all -g amx -g aqt -g arc -g ath -g btc -g buf -g cac -g cdr -g cluster -g cdr config -g cfg -g cmsm -g con -g cpu -g dbc -g ddr -g dic -g dis -g dll -g dmp -g dri -g dsc -g dsk -g dss
-g env -g ffr -g glo -g grp -g imc -g ioa -g iob -g iof -g iog -g ioq -g iov -g ipl -g lap -g laq -g lmm -g lmx -g lsc -g mem -g mgm -g nbm -g nif -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-g opn -g osi -g pgp -g pos -g ppd -g ppf -g pqs -g prc -g proxy -g qst -g rah -g ras -g rbm -g rcv -g rep -g rea -g rss -g sch -g scn -g sds -g seg -g ses -g sle -g smb -g smx -g spi -g sql -g src -g ssc -g stk -g stm -g stq -g sts -g sym -g sync
-g rwm -g tgp -g tpf -g ufr -g wai -g vpcache -g wmx -g wst
-b/-B -F -g cac -g dic -g dsc -g prc -g ssc -g vpcache -h -p -X
-t/-T -g buf -g lap -g opn -g ppf -g scn
-g cat -g cdr -g cdrconfig -g ddr -g dss -g dtc -g grp -g nif -g que -g rcv -g rep -g rqm -g sync
-g cluster -g cmsm -g dri -g ipl -g laq -g proxy -g rss -g sds -g smx
-R -g afr -g ffr -g lmm -g lsc -g mem -g mgm -g nbm -g rbm -g seg -g ses -g stm -g stq -g ufr
-g imc -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-G -u -x -g env -g his -g pqs -g ses -g sql
-g act -g ath -g cpu -g rea -g sle -g stk -g sts -g tpf -g wai -g wst
-a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -g dsc Distribution cache

The onstat -g dsc command displays the distribution cache for statistics generated against tables in the system through the UPDATE STATISTICS command. 

Distribution Cache:
    Number of lists             : 31
    DS_POOLSIZE                 : 127
	
Distribution Cache Entries:

list#  id  ref_cnt   dropped?   heap_ptr        distribution name
-----------------------------------------------------------------

1       0       0       0       14c14420        wbe@oninit_shm:informix.t0030xref.c0010id 

3       0       0       0       14c0a820        wbe@oninit_shm:informix.t0020folder.c0020name

3       0       0       0       14c09420        wbe@oninit_shm:informix.t0020folder.c0026id

Distribution Cache

Heading Description Format
Number of lists The number of lists in the distribution cache. Dec
DS_POOLSIZE The maximum number of entries that can be cached at one time. Dec
Number of entries The number of entries currently in the distribution cache. Dec
Number of entries in use The number of entries currently in use. Dec

Distribution Cache Entries

Column Description Type See Also
list# The distribution cache hash chain ID Dec  
size The number of entries in this hash Dec  
refcnt The number of SQL statements currently referencing one of the entries in this cache. Dec  
dropped? Whether this entry has been deleted since being loaded to the cache. Str  
heapptr The in-memory address for the heap used to store this entry. Hex  
distribution name The (column) name of the distribution in the cache. Str  

Notes

    If a large number of distributions are going to be maintained by the system, setting the DS_POOLSIZE environment variable might help performance.

To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.