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 nsc Net Shared Memory Status

The onstat -g nsc command displays the status of shared memory network connections. The command takes an optional client ID as a parameter. If no session ID is provided, a one-line summary for each shared memory connection is listed. 

  clientid  clientPID      state #serverbufs #clientbufs    #rdwrts 
         0      18949  Connected           4           4     447048

Output Description

Heading Description Format
clientid A server assigned value for lookups. Dec
clientPID The client process ID. Dec
state The current state of the connection. Valid options 
  Connected
  Con1
  Waiting
  Reject
  Badvers
  Closed
  Not connected
  Unknown
Str
#serverbufs The number of database server buffers currently allocated. Dec
#clientbufs The number of client buffers currently allocated. Dec
#rdwrts The total number of buffers in use. Dec

With Client ID

Network Shared Memory Status for Client: 0

    clientid    clientPID        state  #serverbufs  #clientbufs      #rdwrts 
           0        18949    Connected            4            4       447048 
                                                                              
     needbuf        segid        semid       semnum     be_semid    be_semnum 
           0         1303       851969            0       851969           10 
                                                                              
  be_curread  be_curwrite   fe_curread  fe_curwrite
          -1            1            0            2
                                                  
 be_nextread be_nextwrite  fe_nextread fe_nextwrite 
           2            2            4            3
                                                                                
readyqueue                                                                      
  -1   -1   -1   -1   -1   -1   -1   -1   -1   -1   -1

     Server Buffers                             Client Buffers
  i: bufid     status   offset  fe_addr         bufid     status   offset  fe_addr
  0:     4      inuse     4474   804474             0      avail     3424   803424
  1:     5      inuse     4888   804888             1      avail     3838   803838
  2:     6      avail     4c9c   804c9c             2      inuse     3c4c   803c4c
  3:     7      avail     50b0   8050b0             3      avail     4060   804060
  4:    -1       free        0        0            -1       free        0       0
  5:    -1       free        0        0            -1       free        0       0
Heading Description Format See Also
clientid A server assigned value for lookups. Dec  
clientPID The client process ID. Dec onstat -g ses
state The current connection state of the shared memory client Str  
#serverbufs The number of database server buffers currently allocated. Dec  
#clientbufs The number of client buffers currently allocated. Dec  
#rdwrts The total number of buffers in use. Dec  
needbuf A flag which indicates whether the server is waiting for a buffer to be freed (0 - false, 1 - true) Dec  
segid The shared memory segment ID Dec onstat -g seg
semid The userthread's semaphore ID Dec  
semnum The userthread semaphore number within the semaphore ID. Dec  
be_semid The backend's semaphore ID Dec  
be_semnum The backend semaphore number within the semaphore ID. Dec  
be_curread The ID of the backend buffer currently being read Dec  
be_curwrite The ID of the backend buffer currently being written Dec  
fe_curread The ID of the frontend buffer currently being read Dec  
fe_curwrite The ID of the frontend buffer currently being written Dec  
be_nextread The ID of the next backend buffer to be read Dec  
be_nextwrite The ID of the next backend buffer to be written Dec  
fe_nextread The ID of the next frontend buffer to be read Dec  
fe_nextwrite The ID of the next frontend buffer to be written Dec  
readyqueue A list of the server's queue of shared memory buffer IDs Dec  

Server/Client Buffers

Heading Description Format
i The internal key to the location of message buffers Dec
bufid The message buffer ID Dec
status The current status of the message buffer Str
offset The offset of the memory buffer into the shared memory segment Hex
fe_addr The frontend address of the message buffer Hex

Notes

    The clientid is a key that the server uses to look up information in the network shared memory status table.

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