SAP DB2QDSCCONT table - Structure describing content of dynamic statement cache details in SAP


SAP DB2QDSCCONT table summary

Object Name: DB2QDSCCONT
Dictionary Type: Structure
Description: Structure describing content of dynamic statement cache


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

Details
DB2QDSCCONT-QSTCSTNM table field - DB2 statement name

Description: DB2 statement name
Field Name: QSTCSTNM
Data Element: DB2QSTSTNM
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: DB2RAW16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCSTNM

DB2QDSCCONT-QSTCUSE table field - Current Copies

Description: Current Copies
Field Name: QSTCUSE
Data Element: DB2QSTUSE
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCUSE

DB2QDSCCONT-QSTCCOPY table field - Number of copies of the statement

Description: Number of copies of the statement
Field Name: QSTCCOPY
Data Element: DB2QSTCOPY
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCCOPY

DB2QDSCCONT-QSTCSTAT table field - Status of the statement

Description: Status of the statement
Field Name: QSTCSTAT
Data Element: DB2QSTSTAT
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCSTAT

DB2QDSCCONT-QSTCISTM table field - Time when statement was inserted into cache

Description: Time when statement was inserted into cache
Field Name: QSTCISTM
Data Element: DB2QSTISTM
Data Type: RAW
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2RAW10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCISTM

DB2QDSCCONT-QSTCEXEC table field - Number of executions of the statement

Description: Number of executions of the statement
Field Name: QSTCEXEC
Data Element: DB2QSTEXEC
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCEXEC

DB2QDSCCONT-QSTCRBUF table field - Synchronous Reads

Description: Synchronous Reads
Field Name: QSTCRBUF
Data Element: DB2QSTRBUF
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCRBUF

DB2QDSCCONT-QSTCGPAG table field - Getpages

Description: Getpages
Field Name: QSTCGPAG
Data Element: DB2QSTGPAG
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCGPAG

DB2QDSCCONT-DSTCGPAG table field - Getpages (decimal)

Description: Getpages (decimal)
Field Name: DSTCGPAG
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSTCGPAG

DB2QDSCCONT-QSTCEROW table field - Rows examined (Only data rows are taken into account)

Description: Rows examined (Only data rows are taken into account)
Field Name: QSTCEROW
Data Element: DB2QSTEROW
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCEROW

DB2QDSCCONT-DSTCEROW table field - Rows Examined (new type)

Description: Rows Examined (new type)
Field Name: DSTCEROW
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSTCEROW

DB2QDSCCONT-QSTCPROW table field - Rows Processed

Description: Rows Processed
Field Name: QSTCPROW
Data Element: DB2QSTPROW
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCPROW

DB2QDSCCONT-DSTCPROW table field - Rows Processed (new type)

Description: Rows Processed (new type)
Field Name: DSTCPROW
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSTCPROW

DB2QDSCCONT-QSTCSORT table field - Number of sorts performed for statement

Description: Number of sorts performed for statement
Field Name: QSTCSORT
Data Element: DB2QSTSORT
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCSORT

DB2QDSCCONT-QSTCINDX table field - Number of index scans performed for statement

Description: Number of index scans performed for statement
Field Name: QSTCINDX
Data Element: DB2QSTINDX
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCINDX

DB2QDSCCONT-QSTCTSCN table field - Number of tablespace scans performed for statement

Description: Number of tablespace scans performed for statement
Field Name: QSTCTSCN
Data Element: DB2QSTTSCN
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCTSCN

DB2QDSCCONT-QSTCPLGP table field - Number of parallel groups created for statement

Description: Number of parallel groups created for statement
Field Name: QSTCPLGP
Data Element: DB2QSTPLGP
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCPLGP

DB2QDSCCONT-QSTCWRIT table field - Synchronous Writes

Description: Synchronous Writes
Field Name: QSTCWRIT
Data Element: DB2QSTWRIT
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCWRIT

DB2QDSCCONT-QSTCAET table field - Time elapsed

Description: Time elapsed
Field Name: QSTCAET
Data Element: DB2QSTAET
Data Type: DEC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCAET

DB2QDSCCONT-QSTCSTLN table field - The length of the SQL Statement

Description: The length of the SQL Statement
Field Name: QSTCSTLN
Data Element: DB2QSTSTLN
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 QSTCSTLN

DB2QDSCCONT-QSTCSTMT table field - Statement text

Description: Statement text
Field Name: QSTCSTMT
Data Element: DB2QSTSTMT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCSTMT

DB2QDSCCONT-QW0316L1 table field - Length of program name

Description: Length of program name
Field Name: QW0316L1
Data Element: DB2QW316L1
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 QW0316L1

DB2QDSCCONT-QW0316T1 table field - Program name

Description: Program name
Field Name: QW0316T1
Data Element: DB2QW316T1
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316T1

DB2QDSCCONT-QW0316LX table field - Statement Line Number

Description: Statement Line Number
Field Name: QW0316LX
Data Element: DB2QW316LX
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316LX

DB2QDSCCONT-QW0316L2 table field - Length of transaction name

Description: Length of transaction name
Field Name: QW0316L2
Data Element: DB2QW316L2
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 QW0316L2

DB2QDSCCONT-QW0316T2 table field - Transaction name

Description: Transaction name
Field Name: QW0316T2
Data Element: DB2QW316T2
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR32
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316T2

DB2QDSCCONT-QW0316L3 table field - Length of user ID

Description: Length of user ID
Field Name: QW0316L3
Data Element: DB2QW316L3
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 QW0316L3

DB2QDSCCONT-QW0316T3 table field - User ID

Description: User ID
Field Name: QW0316T3
Data Element: DB2QW316T3
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316T3

DB2QDSCCONT-QW0316X4 table field - User group

Description: User group
Field Name: QW0316X4
Data Element: DB2QW316X4
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316X4

DB2QDSCCONT-QW0316X5 table field - The value of QUALIFIER bind option

Description: The value of QUALIFIER bind option
Field Name: QW0316X5
Data Element: DB2QW316X5
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316X5

DB2QDSCCONT-QW0316X6 table field - ISOLATION

Description: ISOLATION
Field Name: QW0316X6
Data Element: DB2QW316X6
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR03
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316X6

DB2QDSCCONT-QW0316X7T table field - CURRENTDATA

Description: CURRENTDATA
Field Name: QW0316X7T
Data Element: DB2QW316X7
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR03
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316X7T

DB2QDSCCONT-QW0316X8T table field - DYNAMICRULES

Description: DYNAMICRULES
Field Name: QW0316X8T
Data Element: DB2QW316X8
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR04
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316X8T

DB2QDSCCONT-QW0316X9T table field - CURRENT DEGREE

Description: CURRENT DEGREE
Field Name: QW0316X9T
Data Element: DB2QW316X9
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR03
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316X9T

DB2QDSCCONT-QW0316XAT table field - CURRENT RULES

Description: CURRENT RULES
Field Name: QW0316XAT
Data Element: DB2QW316XA
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR03
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316XAT

DB2QDSCCONT-QW0316XBT table field - CURRENT PRECISION

Description: CURRENT PRECISION
Field Name: QW0316XBT
Data Element: DB2QW316XB
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR05
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316XBT

DB2QDSCCONT-QW0316XCT table field - WITH HOLD

Description: WITH HOLD
Field Name: QW0316XCT
Data Element: DB2QW316XC
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR03
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316XCT

DB2QDSCCONT-QW0316TS table field - Timestamp: Begin of Statistics Collection

Description: Timestamp: Begin of Statistics Collection
Field Name: QW0316TS
Data Element: DB2QW316TS
Data Type: DEC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316TS

DB2QDSCCONT-QW0316CT table field - Accumulated CPU Time

Description: Accumulated CPU Time
Field Name: QW0316CT
Data Element: DB2QW316CT
Data Type: DEC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316CT

DB2QDSCCONT-QW0316W1 table field - Accumulated Wait Time for Synchronous I/O

Description: Accumulated Wait Time for Synchronous I/O
Field Name: QW0316W1
Data Element: DB2QW316W1
Data Type: DEC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316W1

