SAP DB4SRT0100 table - iSeries Database Performance: Sorts details in SAP

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

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

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

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

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

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

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

Description: iSeries: No. of Sorts (Database Monitor)
Field Name: QQCSO
Data Element: QQCSO
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 QQCSO

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

Description: iSeries: No. of Rows Selected or Sorted (Database Monitor)
Field Name: QQRSS
Data Element: QQRSS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQROWS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQRSS

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

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

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

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

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

Description: iSeries: Sort Size (Database Monitor)
Field Name: QQSSIZ
Data Element: QQSSIZ
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 QQSSIZ

Description: iSeries: Pool Size (Database Monitor)
Field Name: QQPSIZ
Data Element: QQPSIZ
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 QQPSIZ

Description: iSeries: Pool ID (Database Monitor)
Field Name: QQPID
Data Element: QQPID
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 QQPID

Description: iSeries: Reason Code (Database Monitor)
Field Name: QQRCOD
Data Element: QQRCODSRT
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: QQRCOD
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQRCOD

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

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

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