DB2NETSTATS - Contains network statistics collected by DB2 Connect

Contains network statistics collected by DB2 Connect information is stored in SAP table DB2NETSTATS.
It is part of development package STU3 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "Development Class for Database Monitor".

Fields for table DB2NETSTATS

Field Name	Description	Is Key	Data Type	Length
APPSERVER	SAP application server	X	CHAR	50
SNAPDATE	Date of network statistics snapshot	X	DATS	8
SNAPTIME	Time of network statistics snapshot	X	TIMS	6
TRANSMCAT	Transmission category (2, 3-7, 8-15, 16-64 or >64)	X	CHAR	30
ID	Generic identifier	X	INT4	4
.INCLUDE			DB2NETSTR	0
TRANSCARD	Transmission category group (2, 3-7, 8-15, 16-64 or >64)		INT4	4
TRANSMGRP	Internal counter for transmission groups		INT4	4
SQLSTMTS	Number of SQL statements		INT4	4
SQLCHAINS	Number of chained SQL statements		INT4	4
BYTESSENT	Accumulated bytes sent		INT4	4
BYTESREC	Accumulated bytes received		INT4	4
BYTESSMAX	Maximum number of bytes sent		INT4	4
BYTESRMAX	Maximum number of bytes received		INT4	4
BYTESSMIN	Minimum number of bytes sent		INT4	4
BYTESRMIN	Minimum number of bytes received		INT4	4
SENT128	Number of packets sent < 128 bytes		INT4	4
SENT256	Number of packets sent < 256 bytes		INT4	4
SENT512	Number of packets sent < 512 bytes		INT4	4
SENT1K	Number of packets sent < 1024 bytes		INT4	4
SENT2K	Number of packets sent < 2048 bytes		INT4	4
SENT4K	Number of packets sent < 4096 bytes		INT4	4
SENT8K	Number of packets sent < 8192 bytes		INT4	4
SENT16K	Number of packets sent < 16384bytes		INT4	4
SENT32K	Number of packets sent < 31999 bytes		INT4	4
SENT64K	Number of packets sent < 64000 bytes		INT4	4
SENTGT64K	Number of packets sent > 64000 bytes		INT4	4
REC128	Number of packets received < 128 bytes		INT4	4
REC256	Number of packets received < 256 bytes		INT4	4
REC512	Number of packets received < 512 bytes		INT4	4
REC1K	Number of packets received < 1024 bytes		INT4	4
REC2K	Number of packets received < 2048 bytes		INT4	4
REC4K	Number of packets received < 4096 bytes		INT4	4
REC8K	Number of packets received < 8192 bytes		INT4	4
REC16K	Number of packets received < 16384bytes		INT4	4
REC32K	Number of packets received < 31999 bytes		INT4	4
REC64K	Number of packets received < 64000 bytes		INT4	4
RECGT64K	Number of packets received > 64000 bytes		INT4	4
TIME1MS	Number of SQL chains with transmission time < 4ms		INT4	4
TIME4MS	Number of SQL chains with transmission time < 4ms		INT4	4
TIME16MS	Number of SQL chains with transmission time < 16ms		INT4	4
TIME01S	Number of SQL chains with transmission time < 100ms		INT4	4
TIME05S	Number of SQL chains with transmission time < 500ms		INT4	4
TIMEGT05	Number of SQL chains with transmission time > 500ms		INT4	4
TIMEMAX	Obsolete		INT4	4
TIMEMAXM	Obsolete		INT4	4
TIMEMIN	Obsolete		INT4	4
TIMEMINM	Obsolete		INT4	4
EXECTIME	Accumulated elapsed execution time (seconds)		INT4	4
EXECTIMEM	Accumulated elapsed execution time (micro seconds)		INT4	4
HOSTRESP	Accumulated host response time (seconds)		INT4	4
HOSTRESPM	Accumulated host response time (micro seconds)		INT4	4