DB2QDSCCONT-QW0316W2 table field - Accumulated Wait Time for Lock and Latch Req.

Description: Accumulated Wait Time for Lock and Latch Req.
Field Name: QW0316W2
Data Element: DB2QW316W2
Data Type: DEC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316W2

DB2QDSCCONT-QW0316W3 table field - Accumulated Wait Time for Sync. Execution Unit Switch

Description: Accumulated Wait Time for Sync. Execution Unit Switch
Field Name: QW0316W3
Data Element: DB2QW316W3
Data Type: DEC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316W3

DB2QDSCCONT-QW0316W4 table field - Accumulated Wait Time for Global Locks

Description: Accumulated Wait Time for Global Locks
Field Name: QW0316W4
Data Element: DB2QW316W4
Data Type: DEC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316W4

DB2QDSCCONT-QW0316W5 table field - Accumulated Wait Time for Read Activity by Another Thread

Description: Accumulated Wait Time for Read Activity by Another Thread
Field Name: QW0316W5
Data Element: DB2QW316W5
Data Type: DEC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316W5

DB2QDSCCONT-QW0316W6 table field - Accumulated Wait Time for Write Activity by Another Thread

Description: Accumulated Wait Time for Write Activity by Another Thread
Field Name: QW0316W6
Data Element: DB2QW316W6
Data Type: DEC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316W6

DB2QDSCCONT-QW0316RT table field - RID List Not Used due to DB2 Limits Exceeded

Description: RID List Not Used due to DB2 Limits Exceeded
Field Name: QW0316RT
Data Element: DB2QW316RT
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316RT

DB2QDSCCONT-QW0316RS table field - RID List Not Used due to Insufficient Storage

Description: RID List Not Used due to Insufficient Storage
Field Name: QW0316RS
Data Element: DB2QW316RS
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316RS

DB2QDSCCONT-QW0316UI table field - SAP provided identification of SQL statements

Description: SAP provided identification of SQL statements
Field Name: QW0316UI
Data Element: DB2QW316UI
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316UI

DB2QDSCCONT-QW0316TD table field - Name of the table referenced in the statement

Description: Name of the table referenced in the statement
Field Name: QW0316TD
Data Element: DB2QW316TD
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316TD

DB2QDSCCONT-BIND_RA_TOT table field - Number of rebinds that have been issued due to REOPT(AUTO)

Description: Number of rebinds that have been issued due to REOPT(AUTO)
Field Name: BIND_RA_TOT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BIND_RA_TOT

DB2QDSCCONT-BIND_RO_TYPE table field - REOPT bind option valid for statement

Description: REOPT bind option valid for statement
Field Name: BIND_RO_TYPE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BIND_RO_TYPE

DB2QDSCCONT-QW0317NM table field - SQL STATEMENT NAM

Description: SQL STATEMENT NAM
Field Name: QW0317NM
Data Element: DB2W0317NM
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: CHAR16
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0317NM

DB2QDSCCONT-QW0317ID table field - SQL STATEMENT IDENTIFIER

Description: SQL STATEMENT IDENTIFIER
Field Name: QW0317ID
Data Element: DB2W0317ID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0317ID

DB2QDSCCONT-QW0317LN table field - THE LENGTH OF THE SQL STMT

Description: THE LENGTH OF THE SQL STMT
Field Name: QW0317LN
Data Element: DB2W0317LN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0317LN

DB2QDSCCONT-QW0317TX table field - SQL statement text

Description: SQL statement text
Field Name: QW0317TX
Data Element: DB2W0317TX
Data Type: LCHR
length (Dec): 30720(0)
Check table:
Conversion Routine:
Domain Name: DB2C30K
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0317TX

DB2QDSCCONT-QW03172LN table field - THE LENGTH OF THE SQL STMT

Description: THE LENGTH OF THE SQL STMT
Field Name: QW03172LN
Data Element: DB2W0317LN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW03172LN

DB2QDSCCONT-QW03172TX table field - Statement text

Description: Statement text
Field Name: QW03172TX
Data Element: DB2QSTSTMT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW03172TX


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table