SAP ABAP Table DB2NETSTATS (Contains network statistics collected by DB2 Connect)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DB2NETSTATS	Table Relationship Diagram
Short Description	Contains network statistics collected by DB2 Connect

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	APPSERVER	☑			CHAR	50	0
2	SNAPDATE	☑			DATS	8	0
3	SNAPTIME	☑			TIMS	6	0
4	TRANSMCAT	☑			CHAR	30	0
5	ID	☑			INT4	10	0
6	.INCLUDE	☐				0	0	Structure for network statistics collected by DB2 Connect
7	TRANSCARD	☐			INT4	10	0
8	TRANSMGRP	☐			INT4	10	0
9	SQLSTMTS	☐			INT4	10	0
10	SQLCHAINS	☐			INT4	10	0
11	BYTESSENT	☐			INT4	10	0
12	BYTESREC	☐			INT4	10	0
13	BYTESSMAX	☐			INT4	10	0
14	BYTESRMAX	☐			INT4	10	0
15	BYTESSMIN	☐			INT4	10	0
16	BYTESRMIN	☐			INT4	10	0
17	SENT128	☐			INT4	10	0
18	SENT256	☐			INT4	10	0
19	SENT512	☐			INT4	10	0
20	SENT1K	☐			INT4	10	0
21	SENT2K	☐			INT4	10	0
22	SENT4K	☐			INT4	10	0
23	SENT8K	☐			INT4	10	0
24	SENT16K	☐			INT4	10	0
25	SENT32K	☐			INT4	10	0
26	SENT64K	☐			INT4	10	0
27	SENTGT64K	☐			INT4	10	0
28	REC128	☐			INT4	10	0
29	REC256	☐			INT4	10	0
30	REC512	☐			INT4	10	0
31	REC1K	☐			INT4	10	0
32	REC2K	☐			INT4	10	0
33	REC4K	☐			INT4	10	0
34	REC8K	☐			INT4	10	0
35	REC16K	☐			INT4	10	0
36	REC32K	☐			INT4	10	0
37	REC64K	☐			INT4	10	0
38	RECGT64K	☐			INT4	10	0
39	TIME1MS	☐			INT4	10	0
40	TIME4MS	☐			INT4	10	0
41	TIME16MS	☐			INT4	10	0
42	TIME01S	☐			INT4	10	0
43	TIME05S	☐			INT4	10	0
44	TIMEGT05	☐			INT4	10	0
45	TIMEMAX	☐			INT4	10	0
46	TIMEMAXM	☐			INT4	10	0
47	TIMEMIN	☐			INT4	10	0
48	TIMEMINM	☐			INT4	10	0
49	EXECTIME	☐			INT4	10	0
50	EXECTIMEM	☐			INT4	10	0
51	HOSTRESP	☐			INT4	10	0
52	HOSTRESPM	☐			INT4	10	0

History

Last changed by/on	SAP	20070813
SAP Release Created in	620