DB2NETSTR SAP (Structure for network statistics collected by DB2 Connect) Structure details
Description: Structure for network statistics collected by DB2 Connect
Structure field list including key, data, relationships and ABAP select examples
DB2NETSTR is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure for network statistics collected by DB2 Connect" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_DB2NETSTR TYPE DB2NETSTR.
The DB2NETSTR table consists of various fields, each holding specific information or linking keys about Structure for network statistics collected by DB2 Connect data available in SAP. These include TRANSMGRP (Internal counter for transmission groups), SQLSTMTS (Number of SQL statements), SQLCHAINS (Number of chained SQL statements), BYTESSENT (Accumulated bytes sent).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP DB2NETSTR structure 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 |
| 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 structure DB2NETSTR using ABAP code?
As DB2NETSTR is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DB2NETSTR as there is no data to select.How to access SAP table DB2NETSTR
Within an ECC or HANA version of SAP you can also view further information about DB2NETSTR 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