SAP SQHIST_DB4 table - iSeries: History Table for Database Performance Overview details in SAP

SAP SQHIST_DB4 table summary

Object Name: SQHIST_DB4
Dictionary Type: Structure
Description: iSeries: History Table for Database Performance Overview

Field list for SQHIST_DB4 table on an S/4 SAP system

Details

SQHIST_DB4-QQDMPTIME table field - iSeries: Timestamp of Database Monitor Dump ▼

Description: iSeries: Timestamp of Database Monitor Dump
Field Name: QQDMPTIME
Data Element: QQDMPTIME
Data Type: CHAR
length (Dec): 26(0)
Check table:
Conversion Routine:
Domain Name: QQTIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQDMPTIME

SQHIST_DB4-QQSUMCNT table field - iSeries: Number of Executed SQL Statements ▼

Description: iSeries: Number of Executed SQL Statements
Field Name: QQSUMCNT
Data Element: QQSUMCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQSUMCNT

SQHIST_DB4-QQCOMCNT table field - iSeries: No. of Executed COMMITs (Database Monitor) ▼

Description: iSeries: No. of Executed COMMITs (Database Monitor)
Field Name: QQCOMCNT
Data Element: QQCOMCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQCOMCNT

SQHIST_DB4-QQRBKCNT table field - iSeries: Number of Executed ROLLBACKs (Database Monitor) ▼

Description: iSeries: Number of Executed ROLLBACKs (Database Monitor)
Field Name: QQRBKCNT
Data Element: QQRBKCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQRBKCNT

SQHIST_DB4-QQSELCNT table field - iSeries: Number of Executed SELECTs (Database Monitor) ▼

Description: iSeries: Number of Executed SELECTs (Database Monitor)
Field Name: QQSELCNT
Data Element: QQSELCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQSELCNT

SQHIST_DB4-QQINSCNT table field - iSeries: Number of Executed INSERTs (Database Monitor) ▼

Description: iSeries: Number of Executed INSERTs (Database Monitor)
Field Name: QQINSCNT
Data Element: QQINSCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQINSCNT

SQHIST_DB4-QQUPDCNT table field - iSeries: Number of Executed UPDATEs (Database Monitor) ▼

Description: iSeries: Number of Executed UPDATEs (Database Monitor)
Field Name: QQUPDCNT
Data Element: QQUPDCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQUPDCNT

SQHIST_DB4-QQDELCNT table field - iSeries: Number of Executed DELETEs (Database Monitor) ▼

Description: iSeries: Number of Executed DELETEs (Database Monitor)
Field Name: QQDELCNT
Data Element: QQDELCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQDELCNT

SQHIST_DB4-QQDDLCNT table field - iSeries: Number of Executed DDL Statements ▼

Description: iSeries: Number of Executed DDL Statements
Field Name: QQDDLCNT
Data Element: QQDDLCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQDDLCNT

SQHIST_DB4-QQOTHCNT table field - iSeries: Number of Miscellaneous Statements ▼

Description: iSeries: Number of Miscellaneous Statements
Field Name: QQOTHCNT
Data Element: QQOTHCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQOTHCNT

SQHIST_DB4-QQTSCCNT table field - iSeries: Number of Table Scans ▼

Description: iSeries: Number of Table Scans
Field Name: QQTSCCNT
Data Element: QQTSCCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQTSCCNT

SQHIST_DB4-QQTSCTOTR table field - iSeries: Total Rows Read by Table Scans ▼

Description: iSeries: Total Rows Read by Table Scans
Field Name: QQTSCTOTR
Data Element: QQTSCTOTR
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQTSCTOTR

SQHIST_DB4-QQTSCTTIME table field - iSeries: Total Time Used by Table Scans ▼

Description: iSeries: Total Time Used by Table Scans
Field Name: QQTSCTTIME
Data Element: QQTSCTTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQTSCTTIME

SQHIST_DB4-QQSRTCNT table field - iSeries: Number of Sorts (Database Monitor) ▼

Description: iSeries: Number of Sorts (Database Monitor)
Field Name: QQSRTCNT
Data Element: QQSRTCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQSRTCNT

SQHIST_DB4-QQSRTTOTR table field - iSeries: Total Rows Sorted (Database Monitor) ▼

Description: iSeries: Total Rows Sorted (Database Monitor)
Field Name: QQSRTTOTR
Data Element: QQSRTTOTR
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQSRTTOTR

SQHIST_DB4-QQSRTTTIME table field - iSeries: Total Time Used by Sorts (Database Monitor) ▼

