DB2NETSTATS SAP (Contains network statistics collected by DB2 Connect) Table details
Description: Contains network statistics collected by DB2 Connect
Table field list including key, data, relationships and ABAP select examples
DB2NETSTATS is a standard SAP Table which is used to store Contains network statistics collected by DB2 Connect data and is available within R/3 SAP systems depending on the version and release level.
The DB2NETSTATS table consists of various fields, each holding specific information or linking keys about Contains network statistics collected by DB2 Connect data available in SAP. These include SNAPDATE (Date of network statistics snapshot), SNAPTIME (Time of network statistics snapshot), TRANSMCAT (Transmission category (2, 3-7, 8-15, 16-64 or >64)), ID (Generic identifier).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP DB2NETSTATS table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
APPSERVER | SAP application server | 0 | |||||||
SNAPDATE | Date of network statistics snapshot | 0 | |||||||
SNAPTIME | Time of network statistics snapshot | 0 | |||||||
TRANSMCAT | Transmission category (2, 3-7, 8-15, 16-64 or >64) | 0 | |||||||
ID | Generic identifier | 0 | |||||||
TRANSCARD | Transmission category group (2, 3-7, 8-15, 16-64 or >64) | 0 | |||||||
TRANSMGRP | Internal counter for transmission groups | 0 | |||||||
SQLSTMTS | Number of SQL statements | 0 | |||||||
SQLCHAINS | Number of chained SQL statements | 0 | |||||||
BYTESSENT | Accumulated bytes sent | 0 | |||||||
BYTESREC | Accumulated bytes received | 0 | |||||||
BYTESSMAX | Maximum number of bytes sent | 0 | |||||||
BYTESRMAX | Maximum number of bytes received | 0 | |||||||
BYTESSMIN | Minimum number of bytes sent | 0 | |||||||
BYTESRMIN | Minimum number of bytes received | 0 | |||||||
SENT128 | Number of packets sent < 128 bytes | 0 | |||||||
SENT256 | Number of packets sent < 256 bytes | 0 | |||||||
SENT512 | Number of packets sent < 512 bytes | 0 | |||||||
SENT1K | Number of packets sent < 1024 bytes | 0 | |||||||
SENT2K | Number of packets sent < 2048 bytes | 0 | |||||||
SENT4K | Number of packets sent < 4096 bytes | 0 | |||||||
SENT8K | Number of packets sent < 8192 bytes | 0 | |||||||
SENT16K | Number of packets sent < 16384bytes | 0 | |||||||
SENT32K | Number of packets sent < 31999 bytes | 0 | |||||||
SENT64K | Number of packets sent < 64000 bytes | 0 | |||||||
SENTGT64K | Number of packets sent > 64000 bytes | 0 | |||||||
REC128 | Number of packets received < 128 bytes | 0 | |||||||
REC256 | Number of packets received < 256 bytes | 0 | |||||||
REC512 | Number of packets received < 512 bytes | 0 | |||||||
REC1K | Number of packets received < 1024 bytes | 0 | |||||||
REC2K | Number of packets received < 2048 bytes | 0 | |||||||
REC4K | Number of packets received < 4096 bytes | 0 | |||||||
REC8K | Number of packets received < 8192 bytes | 0 | |||||||
REC16K | Number of packets received < 16384bytes | 0 | |||||||
REC32K | Number of packets received < 31999 bytes | 0 | |||||||
REC64K | Number of packets received < 64000 bytes | 0 | |||||||
RECGT64K | Number of packets received > 64000 bytes | 0 | |||||||
TIME1MS | Number of SQL chains with transmission time < 4ms | 0 | |||||||
TIME4MS | Number of SQL chains with transmission time < 4ms | 0 | |||||||
TIME16MS | Number of SQL chains with transmission time < 16ms | 0 | |||||||
TIME01S | Number of SQL chains with transmission time < 100ms | 0 | |||||||
TIME05S | Number of SQL chains with transmission time < 500ms | 0 | |||||||
TIMEGT05 | Number of SQL chains with transmission time > 500ms | 0 | |||||||
TIMEMAX | Obsolete | 0 | |||||||
TIMEMAXM | Obsolete | 0 | |||||||
TIMEMIN | Obsolete | 0 | |||||||
TIMEMINM | Obsolete | 0 | |||||||
EXECTIME | Accumulated elapsed execution time (seconds) | 0 | |||||||
EXECTIMEM | Accumulated elapsed execution time (micro seconds) | 0 | |||||||
HOSTRESP | Accumulated host response time (seconds) | 0 | |||||||
HOSTRESPM | Accumulated host response time (micro seconds) | 0 |
Key field | Non-key field |
How do I retrieve data from SAP table DB2NETSTATS using ABAP code
The following ABAP code Example will allow you to do a basic selection on DB2NETSTATS to SELECT all data from the tableDATA: WA_DB2NETSTATS TYPE DB2NETSTATS.
SELECT SINGLE *
FROM DB2NETSTATS
INTO CORRESPONDING FIELDS OF WA_DB2NETSTATS
WHERE...
How to access SAP table DB2NETSTATS
Within an ECC or HANA version of SAP you can also view further information about DB2NETSTATS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects