SAP DB2LOCKESCAL table - DB2 alert for lock escalations details in SAP


SAP DB2LOCKESCAL table summary

Object Name: DB2LOCKESCAL
Dictionary Type: Structure
Description: DB2 alert for lock escalations


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

Details
DB2LOCKESCAL-LOCKMEMN table field - DB2 member name in data sharing environment

Description: DB2 member name in data sharing environment
Field Name: LOCKMEMN
Data Element: DB2MEMN
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR08
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKMEMN

DB2LOCKESCAL-SSID table field - DB2 subsystem ID

Description: DB2 subsystem ID
Field Name: SSID
Data Element: DB2SWPSSID
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 SSID

DB2LOCKESCAL-LOCKDATE table field - Field of type DATS

Description: Field of type DATS
Field Name: LOCKDATE
Data Element: DATS
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKDATE

DB2LOCKESCAL-LOCKTIME table field - Field of type TIMS

Description: Field of type TIMS
Field Name: LOCKTIME
Data Element: TIMS
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKTIME

DB2LOCKESCAL-LOCKMSEC table field - Event time stamp (milliseconds)

Description: Event time stamp (milliseconds)
Field Name: LOCKMSEC
Data Element: DB2EVTTMS
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR06
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKMSEC

DB2LOCKESCAL-DBNAME table field - Database name

Description: Database name
Field Name: DBNAME
Data Element: DB2DBNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: D2DBNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

DB2LOCKESCAL-TSNAME table field - Name of the tablespace

Description: Name of the tablespace
Field Name: TSNAME
Data Element: DB2TSNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TSNAME

DB2LOCKESCAL-QWO337LS table field - The mode of the lock held on the resource

Description: The mode of the lock held on the resource
Field Name: QWO337LS
Data Element: DB2LOCKMS
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 QWO337LS

DB2LOCKESCAL-QW0337LL table field - Type of lower level lock used (page, row or LOB lock)

Description: Type of lower level lock used (page, row or LOB lock)
Field Name: QW0337LL
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 QW0337LL

DB2LOCKESCAL-QW0337LH table field - # of lower level locks held and released by escalation

Description: # of lower level locks held and released by escalation
Field Name: QW0337LH
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 QW0337LH

DB2LOCKESCAL-QW0337SN table field - Statement ID

Description: Statement ID
Field Name: QW0337SN
Data Element: DB2QSTTOKN
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 QW0337SN

DB2LOCKESCAL-QW0337ST table field - Statement ID

Description: Statement ID
Field Name: QW0337ST
Data Element: DB2QSTTOKN
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 QW0337ST

DB2LOCKESCAL-QW0337CI table field - Collection ID

Description: Collection ID
Field Name: QW0337CI
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 QW0337CI

DB2LOCKESCAL-QW0337PK table field - DB2 package name

Description: DB2 package name
Field Name: QW0337PK
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 QW0337PK

DB2LOCKESCAL-THDEUWN table field -

Description:
Field Name: THDEUWN
Data Element: DB2EUWN
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR18
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field THDEUWN

DB2LOCKESCAL-THDEUTX table field -

Description:
Field Name: THDEUTX
Data Element: DB2EUTX
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: CHAR32
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field THDEUTX

DB2LOCKESCAL-QMDASUFX table field - DB2 accounting string

Description: DB2 accounting string
Field Name: QMDASUFX
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 QMDASUFX

DB2LOCKESCAL-QMDAPLAT table field - Client application platform from DB2's perspective

Description: Client application platform from DB2's perspective
Field Name: QMDAPLAT
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 QMDAPLAT

DB2LOCKESCAL-QWHDRQNM table field - Client IP address from DB2's perspective

Description: Client IP address from DB2's perspective
Field Name: QWHDRQNM
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 QWHDRQNM

DB2LOCKESCAL-QWHCEUID table field - Client enduser ID from DB2's perspective

Description: Client enduser ID from DB2's perspective
Field Name: QWHCEUID
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 QWHCEUID

DB2LOCKESCAL-CORRID table field - The correlation ID of the thread (IP address)

Description: The correlation ID of the thread (IP address)
Field Name: CORRID
Data Element: DB2WHCCV
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CORRID

DB2LOCKESCAL-CONNID table field - The connection ID of the thread

Description: The connection ID of the thread
Field Name: CONNID
Data Element: DB2WHCCN
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR08
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONNID

DB2LOCKESCAL-LOCKDSGN table field - DB2/390: Data sharing group

Description: DB2/390: Data sharing group
Field Name: LOCKDSGN
Data Element: DB2DSGN
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR08
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKDSGN

DB2LOCKESCAL-QW0337TY table field - Type of Waiters statement ('S' or 'D', static or dynamic)

Description: Type of Waiters statement ('S' or 'D', static or dynamic)
Field Name: QW0337TY
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 QW0337TY


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table