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 ntd Net Dispatch Information

The onstat -g ntd command provides network statistics by service. The output identifies what client connections are currently being accepted.

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
  20/  26     1389   245991   251275    0/   1  240/  10    0/   0     53/  53
                                                                        
Client Type     Calls   Accepted   Rejected       Read      Write       
sqlexec         yes         1387          0     244515     251183       
srvinfx         yes            0          0          0          0       
onspace         yes            0          0          0          0       
onlog           yes            0          0          0          0       
onparam         yes            0          0          0          0       
oncheck         yes            0          0          0          0       
onload          yes            0          0          0          0       
onunload        yes            0          0          0          0       
onmonitor       yes            0          0          0          0       
dr_accept       yes            0          0          0          0       
cdraccept       no             0          0          0          0       
ontape          yes            1          0         86         90       
srvstat         yes            1          0          1          2       
asfecho         yes            0          0          0          0       
listener        yes            0          0       1389          0   
crsamexec       yes            0          0          0          0   
safe            yes            0          0          0          0   
onutil          yes            0          0          0          0   
Totals                      1389          0     245991     251275

Output Description

Heading Description Format See Also
Client Type The type of front-end applications/utilities that OnLine permits to connect to the engine. Application connections are represented by sqlexec Str onstat -g ath
Calls Whether a particular connection type is currently authorized to connect. In quiescent mode, sqlexec and several other types will be listed as 'no' Str  
Accepted The number of connections made by this type of client that were accepted. Dec  
Rejected The number of connections made by this type of client that were rejected.. Reasons for being rejected include
  • authentication error (bad password etc)
  • network error on the incoming connection
  • wrong mode (like single user/quiescent mode but a non-allowed type tries to connect
  • some problem starting up a new thread
Dec  
Read The number of read requests made. Dec  
Write The number of write requests made. Dec  

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