Monitoring Network Operations

Onstat -g ntu Print Net User Thread Profile Information by VP

This command allows you to monitor network packet reads and writes in the IDS engine.

$ onstat -g ntu
Informix Dynamic Server Version 7.30.UC3   -- On-Line -- Up 2 days 22:15:01 -- 18464 Kbytes
global network information:
  #netscb connects     read    write    q-free  q-limits  q-exceed
   4/   6        0        0        0    1/   1  135/  10    0/   0

Individual thread network information (basic):
  netscb type   thread name    sid   fd poll    reads   writes q-nrm q-exp
c1c43b68 soctcp sqlexec         40    3    5        0        0  0/ 0  0/ 0
cla6a018 soctcp sqlexec         34    2    5        0        0  0/ 0  0/ 0
cla51628 soctcp soctcplst        3    1    5        0        0  0/ 0  0/ 0
cla503f8 soctcp soctcppoll       2    0    5        0        0  0/ 0  0/ 0

In the example above, the first two threads are user (sqlexec) threads ...

Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial