SAP DB2LOCKS table - Locked DB2-Resources and their Holders and Waiters details in SAP


SAP DB2LOCKS table summary

Object Name: DB2LOCKS
Dictionary Type: Structure
Description: Locked DB2-Resources and their Holders and Waiters


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

Details
DB2LOCKS-USERID table field - DB2/OS390: Unique counter

Description: DB2/OS390: Unique counter
Field Name: USERID
Data Element: DB2SUCNT
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 USERID

DB2LOCKS-LOCKID table field - Small integer (2 bytes)

Description: Small integer (2 bytes)
Field Name: LOCKID
Data Element: DB2SINT
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2INT2V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKID

DB2LOCKS-LOCKMOD_DB table field - The mode of the lock held on the resource

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

DB2LOCKS-RESTYPE table field - The type of resource held by a lock

Description: The type of resource held by a lock
Field Name: RESTYPE
Data Element: DB2RESTYPE
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RESTYPE

DB2LOCKS-DBOWNER table field - The name of the DB2 database

Description: The name of the DB2 database
Field Name: DBOWNER
Data Element: DB2DBOWNER
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 DBOWNER

DB2LOCKS-PAGESET table field - Object name

Description: Object name
Field Name: PAGESET
Data Element: DB2PAGESET
Data Type: CHAR
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGESET

DB2LOCKS-DURATION table field - Lock duration of the thread holding the resource

Description: Lock duration of the thread holding the resource
Field Name: DURATION
Data Element: DB2LOCKDUR
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DURATION

DB2LOCKS-LOCKTYPE table field - State of lock

Description: State of lock
Field Name: LOCKTYPE
Data Element: DB2LOCKTYP
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKTYPE

DB2LOCKS-LOCKATRI table field - Lock attribute (logical lock or physical lock)

Description: Lock attribute (logical lock or physical lock)
Field Name: LOCKATRI
Data Element: DB2LOCKATT
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: CHAR6
MemoryID:
AppClass: SDIN
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKATRI

DB2LOCKS-HOLD_WAIT table field - Detectionflag for Holders(H) or Waiters(W) for DB2Resources

Description: Detectionflag for Holders(H) or Waiters(W) for DB2Resources
Field Name: HOLD_WAIT
Data Element: DB2_HOLD_WAIT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOLD_WAIT

DB2LOCKS-HDSUBSYSID table field - DB2 subsystem ID

Description: DB2 subsystem ID
Field Name: HDSUBSYSID
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 HDSUBSYSID

DB2LOCKS-HDATDAT table field - Date when sampling is taken

Description: Date when sampling is taken
Field Name: HDATDAT
Data Element: DB2SWPATDT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HDATDAT

DB2LOCKS-HDATTIM table field - Time when sampling is taken

Description: Time when sampling is taken
Field Name: HDATTIM
Data Element: DB2SWPATTM
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: DB2TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HDATTIM

DB2LOCKS-HDLRESTIME table field - Time of last reset

Description: Time of last reset
Field Name: HDLRESTIME
Data Element: DB2SWPLRTM
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: DB2TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HDLRESTIME

DB2LOCKS-ACE table field - Field type raw, length 8, 4 bytes

Description: Field type raw, length 8, 4 bytes
Field Name: ACE
Data Element: DB2RAW04
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 ACE

DB2LOCKS-JOBNAME table field - The job name of the thread.

Description: The job name of the thread.
Field Name: JOBNAME
Data Element: DB2THDJOB
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOBNAME

DB2LOCKS-DBPLAN table field - DB2 plan name

Description: DB2 plan name
Field Name: DBPLAN
Data Element: DB2WHCPLAN
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 DBPLAN

DB2LOCKS-AUTHID table field - The authorization ID under which the transaction is running

Description: The authorization ID under which the transaction is running
Field Name: AUTHID
Data Element: DB2WHCAID
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 AUTHID

DB2LOCKS-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

DB2LOCKS-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

DB2LOCKS-THDSTAT table field - The status of the thread

Description: The status of the thread
Field Name: THDSTAT
Data Element: DB2W0148AI
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 THDSTAT

DB2LOCKS-FILLER table field - Field type char, length 8

Description: Field type char, length 8
Field Name: FILLER
Data Element: DB2CHAR08
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 FILLER

DB2LOCKS-SQLCNT table field - The total number of executed SQL statements

Description: The total number of executed SQL statements
Field Name: SQLCNT
Data Element: DB2THDSQL
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 SQLCNT

DB2LOCKS-DBCOMMIT table field - The number of successful phase 2 or single-phase commits

Description: The number of successful phase 2 or single-phase commits
Field Name: DBCOMMIT
Data Element: DB2WACCOMM
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 DBCOMMIT

DB2LOCKS-ABORT table field - Total number of rollback requests

Description: Total number of rollback requests
Field Name: ABORT
Data Element: DB2WACABRT
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 ABORT

DB2LOCKS-GETPAGE table field - Number of Getpage Requests

Description: Number of Getpage Requests
Field Name: GETPAGE
Data Element: DB2BACGET
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4U
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GETPAGE

DB2LOCKS-UPDPAGE table field - The number of times a buffer update occurs for the agent

Description: The number of times a buffer update occurs for the agent
Field Name: UPDPAGE
Data Element: DB2BACSWS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4U
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UPDPAGE

DB2LOCKS-LOCKS table field - The total number of currently hold locks.

Description: The total number of currently hold locks.
Field Name: LOCKS
Data Element: DB2THDLOCK
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 LOCKS

DB2LOCKS-CPUTIME table field - The accumulated home CPU time a thread spent in DB2

