Data Element list used by SAP ABAP Table DB2LOCKS (Locked DB2-Resources and their Holders and Waiters)
SAP ABAP Table DB2LOCKS (Locked DB2-Resources and their Holders and Waiters) 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 | DB2DBOWNER | The name of the DB2 database | |
6 | Data Element | DB2DTHRSTA | Status of the thread | |
7 | Data Element | DB2INDB2 | Percentage of time spent in DB2 | |
8 | Data Element | DB2LOCKATT | Lock attribute (logical lock or physical lock) | |
9 | Data Element | DB2LOCKDUR | Lock duration of the thread holding the resource | |
10 | Data Element | DB2LOCKMOD | The mode of the lock held on the resource | |
11 | Data Element | DB2LOCKMOD | The mode of the lock held on the resource | |
12 | Data Element | DB2LOCKTYP | State of lock | |
13 | Data Element | DB2PAGESET | Object name | |
14 | Data Element | DB2PRCIN | Thread activity: % processing in DB2 | |
15 | Data Element | DB2PROCDB2 | Percentage of time spent processing in DB2 | |
16 | Data Element | DB2PROCID | process ID | |
17 | Data Element | DB2PROCTYP | process type | |
18 | Data Element | DB2RAW04 | Field type raw, length 8, 4 bytes | |
19 | Data Element | DB2RESTYPE | The type of resource held by a lock | |
20 | Data Element | DB2SINT | Small integer (2 bytes) | |
21 | Data Element | DB2SSPIN | Prozent der Zeit für die DB2-Verarbeitung (CPU-Zeit) | |
22 | Data Element | DB2SUCNT | DB2/OS390: Unique counter | |
23 | Data Element | DB2SWPATDT | Date when sampling is taken | |
24 | Data Element | DB2SWPATTM | Time when sampling is taken | |
25 | Data Element | DB2SWPLRTM | Time of last reset | |
26 | Data Element | DB2SWPSSID | DB2 subsystem ID | |
27 | Data Element | DB2THDELT | Time elapsed since DB2 thread was started | |
28 | Data Element | DB2THDJOB | The job name of the thread. | |
29 | Data Element | DB2THDLOCK | The total number of currently hold locks. | |
30 | Data Element | DB2THDSQL | The total number of executed SQL statements | |
31 | Data Element | DB2THDTACT | Activity time (Class 1 elapsed time) | |
32 | Data Element | DB2TXNAME | transaction / thread name | |
33 | Data Element | DB2W0148AI | The status of the thread | |
34 | Data Element | DB2W0148RC | Number of Requests Sent to DB2 | |
35 | Data Element | DB2W0148ST | Indicates the status of the conversation or socket | |
36 | Data Element | DB2WACABRT | Total number of rollback requests | |
37 | Data Element | DB2WACAJST | The accumulated home CPU time a thread spent in DB2 | |
38 | Data Element | DB2WACCOMM | The number of successful phase 2 or single-phase commits | |
39 | Data Element | DB2WHCAID | The authorization ID under which the transaction is running | |
40 | Data Element | DB2WHCCN | The connection ID of the thread | |
41 | Data Element | DB2WHCCV | The correlation ID of the thread (IP address) | |
42 | Data Element | DB2WHCPLAN | DB2 plan name | |
43 | Data Element | DB2WPID | Work process ID | |
44 | Data Element | DB2_HOLD_WAIT | Detectionflag for Holders(H) or Waiters(W) for DB2Resources | |
45 | Data Element | INT4 | Natural number | |
46 | Data Element | INT4 | Natural number | |
47 | Data Element | SYREPID | ABAP Program: Current Main Program |