Table/Structure Field list used by SAP ABAP Function Module REPORT_DB4_PERF_VALUES (Reports DB2/400 performance values in rz20)
SAP ABAP Function Module 
REPORT_DB4_PERF_VALUES (Reports DB2/400 performance values in rz20) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
ALALERTRC - VALUE | Alert: alert value (1 = green, 2 = yellow, ....) | |
| 2 | Table/Structure Field |
ALGENALERT - VALUE | Alert: alert value (1 = green, 2 = yellow, ....) | |
| 3 | Table/Structure Field |
ALMTCREATE - NAME | Alert: Short Name of Monitoring Type | |
| 4 | Table/Structure Field |
ALPERFRVAL - NEWPVALSUM | Alert: Report New Performance Value: New Perf Value Sum | |
| 5 | Table/Structure Field |
ALTYPES - CHAR1 | Single-Character Flag | SOURCE VALUE(DIALOG_MODE) LIKE ALTYPES-CHAR1 |
| 6 | Table/Structure Field |
ALTYPES - CHAR1 | Single-Character Flag | |
| 7 | Table/Structure Field |
DB4WAITSTS - WDB | Cumulative number of process waits for database locks | |
| 8 | Table/Structure Field |
DB4WAITSTS - WDBT | Total cumulative time spent on DB lock waits (all processes) | |
| 9 | Table/Structure Field |
DB4WAITSTS - WDBT_AVG | Average of total cumulative database lock wait time | |
| 10 | Table/Structure Field |
DB4WTSTS_S - WDB | Cumulative number of process waits for database locks | |
| 11 | Table/Structure Field |
DB4WTSTS_S - WDBT | Total cumulative time spent on DB lock waits (all processes) | |
| 12 | Table/Structure Field |
DB4WTSTS_S - WDBT_AVG | Average of total cumulative database lock wait time | |
| 13 | Table/Structure Field |
DB6NAVSYST - DBHOST | DBA Cockpit: Server Name | |
| 14 | Table/Structure Field |
DB6NAVSYST - SCHEMANAME | DB6: Schema Name | |
| 15 | Table/Structure Field |
SQHIST_DB4 - QQUPDCNT | iSeries: Number of Executed UPDATEs (Database Monitor) | |
| 16 | Table/Structure Field |
SQHIST_DB4 - QQTSCTTIME | iSeries: Total Time Used by Table Scans | |
| 17 | Table/Structure Field |
SQHIST_DB4 - QQTSCTOTR | iSeries: Total Rows Read by Table Scans | |
| 18 | Table/Structure Field |
SQHIST_DB4 - QQTSCCNT | iSeries: Number of Table Scans | |
| 19 | Table/Structure Field |
SQHIST_DB4 - QQTMFTTIME | iSeries: Total Time Used by Temp. File Creates | |
| 20 | Table/Structure Field |
SQHIST_DB4 - QQTMFCNT | iSeries: Number of Temporary Files Created | |
| 21 | Table/Structure Field |
SQHIST_DB4 - QQIDCTTIME | iSeries: Total Time Used by Index Creates (Database Monitor) | |
| 22 | Table/Structure Field |
SQHIST_DB4 - QQSUMCNT | iSeries: Number of Executed SQL Statements | |
| 23 | Table/Structure Field |
SQHIST_DB4 - QQSRTTTIME | iSeries: Total Time Used by Sorts (Database Monitor) | |
| 24 | Table/Structure Field |
SQHIST_DB4 - QQSRTTOTR | iSeries: Total Rows Sorted (Database Monitor) | |
| 25 | Table/Structure Field |
SQHIST_DB4 - QQSRTCNT | iSeries: Number of Sorts (Database Monitor) | |
| 26 | Table/Structure Field |
SQHIST_DB4 - QQSELCNT | iSeries: Number of Executed SELECTs (Database Monitor) | |
| 27 | Table/Structure Field |
SQHIST_DB4 - QQRBKCNT | iSeries: Number of Executed ROLLBACKs (Database Monitor) | |
| 28 | Table/Structure Field |
SQHIST_DB4 - QQOTHCNT | iSeries: Number of Miscellaneous Statements | |
| 29 | Table/Structure Field |
SQHIST_DB4 - QQINSCNT | iSeries: Number of Executed INSERTs (Database Monitor) | |
| 30 | Table/Structure Field |
SQHIST_DB4 - QQIDCCNT | iSeries: Number of Index Creates (Database Monitor) | |
| 31 | Table/Structure Field |
SQHIST_DB4 - QQIDATBCNT | iSeries: Number of Tables over which Indexes are Advised | |
| 32 | Table/Structure Field |
SQHIST_DB4 - QQIDACNT | iSeries: Index Advice (Database Monitor) | |
| 33 | Table/Structure Field |
SQHIST_DB4 - QQDELCNT | iSeries: Number of Executed DELETEs (Database Monitor) | |
| 34 | Table/Structure Field |
SQHIST_DB4 - QQDDLCNT | iSeries: Number of Executed DDL Statements | |
| 35 | Table/Structure Field |
SQHIST_DB4 - QQCOMCNT | iSeries: No. of Executed COMMITs (Database Monitor) | |
| 36 | Table/Structure Field |
SYST - DATUM | ABAP System Field: Current Date of Application Server | |
| 37 | Table/Structure Field |
SYST - DBSYS | ABAP System Field: Central Database System | |
| 38 | Table/Structure Field |
SYST - MSGID | ABAP System Field: Message ID | |
| 39 | Table/Structure Field |
SYST - SYSID | ABAP System Field: Name of SAP System | |
| 40 | Table/Structure Field |
SYST - UZEIT | ABAP System Field: Current Time of Application Server |
