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 ntt Net User Thread Access Times

The onstat -g ntt command displays the global network information plus user thread access times. The output is sorted in reverse order by session ID.

The global network information description can be found at onstat -g imc 

global network information:                                                    
  #netscb connects     read    write    q-free  q-limits  q-exceed  alloc/max   slow_DNS
  22/  27     4431   656504   670705    2/   2  240/  10    0/   0     0 / 0        12
                                                                               
Individual thread network information (times):                                 
  netscb thread name    sid       open       read      write address           
                                                                               
14e2a8c0 sqlexec       4448   15:56:35   15:56:36   15:56:36                   
                      04/15/2001                                               
14d6eb18 sqlexec       1458   18:11:16   11:27:30   11:27:30                   
                      04/15/2001                                               
14e2aaf8 sqlexec        125   02:02:30   10:32:43   10:32:43                   
                      04/15/2001                                               
14ee9db0 sqlexec        124   22:10:26   10:31:40   10:31:40                   
142876c0 tlitcplst        8   13:24:37   12:02:03            theoden|1529|tlitcp 
                      04/14/2001                                                
14287160 sm_discon        7   13:24:36                                          
                      04/14/2001                                                
14278c28 sm_listen        5   13:24:36                                          
                      04/14/2001                                                
14267b30 tlitcppoll       4   13:24:36                                          
                      04/14/2001                                                
14258018 tlitcppoll       3   13:24:37                                          
                      04/14/2001                                                
1412b490 sm_poll          2   13:24:36                                          
                      04/14/2001

Individual Thread Network Information

Heading Description Format
netscb The in-memory address of the network session control block. Hex
thread name The name of the thread that is currently using this type of connection. Str
sid The session ID associated with this connection.  
open The time this connection was opened.  
read The last time a read operation occurred.  
write The last time a write operation occurred.  
address For network listener threads, the host, socket number and protocol being used.  

Notes

    The onstat -g ntu command is helpful in identifying at what time particular connections were established to the system.

    The timing information can be found via sysnetworkio

    slow_DNS is reported when looking at the hostname takes more time than the allotted time in milliseconds to get the info.
    By default REPORT_SLOW_DNS_THRESHOLD=200
    You can change this value by updating the entry in onconfig. Everytime a hostname lookup takes more than 200 milliseconds it adds 1 to the slow_DNS counter.
    The REPORT_SLOW_DNS_FREQUENCY parameter governs how often a warning message will be written to the log when the slow_dns profile element is incremented.

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