/SDF/ZQLMD - SQL Monitor: Data
SQL Monitor: Data information is stored in SAP table /SDF/ZQLMD.
It is part of development package /SDF/ZQLM in software component SV-SMG-DIA. This development package consists of objects that can be grouped under "Package for SQL Monitor".
It is part of development package /SDF/ZQLM in software component SV-SMG-DIA. This development package consists of objects that can be grouped under "Package for SQL Monitor".
Fields for table /SDF/ZQLMD
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | KEY | X | /SDF/ZQLMKEY | 0 | ||
| PROGNAME | ABAP Program Name | X | PROGNAME | CHAR | 40 | |
| PROGKIND | SQL Monitor: Program Kind | X | /SDF/ZQLMPROGKIND | CHAR | 1 | |
| PROCTYPE | SQL Monitor: Processing Block Type | X | /SDF/ZQLMPROCTYPE | CHAR | 4 | |
| PROCNAME | SQL Monitor: Processing Block Name | X | /SDF/ZQLMPROCNAME | CHAR | 93 | |
| PROCLINE | SQL Monitor: Line Number in Processing Block | X | /SDF/ZQLMPROCLINE | INT4 | 4 | |
| .INCLUDE | SUBKEY | X | /SDF/ZQLMSUBKEYINT | 0 | ||
| RUNLEVEL | SQL Monitor: Run Mode | X | /SDF/ZQLMRUNLEVEL | CHAR | 1 | |
| ROOTTYPE | SQL Monitor: Request Type | X | /SDF/ZQLMROOTTYPE | CHAR | 1 | |
| ROOTNAME | SQL Monitor: Request Entry Point (Transaction, etc.) | X | /SDF/ZQLMROOTNAME | CHAR | 60 | |
| STMTKIND | SQL Monitor: SQL Operation | X | /SDF/ZQLMSTMTKIND | CHAR | 1 | |
| TABLENAME | SQL Monitor: Table Name | X | /SDF/ZQLMTABLENAME | CHAR | 16 | |
| .INCLUDE | PAYLOAD | /SDF/ZQLMPAYLOAD | 0 | |||
| XCNT | SQL Monitor: Total Number of Executions | /SDF/ZQLMEXECNT | INT4 | 4 | ||
| .INCLUDE | ROLLAREA | /SDF/ZQLMROLLAREA | 0 | |||
| RCNT | SQL Monitor: Internal Sessions Affected | /SDF/ZQLMROLLAREACNT | INT4 | 4 | ||
| XCNTRCNT | SQL Monitor: Executions per Internal Sessions | /SDF/ZQLMEXECNTROLLAREACNT | DEC | 16 | ||
| .INCLUDE | RUNTIME | /SDF/ZQLMRUNTIME | 0 | |||
| RTMIN | SQL Monitor: Minimum Value of Execution Time | /SDF/ZQLMRUNTIMEMIN | DEC | 16 | ||
| RTMAX | SQL Monitor: Maximum Value of Execution Time | /SDF/ZQLMRUNTIMEMAX | DEC | 16 | ||
| RTCNT | SQL Monitor: Count | /SDF/ZQLMRUNTIMECNT | INT4 | 4 | ||
| RTSUM | SQL Monitor: Total Execution Time | /SDF/ZQLMRUNTIMESUM | DEC | 16 | ||
| RTSQS | SQL Monitor: Runtime Sum of Squares | /SDF/ZQLMRUNTIMESQS | DEC | 16 | ||
| RTAVG | SQL Monitor: Mean Value of Execution Time | /SDF/ZQLMRUNTIMEAVG | DEC | 16 | ||
| RTDEV | SQL Monitor: Standard Deviation of Execution Time | /SDF/ZQLMRUNTIMEDEV | DEC | 16 | ||
| .INCLUDE | DBCOUNT | /SDF/ZQLMDBCOUNT | 0 | |||
| DBMIN | SQL Monitor: Minimum Value of Fetched / Modified Records | /SDF/ZQLMDBCOUNTMIN | INT4 | 4 | ||
| DBMAX | SQL Monitor: Maximum Value of Fetched / Modified Records | /SDF/ZQLMDBCOUNTMAX | INT4 | 4 | ||
| DBCNT | SQL Monitor: DB Count Count | /SDF/ZQLMDBCOUNTCNT | INT4 | 4 | ||
| DBSUM | SQL Monitor: Total Fetched or Modified Records | /SDF/ZQLMDBCOUNTSUM | DEC | 16 | ||
| DBSQS | SQL Monitor: DB Count Sum of Squares | /SDF/ZQLMDBCOUNTSQS | DEC | 16 | ||
| DBAVG | SQL Monitor: Mean Value of Fetched / Modified Records | /SDF/ZQLMDBCOUNTAVG | DEC | 16 | ||
| DBDEV | SQL Monitor: Standard Deviation of Fetched / Modif. Records | /SDF/ZQLMDBCOUNTDEV | DEC | 16 | ||
| DDATE | Date for Runtime Monitor DATA entry | RTMDDATE | DATS | 8 | ||
| DTIME | Time for Runtime Monitor data entry | D_TIME | TIMS | 6 | ||
| RTMCNT | SQL Monitor: RTM Count | /SDF/ZQLMRTMCNT | INT4 | 4 |