SQHIST_DB4 SAP (iSeries: History Table for Database Performance Overview) Structure details
Description: iSeries: History Table for Database Performance Overview
Structure field list including key, data, relationships and ABAP select examples
SQHIST_DB4 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "iSeries: History Table for Database Performance Overview" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_SQHIST_DB4 TYPE SQHIST_DB4.
The SQHIST_DB4 table consists of various fields, each holding specific information or linking keys about iSeries: History Table for Database Performance Overview data available in SAP. These include QQSUMCNT (iSeries: Number of Executed SQL Statements), QQCOMCNT (iSeries: No. of Executed COMMITs (Database Monitor)), QQRBKCNT (iSeries: Number of Executed ROLLBACKs (Database Monitor)), QQSELCNT (iSeries: Number of Executed SELECTs (Database Monitor)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP SQHIST_DB4 structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
QQDMPTIME | iSeries: Timestamp of Database Monitor Dump | QQDMPTIME | CHAR | 26 | QQTIME | ||||
QQSUMCNT | iSeries: Number of Executed SQL Statements | QQSUMCNT | DEC | 15 | QQDEC150 | ||||
QQCOMCNT | iSeries: No. of Executed COMMITs (Database Monitor) | QQCOMCNT | DEC | 15 | QQDEC150 | ||||
QQRBKCNT | iSeries: Number of Executed ROLLBACKs (Database Monitor) | QQRBKCNT | DEC | 15 | QQDEC150 | ||||
QQSELCNT | iSeries: Number of Executed SELECTs (Database Monitor) | QQSELCNT | DEC | 15 | QQDEC150 | ||||
QQINSCNT | iSeries: Number of Executed INSERTs (Database Monitor) | QQINSCNT | DEC | 15 | QQDEC150 | ||||
QQUPDCNT | iSeries: Number of Executed UPDATEs (Database Monitor) | QQUPDCNT | DEC | 15 | QQDEC150 | ||||
QQDELCNT | iSeries: Number of Executed DELETEs (Database Monitor) | QQDELCNT | DEC | 15 | QQDEC150 | ||||
QQDDLCNT | iSeries: Number of Executed DDL Statements | QQDDLCNT | DEC | 15 | QQDEC150 | ||||
QQOTHCNT | iSeries: Number of Miscellaneous Statements | QQOTHCNT | DEC | 15 | QQDEC150 | ||||
QQTSCCNT | iSeries: Number of Table Scans | QQTSCCNT | DEC | 15 | QQDEC150 | ||||
QQTSCTOTR | iSeries: Total Rows Read by Table Scans | QQTSCTOTR | DEC | 15 | QQDEC150 | ||||
QQTSCTTIME | iSeries: Total Time Used by Table Scans | QQTSCTTIME | DEC | 31(6) | |||||
QQSRTCNT | iSeries: Number of Sorts (Database Monitor) | QQSRTCNT | DEC | 15 | QQDEC150 | ||||
QQSRTTOTR | iSeries: Total Rows Sorted (Database Monitor) | QQSRTTOTR | DEC | 15 | QQDEC150 | ||||
QQSRTTTIME | iSeries: Total Time Used by Sorts (Database Monitor) | QQSRTTTIME | DEC | 31(6) | |||||
QQIDCCNT | iSeries: Number of Index Creates (Database Monitor) | QQIDCCNT | DEC | 15 | QQDEC150 | ||||
QQIDCTTIME | iSeries: Total Time Used by Index Creates (Database Monitor) | QQIDCTTIME | DEC | 31(6) | |||||
QQTMFCNT | iSeries: Number of Temporary Files Created | QQTMFCNT | DEC | 15 | QQDEC150 | ||||
QQTMFTTIME | iSeries: Total Time Used by Temp. File Creates | QQTMFTTIME | DEC | 31(6) | |||||
QQIDACNT | iSeries: Index Advice (Database Monitor) | QQIDACNT | DEC | 15 | QQDEC150 | ||||
QQIDATBCNT | iSeries: Number of Tables over which Indexes are Advised | QQIDATBCNT | DEC | 15 | QQDEC150 | ||||
QQIDAQRYCT | iSeries: Number of Index Advices (Database Monitor) | QQIDAQRYCT | DEC | 15 | QQDEC150 | ||||
QQODFTIME | iSeries: Timestamp of Oldest Data (Database Monitor) | QQODFTIME | CHAR | 26 | QQTIME | ||||
QQTOTAVGT | iSeries: Overall Average Execution Time (Database Monitor) | QQTOTAVGT | DEC | 15 | QQDEC150 | ||||
QQTOTTIME | iSeries: Total Database Processing Time (Database Monitor) | QQTDBTIME | DEC | 15 | QQDEC150 | ||||
PHYSREAD | iSeries: Number of Physical Reads | PHYSREAD | DEC | 15 | QQDEC150 | ||||
LOGICREAD | iSeries: Number of Logical Reads | LOGICREAD | DEC | 15 | QQDEC150 | ||||
QUALITY | iSeries: Hit Ratio | QUALITY | DEC | 15(2) | QQDEC152 | ||||
READPCALL | iSeries: Number of Logical Reads per User Call | READPCALL | DEC | 15(2) | QQDEC152 | ||||
TIMEPCALL | iSeries: Database Processing Time per User Call | TIMEPCALL | DEC | 15(2) | QQDEC152 |
Key field | Non-key field |
How do I retrieve data from SAP structure SQHIST_DB4 using ABAP code?
As SQHIST_DB4 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SQHIST_DB4 as there is no data to select.How to access SAP table SQHIST_DB4
Within an ECC or HANA version of SAP you can also view further information about SQHIST_DB4 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects