Data Element list used by SAP ABAP Table SQHIST_DB4 (iSeries: History Table for Database Performance Overview)
SAP ABAP Table 
SQHIST_DB4 (iSeries: History Table for Database Performance Overview) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
LOGICREAD | iSeries: Number of Logical Reads | |
| 2 | Data Element |
PHYSREAD | iSeries: Number of Physical Reads | |
| 3 | Data Element |
QQCOMCNT | iSeries: No. of Executed COMMITs (Database Monitor) | |
| 4 | Data Element |
QQDDLCNT | iSeries: Number of Executed DDL Statements | |
| 5 | Data Element |
QQDELCNT | iSeries: Number of Executed DELETEs (Database Monitor) | |
| 6 | Data Element |
QQDMPTIME | iSeries: Timestamp of Database Monitor Dump | |
| 7 | Data Element |
QQIDACNT | iSeries: Index Advice (Database Monitor) | |
| 8 | Data Element |
QQIDAQRYCT | iSeries: Number of Index Advices (Database Monitor) | |
| 9 | Data Element |
QQIDATBCNT | iSeries: Number of Tables over which Indexes are Advised | |
| 10 | Data Element |
QQIDCCNT | iSeries: Number of Index Creates (Database Monitor) | |
| 11 | Data Element |
QQIDCTTIME | iSeries: Total Time Used by Index Creates (Database Monitor) | |
| 12 | Data Element |
QQINSCNT | iSeries: Number of Executed INSERTs (Database Monitor) | |
| 13 | Data Element |
QQODFTIME | iSeries: Timestamp of Oldest Data (Database Monitor) | |
| 14 | Data Element |
QQOTHCNT | iSeries: Number of Miscellaneous Statements | |
| 15 | Data Element |
QQRBKCNT | iSeries: Number of Executed ROLLBACKs (Database Monitor) | |
| 16 | Data Element |
QQSELCNT | iSeries: Number of Executed SELECTs (Database Monitor) | |
| 17 | Data Element |
QQSRTCNT | iSeries: Number of Sorts (Database Monitor) | |
| 18 | Data Element |
QQSRTTOTR | iSeries: Total Rows Sorted (Database Monitor) | |
| 19 | Data Element |
QQSRTTTIME | iSeries: Total Time Used by Sorts (Database Monitor) | |
| 20 | Data Element |
QQSUMCNT | iSeries: Number of Executed SQL Statements | |
| 21 | Data Element |
QQTDBTIME | iSeries: Total Database Processing Time (Database Monitor) | |
| 22 | Data Element |
QQTMFCNT | iSeries: Number of Temporary Files Created | |
| 23 | Data Element |
QQTMFTTIME | iSeries: Total Time Used by Temp. File Creates | |
| 24 | Data Element |
QQTOTAVGT | iSeries: Overall Average Execution Time (Database Monitor) | |
| 25 | Data Element |
QQTSCCNT | iSeries: Number of Table Scans | |
| 26 | Data Element |
QQTSCTOTR | iSeries: Total Rows Read by Table Scans | |
| 27 | Data Element |
QQTSCTTIME | iSeries: Total Time Used by Table Scans | |
| 28 | Data Element |
QQUPDCNT | iSeries: Number of Executed UPDATEs (Database Monitor) | |
| 29 | Data Element |
QUALITY | iSeries: Hit Ratio | |
| 30 | Data Element |
READPCALL | iSeries: Number of Logical Reads per User Call | |
| 31 | Data Element |
TIMEPCALL | iSeries: Database Processing Time per User Call |
