Data Element list used by SAP ABAP Table DB2QTHDLST (ST04: DB2 thread overview)
SAP ABAP Table DB2QTHDLST (ST04: DB2 thread overview) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
1 | Data Element | DB2ASHOST | Application server host name | |
2 | Data Element | DB2BACGET | Number of Getpage Requests | |
3 | Data Element | DB2BACSWS | The number of times a buffer update occurs for the agent | |
4 | Data Element | DB2CHAR08 | Field type char, length 8 | |
5 | Data Element | DB2EUTX | DB2EUTX- | |
6 | Data Element | DB2EUWN | DB2EUWN- | |
7 | Data Element | DB2INDB2 | Percentage of time spent in DB2 | |
8 | Data Element | DB2LOCKMOD | The mode of the lock held on the resource | |
9 | Data Element | DB2MEMN | DB2 member name in data sharing environment | |
10 | Data Element | DB2PROCDB2 | Percentage of time spent processing in DB2 | |
11 | Data Element | DB2RAW04 | Field type raw, length 8, 4 bytes | |
12 | Data Element | DB2SWPATDT | Date when sampling is taken | |
13 | Data Element | DB2SWPATTM | Time when sampling is taken | |
14 | Data Element | DB2SWPLRTM | Time of last reset | |
15 | Data Element | DB2SWPSSID | DB2 subsystem ID | |
16 | Data Element | DB2THDACT1 | DB2THDACT1- | |
17 | Data Element | DB2THDACT2 | DB2THDACT2- | |
18 | Data Element | DB2THDELT | Time elapsed since DB2 thread was started | |
19 | Data Element | DB2THDJOB | The job name of the thread. | |
20 | Data Element | DB2THDLOCK | The total number of currently hold locks. | |
21 | Data Element | DB2THDSQL | The total number of executed SQL statements | |
22 | Data Element | DB2THDTACT | Activity time (Class 1 elapsed time) | |
23 | Data Element | DB2THDTSTT | DB2THDTSTT- | |
24 | Data Element | DB2TXANLP | Maximum page or row locks held | |
25 | Data Element | DB2W0148AI | The status of the thread | |
26 | Data Element | DB2W0148RQ | Number of Requests Sent to DB2 | |
27 | Data Element | DB2WACABRT | Total number of rollback requests | |
28 | Data Element | DB2WACAJST | The accumulated home CPU time a thread spent in DB2 | |
29 | Data Element | DB2WACCOMM | The number of successful phase 2 or single-phase commits | |
30 | Data Element | DB2WHCAID | The authorization ID under which the transaction is running | |
31 | Data Element | DB2WHCCN | The connection ID of the thread | |
32 | Data Element | DB2WHCCV | The correlation ID of the thread (IP address) | |
33 | Data Element | DB2WHCPLAN | DB2 plan name | |
34 | Data Element | DB2WPID | Work process ID | |
35 | Data Element | DB2WPNUM | Work process number | |
36 | Data Element | DB2WPTYE | Corresponding R/3 work process type |