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

Dictionary Type: Table
Description: Contains network statistics collected by DB2 Connect




ABAP Code to SELECT data from DB2NETSTATS
Related tables to DB2NETSTATS
Access table DB2NETSTATS




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 empty
Display/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 server0
SNAPDATE Date of network statistics snapshot0
SNAPTIME Time of network statistics snapshot0
TRANSMCAT Transmission category (2, 3-7, 8-15, 16-64 or >64)0
ID Generic identifier0
TRANSCARD Transmission category group (2, 3-7, 8-15, 16-64 or >64)0
TRANSMGRP Internal counter for transmission groups0
SQLSTMTS Number of SQL statements0
SQLCHAINS Number of chained SQL statements0
BYTESSENT Accumulated bytes sent0
BYTESREC Accumulated bytes received0
BYTESSMAX Maximum number of bytes sent0
BYTESRMAX Maximum number of bytes received0
BYTESSMIN Minimum number of bytes sent0
BYTESRMIN Minimum number of bytes received0
SENT128 Number of packets sent < 128 bytes0
SENT256 Number of packets sent < 256 bytes0
SENT512 Number of packets sent < 512 bytes0
SENT1K Number of packets sent < 1024 bytes0
SENT2K Number of packets sent < 2048 bytes0
SENT4K Number of packets sent < 4096 bytes0
SENT8K Number of packets sent < 8192 bytes0
SENT16K Number of packets sent < 16384bytes0
SENT32K Number of packets sent < 31999 bytes0
SENT64K Number of packets sent < 64000 bytes0
SENTGT64K Number of packets sent > 64000 bytes0
REC128 Number of packets received < 128 bytes0
REC256 Number of packets received < 256 bytes0
REC512 Number of packets received < 512 bytes0
REC1K Number of packets received < 1024 bytes0
REC2K Number of packets received < 2048 bytes0
REC4K Number of packets received < 4096 bytes0
REC8K Number of packets received < 8192 bytes0
REC16K Number of packets received < 16384bytes0
REC32K Number of packets received < 31999 bytes0
REC64K Number of packets received < 64000 bytes0
RECGT64K Number of packets received > 64000 bytes0
TIME1MS Number of SQL chains with transmission time < 4ms0
TIME4MS Number of SQL chains with transmission time < 4ms0
TIME16MS Number of SQL chains with transmission time < 16ms0
TIME01S Number of SQL chains with transmission time < 100ms0
TIME05S Number of SQL chains with transmission time < 500ms0
TIMEGT05 Number of SQL chains with transmission time > 500ms0
TIMEMAX Obsolete0
TIMEMAXM Obsolete0
TIMEMIN Obsolete0
TIMEMINM Obsolete0
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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!