Table/Structure Field list used by SAP ABAP Program RSDB4UPD (Update SAP Database Performance Tables (iSeries: Memory-Resid DBMon))
SAP ABAP Program 
RSDB4UPD (Update SAP Database Performance Tables (iSeries: Memory-Resid DBMon)) is using
-
Class (8)
-
Data Element (6)
-
Table/Structure Field (176)
-
Function Module (6)
-
Message Class (1)
-
Message Number (10)
-
Class Method (12)
-
Program (8)
-
Table (18)
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
DB4OX - INSTNAME | Server Name | |
| 2 | Table/Structure Field |
DB4OX - OBJNAME | Name of an ABAP Dictionary object | |
| 3 | Table/Structure Field |
DB4OX - UPTIME | Text field length 14 | |
| 4 | Table/Structure Field |
DD02L - TABNAME | Table Name | |
| 5 | Table/Structure Field |
QSYSINDEXS - NAME | iSeries: SQL index name | |
| 6 | Table/Structure Field |
QSYSINDEXS - SYS_DNAME | iSeries: iSeries system name of table/view schema | |
| 7 | Table/Structure Field |
QSYSINDEXS - SYS_IXNAME | iSeries: iSeries system index name | |
| 8 | Table/Structure Field |
QSYSTABLES - SYS_DNAME | iSeries: iSeries system name of table/view schema | |
| 9 | Table/Structure Field |
QSYSTABLES - SYS_TNAME | iSeries: iSeries system name of table or view | |
| 10 | Table/Structure Field |
QSYSTABLES - TBNAME | iSeries: SQL Name of Table or View | |
| 11 | Table/Structure Field |
SQ1000_DB4 - IPLTIME | Text field length 14 | |
| 12 | Table/Structure Field |
SQ1000_DB4 - QQARSS | iSeries: Average Result Set Size (Database Monitor) | |
| 13 | Table/Structure Field |
SQ1000_DB4 - QQAVGT | iSeries: Average Time (Database Monitor) | |
| 14 | Table/Structure Field |
SQ1000_DB4 - QQCAPR | iSeries: No of Access Plan Rebuilds (Database Monitor) | |
| 15 | Table/Structure Field |
SQ1000_DB4 - QQCIA | iSeries: Index Advice (Database Monitor) | |
| 16 | Table/Structure Field |
SQ1000_DB4 - QQCIC | iSeries: Number of Index Creates (Database Monitor) | |
| 17 | Table/Structure Field |
SQ1000_DB4 - QQCIU | iSeries: Index Usage (Database Monitor) | |
| 18 | Table/Structure Field |
SQ1000_DB4 - QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | |
| 19 | Table/Structure Field |
SQ1000_DB4 - QQCSO | iSeries: No. of Sorts (Database Monitor) | |
| 20 | Table/Structure Field |
SQ1000_DB4 - QQCTF | iSeries: No. of Temporaray File Creates (Database Monitor) | |
| 21 | Table/Structure Field |
SQ1000_DB4 - QQCTS | iSeries: Number of Table Scans (Database Monitor) | |
| 22 | Table/Structure Field |
SQ1000_DB4 - QQFULO | iSeries: Number of FULL OPENs (Database Monitor) | |
| 23 | Table/Structure Field |
SQ1000_DB4 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 24 | Table/Structure Field |
SQ1000_DB4 - QQPSUO | iSeries: Number of PSEUDO OPENs (Database Monitor) | |
| 25 | Table/Structure Field |
SQ1000_DB4 - QQSTF | iSeries: Statement Function (Database Monitor) | |
| 26 | Table/Structure Field |
SQ1000_DB4 - QQSTOP | iSeries: Statement Operation (Database Monitor) | |
| 27 | Table/Structure Field |
SQ1000_DB4 - QQTIME | iSeries: Record Creation Timestamp (Database Monitor) | |
| 28 | Table/Structure Field |
SQ1000_DB4 - QQTOTR | iSeries: Total Rows in Table (Database Monitor) | |
| 29 | Table/Structure Field |
SQ1000_DB4 - SYSID | Name of SAP System | |
| 30 | Table/Structure Field |
SQ1000_DB4 - TOTTIME | iSeries: Total Time (Database Monitor) | |
| 31 | Table/Structure Field |
SQ1000_RST - QQARSS | iSeries: Average Result Set Size (Database Monitor) | |
| 32 | Table/Structure Field |
SQ1000_RST - QQAVGT | iSeries: Average Time (Database Monitor) | |
| 33 | Table/Structure Field |
SQ1000_RST - QQCAPR | iSeries: No of Access Plan Rebuilds (Database Monitor) | |
| 34 | Table/Structure Field |
SQ1000_RST - QQCIA | iSeries: Index Advice (Database Monitor) | |
| 35 | Table/Structure Field |
SQ1000_RST - QQCIC | iSeries: Number of Index Creates (Database Monitor) | |
| 36 | Table/Structure Field |
SQ1000_RST - QQCIU | iSeries: Index Usage (Database Monitor) | |
| 37 | Table/Structure Field |
SQ1000_RST - QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | |
| 38 | Table/Structure Field |
SQ1000_RST - QQCSO | iSeries: No. of Sorts (Database Monitor) | |
| 39 | Table/Structure Field |
SQ1000_RST - QQCTF | iSeries: No. of Temporaray File Creates (Database Monitor) | |
| 40 | Table/Structure Field |
SQ1000_RST - QQCTS | iSeries: Number of Table Scans (Database Monitor) | |
| 41 | Table/Structure Field |
SQ1000_RST - QQFULO | iSeries: Number of FULL OPENs (Database Monitor) | |
| 42 | Table/Structure Field |
SQ1000_RST - QQMAXT | iSeries: Maximum Time (Database Monitor) | |
| 43 | Table/Structure Field |
SQ1000_RST - QQMINT | iSeries: Minimum Time (Database Monitor) | |
| 44 | Table/Structure Field |
SQ1000_RST - QQPSUO | iSeries: Number of PSEUDO OPENs (Database Monitor) | |
| 45 | Table/Structure Field |
SQ1000_RST - TOTTIME | iSeries: Total Time (Database Monitor) | |
| 46 | Table/Structure Field |
SQ3000_DB4 - IPLTIME | Text field length 14 | |
| 47 | Table/Structure Field |
SQ3000_DB4 - QQIDXD | iSeries: Definition of Advised Index (Database Monitor) | |
| 48 | Table/Structure Field |
SQ3000_DB4 - QQIDXD_LEN | 2 byte integer (signed) | |
| 49 | Table/Structure Field |
SQ3000_DB4 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 50 | Table/Structure Field |
SQ3000_DB4 - QQLPTF | iSeries: Base Table (Database Monitor) | |
| 51 | Table/Structure Field |
SQ3000_DB4 - QQLPTL | iSeries: Base Library (Database Monitor) | |
| 52 | Table/Structure Field |
SQ3000_DB4 - QQLTFN | iSeries: Table Name (Database Monitor) | |
| 53 | Table/Structure Field |
SQ3000_DB4 - QQLTLN | iSeries: Library Name (Database Monitor) | |
| 54 | Table/Structure Field |
SQ3000_DB4 - QQPTFN | iSeries: System Name of Base Table (Database Monitor) | |
| 55 | Table/Structure Field |
SQ3000_DB4 - QQPTLN | iSeries: System Name of Base Library (Database Monitor) | |
| 56 | Table/Structure Field |
SQ3000_DB4 - QQTFN | iSeries: System Name of Table (Database Monitor) | |
| 57 | Table/Structure Field |
SQ3000_DB4 - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 58 | Table/Structure Field |
SQ3000_DB4 - SYSID | Name of SAP System | |
| 59 | Table/Structure Field |
SQ3001_DB4 - IPLTIME | Text field length 14 | |
| 60 | Table/Structure Field |
SQ3001_DB4 - QQCST | iSeries: Constraint Used (Y/N) (Database Monitor) | |
| 61 | Table/Structure Field |
SQ3001_DB4 - QQCSTN | iSeries: Constraint Name (Database Monitor) | |
| 62 | Table/Structure Field |
SQ3001_DB4 - QQIDXD | iSeries: Definition of Advised Index (Database Monitor) | |
| 63 | Table/Structure Field |
SQ3001_DB4 - QQIDXD_LEN | 2 byte integer (signed) | |
| 64 | Table/Structure Field |
SQ3001_DB4 - QQIFNM | iSeries: System Name of Index (Database Monitor) | |
| 65 | Table/Structure Field |
SQ3001_DB4 - QQILNM | iSeries: System Name of Index Library (Database Monitor) | |
| 66 | Table/Structure Field |
SQ3001_DB4 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 67 | Table/Structure Field |
SQ3001_DB4 - QQLIFN | iSeries: Index Name (Database Monitor) | |
| 68 | Table/Structure Field |
SQ3001_DB4 - QQLILN | iSeries: Index Library (Database Monitor) | |
| 69 | Table/Structure Field |
SQ3001_DB4 - QQLPTF | iSeries: Base Table (Database Monitor) | |
| 70 | Table/Structure Field |
SQ3001_DB4 - QQLPTL | iSeries: Base Library (Database Monitor) | |
| 71 | Table/Structure Field |
SQ3001_DB4 - QQLTFN | iSeries: Table Name (Database Monitor) | |
| 72 | Table/Structure Field |
SQ3001_DB4 - QQLTLN | iSeries: Library Name (Database Monitor) | |
| 73 | Table/Structure Field |
SQ3001_DB4 - QQPTFN | iSeries: System Name of Base Table (Database Monitor) | |
| 74 | Table/Structure Field |
SQ3001_DB4 - QQPTLN | iSeries: System Name of Base Library (Database Monitor) | |
| 75 | Table/Structure Field |
SQ3001_DB4 - QQTFN | iSeries: System Name of Table (Database Monitor) | |
| 76 | Table/Structure Field |
SQ3001_DB4 - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 77 | Table/Structure Field |
SQ3001_DB4 - SYSID | Name of SAP System | |
| 78 | Table/Structure Field |
SQ3002_DB4 - IPLTIME | Text field length 14 | |
| 79 | Table/Structure Field |
SQ3002_DB4 - QQCRTK | iSeries: Key Fields of Created Index (Database Monitor) | |
| 80 | Table/Structure Field |
SQ3002_DB4 - QQCRTK_LEN | 2 byte integer (signed) | |
| 81 | Table/Structure Field |
SQ3002_DB4 - QQIFNM | iSeries: System Name of Index (Database Monitor) | |
| 82 | Table/Structure Field |
SQ3002_DB4 - QQILNM | iSeries: System Name of Index Library (Database Monitor) | |
| 83 | Table/Structure Field |
SQ3002_DB4 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 84 | Table/Structure Field |
SQ3002_DB4 - QQLIFN | iSeries: Index Name (Database Monitor) | |
| 85 | Table/Structure Field |
SQ3002_DB4 - QQLILN | iSeries: Index Library (Database Monitor) | |
| 86 | Table/Structure Field |
SQ3002_DB4 - QQLNLN | iSeries: NLSS Library (Database Monitor) | |
| 87 | Table/Structure Field |
SQ3002_DB4 - QQLNTN | iSeries: NLSS Table (Database Monitor) | |
| 88 | Table/Structure Field |
SQ3002_DB4 - QQLPTF | iSeries: Base Table (Database Monitor) | |
| 89 | Table/Structure Field |
SQ3002_DB4 - QQLPTL | iSeries: Base Library (Database Monitor) | |
| 90 | Table/Structure Field |
SQ3002_DB4 - QQLTFN | iSeries: Table Name (Database Monitor) | |
| 91 | Table/Structure Field |
SQ3002_DB4 - QQLTLN | iSeries: Library Name (Database Monitor) | |
| 92 | Table/Structure Field |
SQ3002_DB4 - QQNLNM | iSeries: System Name of NLSS Library (Database Monitor) | |
| 93 | Table/Structure Field |
SQ3002_DB4 - QQNTNM | iSeries: System Name of NLSS Table (Database Monitor) | |
| 94 | Table/Structure Field |
SQ3002_DB4 - QQPTFN | iSeries: System Name of Base Table (Database Monitor) | |
| 95 | Table/Structure Field |
SQ3002_DB4 - QQPTLN | iSeries: System Name of Base Library (Database Monitor) | |
| 96 | Table/Structure Field |
SQ3002_DB4 - QQTFN | iSeries: System Name of Table (Database Monitor) | |
| 97 | Table/Structure Field |
SQ3002_DB4 - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 98 | Table/Structure Field |
SQ3002_DB4 - QQTTIM | iSeries: Time for Index Create (Database Monitor) | |
| 99 | Table/Structure Field |
SQ3002_DB4 - SYSID | Name of SAP System | |
| 100 | Table/Structure Field |
SQ3003_DB4 - IPLTIME | Text field length 14 | |
| 101 | Table/Structure Field |
SQ3003_DB4 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 102 | Table/Structure Field |
SQ3003_DB4 - QQTTIM | iSeries: Sort Time (Database Monitor) | |
| 103 | Table/Structure Field |
SQ3003_DB4 - SYSID | Name of SAP System | |
| 104 | Table/Structure Field |
SQ3004_DB4 - IPLTIME | Text field length 14 | |
| 105 | Table/Structure Field |
SQ3004_DB4 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 106 | Table/Structure Field |
SQ3004_DB4 - QQLTFN | iSeries: Table Name (Database Monitor) | |
| 107 | Table/Structure Field |
SQ3004_DB4 - QQLTLN | iSeries: Library Name (Database Monitor) | |
| 108 | Table/Structure Field |
SQ3004_DB4 - QQTFN | iSeries: System Name of Table (Database Monitor) | |
| 109 | Table/Structure Field |
SQ3004_DB4 - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 110 | Table/Structure Field |
SQ3004_DB4 - QQTTIM | iSeries: Create Time of Temporary Table (Database Monitor) | |
| 111 | Table/Structure Field |
SQ3004_DB4 - SYSID | Name of SAP System | |
| 112 | Table/Structure Field |
SQ3007_DB4 - IPLTIME | Text field length 14 | |
| 113 | Table/Structure Field |
SQ3007_DB4 - QQIDXN | iSeries: Indexes (Database Monitor) | |
| 114 | Table/Structure Field |
SQ3007_DB4 - QQIDXN_LEN | 2 byte integer (signed) | |
| 115 | Table/Structure Field |
SQ3007_DB4 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 116 | Table/Structure Field |
SQ3007_DB4 - QQLPTF | iSeries: Base Table (Database Monitor) | |
| 117 | Table/Structure Field |
SQ3007_DB4 - QQLPTL | iSeries: Base Library (Database Monitor) | |
| 118 | Table/Structure Field |
SQ3007_DB4 - QQLTFN | iSeries: Table Name (Database Monitor) | |
| 119 | Table/Structure Field |
SQ3007_DB4 - QQLTLN | iSeries: Library Name (Database Monitor) | |
| 120 | Table/Structure Field |
SQ3007_DB4 - QQPTFN | iSeries: System Name of Base Table (Database Monitor) | |
| 121 | Table/Structure Field |
SQ3007_DB4 - QQPTLN | iSeries: System Name of Base Library (Database Monitor) | |
| 122 | Table/Structure Field |
SQ3007_DB4 - QQTFN | iSeries: System Name of Table (Database Monitor) | |
| 123 | Table/Structure Field |
SQ3007_DB4 - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 124 | Table/Structure Field |
SQ3007_DB4 - SYSID | Name of SAP System | |
| 125 | Table/Structure Field |
SQ3008_DB4 - IPLTIME | Text field length 14 | |
| 126 | Table/Structure Field |
SQ3008_DB4 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 127 | Table/Structure Field |
SQ3008_DB4 - SYSID | Name of SAP System | |
| 128 | Table/Structure Field |
SQHIST_DB4 - QQCOMCNT | iSeries: No. of Executed COMMITs (Database Monitor) | |
| 129 | Table/Structure Field |
SQHIST_DB4 - QQDDLCNT | iSeries: Number of Executed DDL Statements | |
| 130 | Table/Structure Field |
SQHIST_DB4 - QQDELCNT | iSeries: Number of Executed DELETEs (Database Monitor) | |
| 131 | Table/Structure Field |
SQHIST_DB4 - QQDMPTIME | iSeries: Timestamp of Database Monitor Dump | |
| 132 | Table/Structure Field |
SQHIST_DB4 - QQIDACNT | iSeries: Index Advice (Database Monitor) | |
| 133 | Table/Structure Field |
SQHIST_DB4 - QQIDATBCNT | iSeries: Number of Tables over which Indexes are Advised | |
| 134 | Table/Structure Field |
SQHIST_DB4 - QQIDCCNT | iSeries: Number of Index Creates (Database Monitor) | |
| 135 | Table/Structure Field |
SQHIST_DB4 - QQIDCTTIME | iSeries: Total Time Used by Index Creates (Database Monitor) | |
| 136 | Table/Structure Field |
SQHIST_DB4 - QQINSCNT | iSeries: Number of Executed INSERTs (Database Monitor) | |
| 137 | Table/Structure Field |
SQHIST_DB4 - QQODFTIME | iSeries: Timestamp of Oldest Data (Database Monitor) | |
| 138 | Table/Structure Field |
SQHIST_DB4 - QQOTHCNT | iSeries: Number of Miscellaneous Statements | |
| 139 | Table/Structure Field |
SQHIST_DB4 - QQRBKCNT | iSeries: Number of Executed ROLLBACKs (Database Monitor) | |
| 140 | Table/Structure Field |
SQHIST_DB4 - QQSELCNT | iSeries: Number of Executed SELECTs (Database Monitor) | |
| 141 | Table/Structure Field |
SQHIST_DB4 - QQSRTCNT | iSeries: Number of Sorts (Database Monitor) | |
| 142 | Table/Structure Field |
SQHIST_DB4 - QQSRTTOTR | iSeries: Total Rows Sorted (Database Monitor) | |
| 143 | Table/Structure Field |
SQHIST_DB4 - QQSRTTTIME | iSeries: Total Time Used by Sorts (Database Monitor) | |
| 144 | Table/Structure Field |
SQHIST_DB4 - QQSUMCNT | iSeries: Number of Executed SQL Statements | |
| 145 | Table/Structure Field |
SQHIST_DB4 - QQTMFCNT | iSeries: Number of Temporary Files Created | |
| 146 | Table/Structure Field |
SQHIST_DB4 - QQTMFTTIME | iSeries: Total Time Used by Temp. File Creates | |
| 147 | Table/Structure Field |
SQHIST_DB4 - QQTOTAVGT | iSeries: Overall Average Execution Time (Database Monitor) | |
| 148 | Table/Structure Field |
SQHIST_DB4 - QQTSCCNT | iSeries: Number of Table Scans | |
| 149 | Table/Structure Field |
SQHIST_DB4 - QQTSCTOTR | iSeries: Total Rows Read by Table Scans | |
| 150 | Table/Structure Field |
SQHIST_DB4 - QQTSCTTIME | iSeries: Total Time Used by Table Scans | |
| 151 | Table/Structure Field |
SQHIST_DB4 - QQUPDCNT | iSeries: Number of Executed UPDATEs (Database Monitor) | |
| 152 | Table/Structure Field |
SQHVAR_DB4 - IPLTIME | Text field length 14 | |
| 153 | Table/Structure Field |
SQHVAR_DB4 - QQHVAR | iSeries: Host Variable Values (Database Monitor) | |
| 154 | Table/Structure Field |
SQHVAR_DB4 - QQHVAR_LEN | 2 byte integer (signed) | |
| 155 | Table/Structure Field |
SQHVAR_DB4 - SYSID | Name of SAP System | |
| 156 | Table/Structure Field |
SQLTABLE_DB4_T - QQKEY | iSeries: Key Field (Database Monitor) | |
| 157 | Table/Structure Field |
SQLTABLE_DB4_T - TABNAME | Table Name | |
| 158 | Table/Structure Field |
SQTEXT_DB4 - IPLTIME | Text field length 14 | |
| 159 | Table/Structure Field |
SQTEXT_DB4 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 160 | Table/Structure Field |
SQTEXT_DB4 - QQSTTX | iSeries: Statement Text (Database Monitor) | |
| 161 | Table/Structure Field |
SQTEXT_DB4 - QQSTTX_LNG | 2 byte integer (signed) | |
| 162 | Table/Structure Field |
SQTEXT_DB4 - SYSID | Name of SAP System | |
| 163 | Table/Structure Field |
SYST - BATCH | ABAP System Field: Background Processing Active | |
| 164 | Table/Structure Field |
SYST - DATUM | ABAP System Field: Current Date of Application Server | |
| 165 | Table/Structure Field |
SYST - DBCNT | ABAP System Field: Edited Database Table Rows | |
| 166 | Table/Structure Field |
SYST - DBSYS | ABAP System Field: Central Database System | |
| 167 | Table/Structure Field |
SYST - MSGID | ABAP System Field: Message ID | |
| 168 | Table/Structure Field |
SYST - MSGNO | ABAP System Field: Message Number | |
| 169 | Table/Structure Field |
SYST - MSGTY | ABAP System Field: Message Type | |
| 170 | Table/Structure Field |
SYST - MSGV1 | ABAP System Field: Message Variable | |
| 171 | Table/Structure Field |
SYST - MSGV2 | ABAP System Field: Message Variable | |
| 172 | Table/Structure Field |
SYST - MSGV3 | ABAP System Field: Message Variable | |
| 173 | Table/Structure Field |
SYST - MSGV4 | ABAP System Field: Message Variable | |
| 174 | Table/Structure Field |
SYST - SYSID | ABAP System Field: Name of SAP System | |
| 175 | Table/Structure Field |
SYST - TABIX | ABAP System Field: Row Index of Internal Tables | |
| 176 | Table/Structure Field |
SYST - UZEIT | ABAP System Field: Current Time of Application Server |
