SAP DB4SQR0100 table - iSeries Database Performance: SQL Requests/Top 50 details in SAP

SAP DB4SQR0100 table summary

Object Name: DB4SQR0100
Dictionary Type: Structure
Description: iSeries Database Performance: SQL Requests/Top 50

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

Details

DB4SQR0100-SYSID table field - Name of SAP System ▼

Description: Name of SAP System
Field Name: SYSID
Data Element: SYSYSID
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: SYCHAR08
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SYSID

DB4SQR0100-IPLTIME table field - Text field length 14 ▼

Description: Text field length 14
Field Name: IPLTIME
Data Element: CHAR14
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: CHAR14
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IPLTIME

DB4SQR0100-QQKEY table field - iSeries: Key Field (Database Monitor) ▼

Description: iSeries: Key Field (Database Monitor)
Field Name: QQKEY
Data Element: QQKEY
Data Type: CHAR
length (Dec): 17(0)
Check table:
Conversion Routine:
Domain Name: QQKEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQKEY

DB4SQR0100-QQPLIB table field - iSeries: Package/Program Library (Database Monitor) ▼

Description: iSeries: Package/Program Library (Database Monitor)
Field Name: QQPLIB
Data Element: QQPLIB
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQC10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQPLIB

DB4SQR0100-QQPNAM table field - iSeries: Package/Program Name (Database Monitor) ▼

Description: iSeries: Package/Program Name (Database Monitor)
Field Name: QQPNAM
Data Element: QQPNAM
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQC10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQPNAM

DB4SQR0100-QQSNAM table field - iSeries: Statement Name (Database Monitor) ▼

Description: iSeries: Statement Name (Database Monitor)
Field Name: QQSNAM
Data Element: QQSNAM
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: QQC18
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQSNAM

DB4SQR0100-QQCNAM table field - iSeries: Cursor Name (Database Monitor) ▼

Description: iSeries: Cursor Name (Database Monitor)
Field Name: QQCNAM
Data Element: QQCNAM
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: QQC18
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQCNAM

DB4SQR0100-QQSTF table field - iSeries: Statement Function (Database Monitor) ▼

Description: iSeries: Statement Function (Database Monitor)
Field Name: QQSTF
Data Element: QQSTF
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: QQSTF
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQSTF

DB4SQR0100-TOTTIME table field - iSeries: Total Time (Database Monitor) ▼

Description: iSeries: Total Time (Database Monitor)
Field Name: TOTTIME
Data Element: TOTTIME
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 TOTTIME

DB4SQR0100-QQCNT table field - iSeries: No. of Executions of a Statement (Database Monitor) ▼

Description: iSeries: No. of Executions of a Statement (Database Monitor)
Field Name: QQCNT
Data Element: QQCNT
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 QQCNT

DB4SQR0100-QQARSS table field - iSeries: Average Result Set Size (Database Monitor) ▼

Description: iSeries: Average Result Set Size (Database Monitor)
Field Name: QQARSS
Data Element: QQARSS
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 QQARSS

DB4SQR0100-QQAVGT table field - iSeries: Average Time (Database Monitor) ▼

Description: iSeries: Average Time (Database Monitor)
Field Name: QQAVGT
Data Element: QQAVGT
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 QQAVGT

DB4SQR0100-QQMINT table field - iSeries: Minimum Time (Database Monitor) ▼

Description: iSeries: Minimum Time (Database Monitor)
Field Name: QQMINT
Data Element: QQMINT
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 QQMINT

DB4SQR0100-QQMAXT table field - iSeries: Maximum Time (Database Monitor) ▼

Description: iSeries: Maximum Time (Database Monitor)
Field Name: QQMAXT
Data Element: QQMAXT
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 QQMAXT

DB4SQR0100-QQOPNT table field - iSeries: Open time (Database Monitor) ▼

Description: iSeries: Open time (Database Monitor)
Field Name: QQOPNT
Data Element: QQOPNT
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 QQOPNT

DB4SQR0100-QQFETT table field - iSeries: FETCH time (Database Monitor) ▼

Description: iSeries: FETCH time (Database Monitor)
Field Name: QQFETT
Data Element: QQFETT
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 QQFETT

DB4SQR0100-QQCLST table field - iSeries: CLOSE time (Database Monitor) ▼

Description: iSeries: CLOSE time (Database Monitor)
Field Name: QQCLST
Data Element: QQCLST
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 QQCLST

DB4SQR0100-QQOTHT table field - iSeries: Any other time (Database Monitor) ▼

Description: iSeries: Any other time (Database Monitor)
Field Name: QQOTHT
Data Element: QQOTHT
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 QQOTHT

DB4SQR0100-QQLTU table field - iSeries: Time Last Used (Database Monitor) ▼

Description: iSeries: Time Last Used (Database Monitor)
Field Name: QQLTU
Data Element: QQLTU
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 QQLTU

DB4SQR0100-QQMETU table field - iSeries: Timest. of Most Expensive Stmt. (Database Monitor) ▼

Description: iSeries: Timest. of Most Expensive Stmt. (Database Monitor)
Field Name: QQMETU
Data Element: QQMETU
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 QQMETU

DB4SQR0100-PFILE table field - iSeries: Table Name (Database Monitor) ▼

Description: iSeries: Table Name (Database Monitor)
Field Name: PFILE
Data Element: PFILE
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TABNAME
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PFILE

DB4SQR0100-QQSTTX_LEN table field - 2 Byte Signed Integer ▼

Description: 2 Byte Signed Integer
Field Name: QQSTTX_LEN
Data Element: INT2
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQSTTX_LEN

DB4SQR0100-QQSTTX table field - iSeries: Statement Text (Database Monitor) ▼

Description: iSeries: Statement Text (Database Monitor)
Field Name: QQSTTX
Data Element: QQSTTX
Data Type: LCHR
length (Dec): 8000(0)
Check table:
Conversion Routine:
Domain Name: QQLCHR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQSTTX

DB4SQR0100-QQUSER table field - iSeries: Job User (Database Monitor) ▼

Description: iSeries: Job User (Database Monitor)
Field Name: QQUSER
Data Element: QQUSER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQUSER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQUSER

View list of all SAP tables(S4H/ECC)

Select data from SAP table