SAP ABAP Table SQHIST_DB4 (iSeries: History Table for Database Performance Overview)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Table Category	INTTAB	Structure
Structure	SQHIST_DB4	Table Relationship Diagram
Short Description	iSeries: History Table for Database Performance Overview

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	QQDMPTIME	☑	QQDMPTIME	QQTIME	CHAR	26	0	iSeries: Timestamp of Database Monitor Dump
2	QQSUMCNT	☐	QQSUMCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed SQL Statements
3	QQCOMCNT	☐	QQCOMCNT	QQDEC150	DEC	15	0	iSeries: No. of Executed COMMITs (Database Monitor)
4	QQRBKCNT	☐	QQRBKCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed ROLLBACKs (Database Monitor)
5	QQSELCNT	☐	QQSELCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed SELECTs (Database Monitor)
6	QQINSCNT	☐	QQINSCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed INSERTs (Database Monitor)
7	QQUPDCNT	☐	QQUPDCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed UPDATEs (Database Monitor)
8	QQDELCNT	☐	QQDELCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed DELETEs (Database Monitor)
9	QQDDLCNT	☐	QQDDLCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed DDL Statements
10	QQOTHCNT	☐	QQOTHCNT	QQDEC150	DEC	15	0	iSeries: Number of Miscellaneous Statements
11	QQTSCCNT	☐	QQTSCCNT	QQDEC150	DEC	15	0	iSeries: Number of Table Scans
12	QQTSCTOTR	☐	QQTSCTOTR	QQDEC150	DEC	15	0	iSeries: Total Rows Read by Table Scans
13	QQTSCTTIME	☐	QQTSCTTIME		DEC	31	6	iSeries: Total Time Used by Table Scans
14	QQSRTCNT	☐	QQSRTCNT	QQDEC150	DEC	15	0	iSeries: Number of Sorts (Database Monitor)
15	QQSRTTOTR	☐	QQSRTTOTR	QQDEC150	DEC	15	0	iSeries: Total Rows Sorted (Database Monitor)
16	QQSRTTTIME	☐	QQSRTTTIME		DEC	31	6	iSeries: Total Time Used by Sorts (Database Monitor)
17	QQIDCCNT	☐	QQIDCCNT	QQDEC150	DEC	15	0	iSeries: Number of Index Creates (Database Monitor)
18	QQIDCTTIME	☐	QQIDCTTIME		DEC	31	6	iSeries: Total Time Used by Index Creates (Database Monitor)
19	QQTMFCNT	☐	QQTMFCNT	QQDEC150	DEC	15	0	iSeries: Number of Temporary Files Created
20	QQTMFTTIME	☐	QQTMFTTIME		DEC	31	6	iSeries: Total Time Used by Temp. File Creates
21	QQIDACNT	☐	QQIDACNT	QQDEC150	DEC	15	0	iSeries: Index Advice (Database Monitor)
22	QQIDATBCNT	☐	QQIDATBCNT	QQDEC150	DEC	15	0	iSeries: Number of Tables over which Indexes are Advised
23	QQIDAQRYCT	☐	QQIDAQRYCT	QQDEC150	DEC	15	0	iSeries: Number of Index Advices (Database Monitor)
24	QQODFTIME	☐	QQODFTIME	QQTIME	CHAR	26	0	iSeries: Timestamp of Oldest Data (Database Monitor)
25	QQTOTAVGT	☐	QQTOTAVGT	QQDEC150	DEC	15	0	iSeries: Overall Average Execution Time (Database Monitor)
26	QQTOTTIME	☐	QQTDBTIME	QQDEC150	DEC	15	0	iSeries: Total Database Processing Time (Database Monitor)
27	PHYSREAD	☐	PHYSREAD	QQDEC150	DEC	15	0	iSeries: Number of Physical Reads
28	LOGICREAD	☐	LOGICREAD	QQDEC150	DEC	15	0	iSeries: Number of Logical Reads
29	QUALITY	☐	QUALITY	QQDEC152	DEC	15	2	iSeries: Hit Ratio
30	READPCALL	☐	READPCALL	QQDEC152	DEC	15	2	iSeries: Number of Logical Reads per User Call
31	TIMEPCALL	☐	TIMEPCALL	QQDEC152	DEC	15	2	iSeries: Database Processing Time per User Call

History

Last changed by/on	SAP	20070813
SAP Release Created in