Network traffic usage
Hi, I have some problems with some clients working over slower lines, I would like to have one idea about traffic that occurs over my database connections on easy way. Like MegaBytes on real time, I have used wireshark but it just gives individual packets but I need to have information about total network traffic. There is any form to get that? How can I see on real time what are the network traffic for each connection? Thanks for any help. SP sergio.peres@airc.pt
Not sure which version you are on so I will give two answers. You can get
an idea of the amount of data by the number of network read and write calls
done at the network layer with onstat -g ntu. This information is show for
each session. This has been around for a long time. In newer versions you
can look at sysmaster:sysnetworkio table which will give you very detail
information for each database session. OAT also shows this information.
net=5Fid 26
sid 59
net=5Fnetscb 1171295352
net=5Fclient=5Ftype 0
net=5Fclient=5Fname sqlexec
net=5Fread=5Fcnt 8
net=5Fread=5Fbytes 1107
net=5Fwrite=5Fcnt 7
net=5Fwrite=5Fbytes 1027
net=5Fopen=5Ftime 1450226499
net=5Flast=5Fread 1450226505
net=5Flast=5Fwrite 1450226505
net=5Fstate 5
net=5Foptions 0
net=5Fprot=5Fid 1
net=5Fprotocol soctcp
net=5Fserver=5Ffd 2
net=5Fpoll=5Fthread 5
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 12/15/2015 11:51:07 AM:
> From: "SERGIO PERES" <sergio.peres@airc.pt>
> To: ids@iiug.org
> Date: 12/15/2015 11:52 AM
> Subject: Network traffic usage [36256]
> Sent by: ids-bounces@iiug.org
>
> Hi,
>
> I have some problems with some clients working over slower lines, I
> would like
> to have one idea about traffic that occurs over my database connections
on
> easy way. Like MegaBytes on real time, I have used wireshark but it
> just gives
> individual packets but I need to have information about total
> network traffic.
> There is any form to get that? How can I see on real time what are
> the network
> traffic for each connection?
> Thanks for any help.
>
> SP
> sergio.peres@airc.pt
>
>
>
***************************************************************************=
****
> Forum Note: Use "Reply" to post a response in the discussion forum.
>