IC66855: COLUMN NET_READ_BYTES IN SYSNETWORKIO TABLE IS ALWAYS ZERO FOR USER SESSIONS CONNECTING THROUGH TCP

APAR status

• Closed as program error.

Error description

• To analyse network bottlenecks, it is interesting to know how
  many bytes are being transferred by a specific session between
  client and server.
  This can be determined through sysmaster table sysnetworkio,
  using the columns net_read_bytes and net_write_bytes.
  
  While these numbers can be obtained correctly for Shared Memory
  Connections, this doesn't work for TCP Connections.
  For a TCP Connection, the value for net_read_bytes is always 0.
  The value for net_write_bytes looks fine as it is non-zero.
  
  An example query to demonstrate this behaviour (while connected
  via tcp):
  
  select n.sid::char(8) as sid, s.username[1,8],
  n.net_read_bytes,
  n.net_write_bytes,
  n.net_protocol
  from sysnetworkio as n, syssessions s
  where n.sid = s.sid
  order by 4 desc
  
  ... for tcp connects, net_read_bytes is always 0 while
  using the related column net_read_cnt instead of net_read_bytes
  shows non-zero values.
  
  select n.sid::char(8) as sid, s.username[1,8],
  n.net_read_cnt,
  n.net_write_cnt,
  n.net_protocol
  from sysnetworkio as n, syssessions s
  where n.sid = s.sid
  order by 4 desc
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IDS 11.50 users                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Column net_read_bytes in sysnetworkio table is always zero   *
  * for user sessions connecting through tcp                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50xC7 and above.                               *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in IDS 11.50xC7.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP