SWNCT_DBCON - TMC: Database Connection Aggregate
TMC: Database Connection Aggregate information is stored in SAP table SWNCT_DBCON.
It is part of development package SWNC_TMC in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "Statistics Collector for TMC".
It is part of development package SWNC_TMC in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "Statistics Collector for TMC".
Fields for table SWNCT_DBCON
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | MONIKEY | X | SWNCTMC_ALL | 0 | ||
| .INCLUDE | X | SWNCTMC_KEY | 0 | |||
| COMPONENT | SAP Workload NW Collector: Host Name | X | SWNCHOSTNAME | CHAR | 80 | |
| TIMESTAMP_SERVER | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | X | TIMESTAMP | DEC | 8 | |
| TIME_PERIOD | X | INT4 | 4 | |||
| .INCLUDE | X | SWNCTMC_INC | 0 | |||
| TIME_GRANULARITY | X | INT4 | 4 | |||
| TIME_ZONE | X | INT4 | 4 | |||
| .INCLUDE | PROFKEY | X | SWNCM_DBCON_KEY | 0 | ||
| TASKTYPE | SAP Workload NW Collector: Task Type (Raw Format) | X | SWNCTASKTYPERAW | RAW | 1 | |
| CONNECTION_NAME | SAP Workload NW Collector: Text Field of 30 Characters | X | SWNCTXT30 | CHAR | 60 | |
| .INCLUDE | ENTRY_ID | X | SWNC_ENTRY_ID | 0 | ||
| TCODE | SAP NW Workload Collector: Report or Transaction Name | X | SWNC_TCODE | CHAR | 80 | |
| BTCJOB | Background Job Name | X | BTCJOB | CHAR | 64 | |
| ENTRY_TYPE | Type of Statistic Entry | X | SWNC_ENTRY_TYPE | CHAR | 2 | |
| COMMITTI | SAP Workload NW Collector: Time (Microseconds) in Aggregate | SWNCTIMMSAGG | DEC | 13 | ||
| DBPROCNT | SAP Workload NW Collector: Counter in Aggregates | SWNCCNTAGG | DEC | 13 | ||
| DBPROCTI | SAP Workload NW Collector: Time (Microseconds) in Aggregate | SWNCTIMMSAGG | DEC | 13 | ||
| COUNTER | SAP Workload NW Collector: Counter in Aggregates | SWNCCNTAGG | DEC | 13 | ||
| DBTIME | SAP Workload NW Collector: Time (Microseconds) in Aggregate | SWNCTIMMSAGG | DEC | 13 | ||
| .INCLUDE | SWNCINCDBREAD | 0 | ||||
| READDIRCNT | SAP Workload NW Collector: Counter in Aggregates | SWNCCNTAGG | DEC | 13 | ||
| READDIRTI | SAP Workload NW Collector: Time (Microseconds) in Aggregate | SWNCTIMMSAGG | DEC | 13 | ||
| READDIRBUF | SAP Workload NW Collector: Counter in Aggregates | SWNCCNTAGG | DEC | 13 | ||
| READDIRREC | SAP Workload NW Collector: Counter in Aggregates | SWNCCNTAGG | DEC | 13 | ||
| READSEQCNT | SAP Workload NW Collector: Counter in Aggregates | SWNCCNTAGG | DEC | 13 | ||
| READSEQTI | SAP Workload NW Collector: Time (Microseconds) in Aggregate | SWNCTIMMSAGG | DEC | 13 | ||
| READSEQBUF | SAP Workload NW Collector: Counter in Aggregates | SWNCCNTAGG | DEC | 13 | ||
| READSEQREC | SAP Workload NW Collector: Counter in Aggregates | SWNCCNTAGG | DEC | 13 | ||
| CHNGCNT | SAP Workload NW Collector: Counter in Aggregates | SWNCCNTAGG | DEC | 13 | ||
| CHNGTI | SAP Workload NW Collector: Time (Microseconds) in Aggregate | SWNCTIMMSAGG | DEC | 13 | ||
| CHNGREC | SAP Workload NW Collector: Counter in Aggregates | SWNCCNTAGG | DEC | 13 | ||
| PHYREADCNT | SAP Workload NW Collector: Counter in Aggregates | SWNCCNTAGG | DEC | 13 | ||
| PHYCHNGREC | SAP Workload NW Collector: Counter in Aggregates | SWNCCNTAGG | DEC | 13 | ||
| PHYCALLS | SAP Workload NW Collector: Counter in Aggregates | SWNCCNTAGG | DEC | 13 |