SAP DB2QTHDLST table - ST04: DB2 thread overview details in SAP


SAP DB2QTHDLST table summary

Object Name: DB2QTHDLST
Dictionary Type: Structure
Description: ST04: DB2 thread overview


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

Details
DB2QTHDLST-MEMBNM table field - DB2 member name in data sharing environment

Description: DB2 member name in data sharing environment
Field Name: MEMBNM
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 MEMBNM

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

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

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

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

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

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

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

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

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

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

DB2QTHDLST-THDTSTAT table field -

Description:
Field Name: THDTSTAT
Data Element: DB2THDTSTT
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field THDTSTAT

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

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

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

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

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

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

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

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

DB2QTHDLST-QTXANPL table field - Maximum page or row locks held

Description: Maximum page or row locks held
Field Name: QTXANPL
Data Element: DB2TXANLP
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 QTXANPL

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

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

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

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

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

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

DB2QTHDLST-WPTYPE table field - Corresponding R/3 work process type

Description: Corresponding R/3 work process type
Field Name: WPTYPE
Data Element: DB2WPTYE
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 WPTYPE

DB2QTHDLST-WPNUMBER table field - Work process number

Description: Work process number
Field Name: WPNUMBER
Data Element: DB2WPNUM
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 WPNUMBER

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

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

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

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

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

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

DB2QTHDLST-THDACT1 table field -

Description:
Field Name: THDACT1
Data Element: DB2THDACT1
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 THDACT1

DB2QTHDLST-THDACT2 table field -

Description:
Field Name: THDACT2
Data Element: DB2THDACT2
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 THDACT2

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

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

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

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

DB2QTHDLST-QWHCTOKN table field - DB2 accounting correlation token

Description: DB2 accounting correlation token
Field Name: QWHCTOKN
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 QWHCTOKN

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

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

DB2QTHDLST-QW0148TTK table field - 4 Byte Signed Integer

Description: 4 Byte Signed Integer
Field Name: QW0148TTK
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 QW0148TTK


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table