Oninit Logo
The Down System Specialists
+1-913-732-8892
+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 cac Cache Entries

The onstat -g cac command displays the status of the in-memory caches. The command may take one or two arguments: the cache name and optionally the entry name within the cache.


OptionDescription
aggPrints information about the aggregate cache.
aqtPrints information about the AQT dictionary cache. Prints the same output as the onstat -g aqt command.
amPrints information about the access method cache. To see information for a specific access method, include the access method name.
castPrints information about the cast cache.
dicPrints information about the data dictionary cache. Prints the same output as the onstat -g dic command.
dscPrints information about the data distribution cache. Prints the same output as the onstat -g dsc command.
edPrints information about the external directives cache.
lbacplcyPrints information about the LBAC security policy information cache.
lbacusrcPrints information about the LBAC credential memory cache.
opciPrints information about the operator class instance cache.
prcPrints information about the UDR cache. Prints the same output as the onstat -g prc command.
prnPrints information about the procedure name cache.
rrPrints information about the routine resolution cache.
sscPrints information about the SQL statement cache. Prints the same output as the onstat -g ssc command.
ttypePrints information about the secondary transient cache.
typeiPrints information about the extended type by ID cache. To see information for a specific extended type, include the extended type ID.
typenPrints information about the extended type by name cache. To see information for a specific extended type, include the extended type name.

The example below is from onstat -g cac ed, most of the options have a similar format and detail the same information 


External Directive Cache:
    Number of lists             : 67

list#   refcount        dirty?  hashcode_t      database name   Hashcodes
-----------------------------------------------------------------------------
30      0               no      0               sysmaster
46      0               no      0               oninit
48      0               no      0               dbaudit
60      0               no      0               wbe
61      0               no      0               dictionary
FieldDescription
Number of lists Number of lists in the distribution cache
configuration parameter name Number of entries that can be cached at one time
list Distribution cache hash chain ID
id The unique ID assigned to the cache entry
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
item name The name of the item in the cache
Total number of entries Number of entries in the cache
Number of entries in use Number of entries that are being used

Performance and Tuning

    onstat -g cac prc : Aim for one entry per list

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