Description: iSeries: Total Time Used by Sorts (Database Monitor)
Field Name: QQSRTTTIME
Data Element: QQSRTTTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQSRTTTIME

SQHIST_DB4-QQIDCCNT table field - iSeries: Number of Index Creates (Database Monitor) ▼

Description: iSeries: Number of Index Creates (Database Monitor)
Field Name: QQIDCCNT
Data Element: QQIDCCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQIDCCNT

SQHIST_DB4-QQIDCTTIME table field - iSeries: Total Time Used by Index Creates (Database Monitor) ▼

Description: iSeries: Total Time Used by Index Creates (Database Monitor)
Field Name: QQIDCTTIME
Data Element: QQIDCTTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQIDCTTIME

SQHIST_DB4-QQTMFCNT table field - iSeries: Number of Temporary Files Created ▼

Description: iSeries: Number of Temporary Files Created
Field Name: QQTMFCNT
Data Element: QQTMFCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQTMFCNT

SQHIST_DB4-QQTMFTTIME table field - iSeries: Total Time Used by Temp. File Creates ▼

Description: iSeries: Total Time Used by Temp. File Creates
Field Name: QQTMFTTIME
Data Element: QQTMFTTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQTMFTTIME

SQHIST_DB4-QQIDACNT table field - iSeries: Index Advice (Database Monitor) ▼

Description: iSeries: Index Advice (Database Monitor)
Field Name: QQIDACNT
Data Element: QQIDACNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQIDACNT

SQHIST_DB4-QQIDATBCNT table field - iSeries: Number of Tables over which Indexes are Advised ▼

Description: iSeries: Number of Tables over which Indexes are Advised
Field Name: QQIDATBCNT
Data Element: QQIDATBCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQIDATBCNT

SQHIST_DB4-QQIDAQRYCT table field - iSeries: Number of Index Advices (Database Monitor) ▼

Description: iSeries: Number of Index Advices (Database Monitor)
Field Name: QQIDAQRYCT
Data Element: QQIDAQRYCT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQIDAQRYCT

SQHIST_DB4-QQODFTIME table field - iSeries: Timestamp of Oldest Data (Database Monitor) ▼

Description: iSeries: Timestamp of Oldest Data (Database Monitor)
Field Name: QQODFTIME
Data Element: QQODFTIME
Data Type: CHAR
length (Dec): 26(0)
Check table:
Conversion Routine:
Domain Name: QQTIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQODFTIME

SQHIST_DB4-QQTOTAVGT table field - iSeries: Overall Average Execution Time (Database Monitor) ▼

Description: iSeries: Overall Average Execution Time (Database Monitor)
Field Name: QQTOTAVGT
Data Element: QQTOTAVGT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQTOTAVGT

SQHIST_DB4-QQTOTTIME table field - iSeries: Total Database Processing Time (Database Monitor) ▼

Description: iSeries: Total Database Processing Time (Database Monitor)
Field Name: QQTOTTIME
Data Element: QQTDBTIME
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQTOTTIME

SQHIST_DB4-PHYSREAD table field - iSeries: Number of Physical Reads ▼

Description: iSeries: Number of Physical Reads
Field Name: PHYSREAD
Data Element: PHYSREAD
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PHYSREAD

SQHIST_DB4-LOGICREAD table field - iSeries: Number of Logical Reads ▼

Description: iSeries: Number of Logical Reads
Field Name: LOGICREAD
Data Element: LOGICREAD
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGICREAD

SQHIST_DB4-QUALITY table field - iSeries: Hit Ratio ▼

Description: iSeries: Hit Ratio
Field Name: QUALITY
Data Element: QUALITY
Data Type: DEC
length (Dec): 15(2)
Check table:
Conversion Routine:
Domain Name: QQDEC152
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QUALITY

SQHIST_DB4-READPCALL table field - iSeries: Number of Logical Reads per User Call ▼

Description: iSeries: Number of Logical Reads per User Call
Field Name: READPCALL
Data Element: READPCALL
Data Type: DEC
length (Dec): 15(2)
Check table:
Conversion Routine:
Domain Name: QQDEC152
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field READPCALL

SQHIST_DB4-TIMEPCALL table field - iSeries: Database Processing Time per User Call ▼

Description: iSeries: Database Processing Time per User Call
Field Name: TIMEPCALL
Data Element: TIMEPCALL
Data Type: DEC
length (Dec): 15(2)
Check table:
Conversion Routine:
Domain Name: QQDEC152
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIMEPCALL

View list of all SAP tables(S4H/ECC)

Select data from SAP table