Description: The accumulated home CPU time a thread spent in DB2
Field Name: CPUTIME
Data Element: DB2WACAJST
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 CPUTIME

DB2LOCKS-ELTIME table field - Time elapsed since DB2 thread was started

Description: Time elapsed since DB2 thread was started
Field Name: ELTIME
Data Element: DB2THDELT
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 ELTIME

DB2LOCKS-LOCKMOD table field - The mode of the lock held on the resource

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

DB2LOCKS-ACTTIME table field - Activity time (Class 1 elapsed time)

Description: Activity time (Class 1 elapsed time)
Field Name: ACTTIME
Data Element: DB2THDTACT
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 ACTTIME

DB2LOCKS-TIMEINDB2 table field - Percentage of time spent in DB2

Description: Percentage of time spent in DB2
Field Name: TIMEINDB2
Data Element: DB2INDB2
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2TIMEP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIMEINDB2

DB2LOCKS-PROCINDB2 table field - Percentage of time spent processing in DB2

Description: Percentage of time spent processing in DB2
Field Name: PROCINDB2
Data Element: DB2PROCDB2
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2TIMEP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROCINDB2

DB2LOCKS-WPTYPE table field - process type

Description: process type
Field Name: WPTYPE
Data Element: DB2PROCTYP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WPTYPE

DB2LOCKS-WPNUMBER table field - process ID

Description: process ID
Field Name: WPNUMBER
Data Element: DB2PROCID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WPNUMBER

DB2LOCKS-WPID table field - Work process ID

Description: Work process ID
Field Name: WPID
Data Element: DB2WPID
Data Type: NUMC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2NUMC10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WPID

DB2LOCKS-ASHOST table field - Application server host name

Description: Application server host name
Field Name: ASHOST
Data Element: DB2ASHOST
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 ASHOST

DB2LOCKS-THDREQ table field - Number of Requests Sent to DB2

Description: Number of Requests Sent to DB2
Field Name: THDREQ
Data Element: DB2W0148RC
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 THDREQ

DB2LOCKS-ADTHRSTA table field - Status of the thread

Description: Status of the thread
Field Name: ADTHRSTA
Data Element: DB2DTHRSTA
Data Type: CHAR
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADTHRSTA

DB2LOCKS-PRCINDB2 table field - Thread activity: % processing in DB2

Description: Thread activity: % processing in DB2
Field Name: PRCINDB2
Data Element: DB2PRCIN
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRCINDB2

DB2LOCKS-SSPINDB2 table field - Prozent der Zeit für die DB2-Verarbeitung (CPU-Zeit)

Description: Prozent der Zeit für die DB2-Verarbeitung (CPU-Zeit)
Field Name: SSPINDB2
Data Element: DB2SSPIN
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SSPINDB2

DB2LOCKS-DS_MEMBER table field - Data sharing member to which the thread belongs to

Description: Data sharing member to which the thread belongs to
Field Name: DS_MEMBER
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 DS_MEMBER

DB2LOCKS-THDMLOCKS table field - Maximum locks held

Description: Maximum locks held
Field Name: THDMLOCKS
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 THDMLOCKS

DB2LOCKS-CONNNAME table field - Database connection name

Description: Database connection name
Field Name: CONNNAME
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 CONNNAME

DB2LOCKS-QMDAPLAT table field - Client platform from DB2's perspective

Description: Client 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

DB2LOCKS-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

DB2LOCKS-SAPSID table field - SAP system ID (SAPSID)

Description: SAP system ID (SAPSID)
Field Name: SAPSID
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 SAPSID

DB2LOCKS-SAPSYS table field - SAP system number (SAPSYSTEM)

Description: SAP system number (SAPSYSTEM)
Field Name: SAPSYS
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 SAPSYS

DB2LOCKS-ABAPREP table field - ABAP Program: Current Master Program

Description: ABAP Program: Current Master Program
Field Name: ABAPREP
Data Element: SYREPID
Data Type: CHAR
length (Dec): 40(0)
Check table: *
Conversion Routine:
Domain Name: PROGRAMM
MemoryID:
AppClass: SAB4
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ABAPREP

DB2LOCKS-TXCODE table field -

Description:
Field Name: TXCODE
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 TXCODE

DB2LOCKS-ENDUSER table field - SAP end-user ID

Description: SAP end-user ID
Field Name: ENDUSER
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 ENDUSER

DB2LOCKS-J2EESERV table field - J2EE service type

Description: J2EE service type
Field Name: J2EESERV
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 J2EESERV

DB2LOCKS-QWACPARR table field - Accounting records represents accounting rollup bucket

Description: Accounting records represents accounting rollup bucket
Field Name: QWACPARR
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 QWACPARR

DB2LOCKS-QW0148CI table field - DB2 collection ID

Description: DB2 collection ID
Field Name: QW0148CI
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 QW0148CI

DB2LOCKS-QW0148ST table field - Indicates the status of the conversation or socket

Description: Indicates the status of the conversation or socket
Field Name: QW0148ST
Data Element: DB2W0148ST
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0148ST

DB2LOCKS-QW0148TTK table field - Unique Thread Token

Description: Unique Thread Token
Field Name: QW0148TTK
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 QW0148TTK

DB2LOCKS-NQW1503H table field - 4 Byte Signed Integer

Description: 4 Byte Signed Integer
Field Name: NQW1503H
Data Element: INT4
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NQW1503H

DB2LOCKS-NQW1503W table field - 4 Byte Signed Integer

Description: 4 Byte Signed Integer
Field Name: NQW1503W
Data Element: INT4
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NQW1503W


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table