SAP ABAP Table DB2THREADS (DB2 Performance Monitor: Thread List)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU2 (Package) CCMS for DB2 for OS/390
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Table Category | INTTAB | Structure |
Structure | DB2THREADS | Table Relationship Diagram |
Short Description | DB2 Performance Monitor: Thread List |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | HDSUBSYSID | DB2SWPSSID | DB2CHAR04 | CHAR | 4 | 0 | DB2 subsystem ID | ||
2 | HDATDAT | DB2SWPATDT | DB2DATE | DATS | 8 | 0 | Date when sampling is taken | ||
3 | HDATTIM | DB2SWPATTM | DB2TIME | TIMS | 6 | 0 | Time when sampling is taken | ||
4 | HDLRESTIME | DB2SWPLRTM | DB2TIME | TIMS | 6 | 0 | Time of last reset | ||
5 | ACE | DB2RAW04 | DB2INT4 | INT4 | 10 | 0 | Field type raw, length 8, 4 bytes | ||
6 | JOBNAME | DB2THDJOB | DB2CHAR8 | CHAR | 8 | 0 | The job name of the thread. | ||
7 | DBPLAN | DB2WHCPLAN | CHAR128 | CHAR | 128 | 0 | DB2 plan name | ||
8 | AUTHID | DB2WHCAID | CHAR128 | CHAR | 128 | 0 | The authorization ID under which the transaction is running | ||
9 | CORRID | DB2WHCCV | DB2CHAR16 | CHAR | 16 | 0 | The correlation ID of the thread (IP address) | ||
10 | CONNID | DB2WHCCN | DB2CHAR08 | CHAR | 8 | 0 | The connection ID of the thread | ||
11 | THDSTAT | DB2W0148AI | DB2CHAR16 | CHAR | 16 | 0 | The status of the thread | ||
12 | FILLER | DB2CHAR08 | DB2CHAR08 | CHAR | 8 | 0 | Field type char, length 8 | ||
13 | SQLCNT | DB2THDSQL | DB2INT4 | INT4 | 10 | 0 | The total number of executed SQL statements | ||
14 | DBCOMMIT | DB2WACCOMM | DB2INT4 | INT4 | 10 | 0 | The number of successful phase 2 or single-phase commits | ||
15 | ABORT | DB2WACABRT | DB2INT4 | INT4 | 10 | 0 | Total number of rollback requests | ||
16 | GETPAGE | DB2BACGET | DB2INT4U | INT4 | 10 | 0 | Number of Getpage Requests | ||
17 | UPDPAGE | DB2BACSWS | DB2INT4U | INT4 | 10 | 0 | The number of times a buffer update occurs for the agent | ||
18 | LOCKS | DB2THDLOCK | DB2INT4 | INT4 | 10 | 0 | The total number of currently hold locks. | ||
19 | CPUTIME | DB2WACAJST | DB2INT4 | INT4 | 10 | 0 | The accumulated home CPU time a thread spent in DB2 | ||
20 | ELTIME | DB2THDELT | DB2INT4 | INT4 | 10 | 0 | Time elapsed since DB2 thread was started | ||
21 | LOCKMOD | DB2LOCKMOD | DB2CHAR06 | CHAR | 6 | 0 | The mode of the lock held on the resource | ||
22 | ACTTIME | DB2THDTACT | DB2CHAR16 | CHAR | 16 | 0 | Activity time (Class 1 elapsed time) | ||
23 | TIMEINDB2 | DB2INDB2 | DB2TIMEP | CHAR | 8 | 0 | Percentage of time spent in DB2 | ||
24 | PROCINDB2 | DB2PROCDB2 | DB2TIMEP | CHAR | 8 | 0 | Percentage of time spent processing in DB2 | ||
25 | WPTYPE | DB2PROCTYP | CHAR | 11 | 0 | process type | |||
26 | WPNUMBER | DB2PROCID | NUMC | 19 | 0 | process ID | |||
27 | WPID | DB2WPID | DB2NUMC10 | NUMC | 10 | 0 | Work process ID | ||
28 | ASHOST | DB2ASHOST | DB2CHAR32 | CHAR | 32 | 0 | Application server host name | ||
29 | THDREQ | DB2W0148RC | DB2INT4 | INT4 | 10 | 0 | Number of Requests Sent to DB2 | ||
30 | ADTHRSTA | DB2DTHRSTA | DB2CHAR22 | CHAR | 22 | 0 | Status of the thread | ||
31 | PRCINDB2 | DB2PRCIN | DB2CHAR10 | CHAR | 10 | 0 | Thread activity: % processing in DB2 | ||
32 | SSPINDB2 | DB2SSPIN | DB2CHAR10 | CHAR | 10 | 0 | Prozent der Zeit für die DB2-Verarbeitung (CPU-Zeit) | ||
33 | DS_MEMBER | CHAR | 8 | 0 | |||||
34 | THDMLOCKS | NUMC | 10 | 0 | |||||
35 | CONNNAME | CHAR | 30 | 0 | |||||
36 | QMDAPLAT | CHAR | 18 | 0 | |||||
37 | QWHDRQNM | CHAR | 128 | 0 | |||||
38 | SAPSID | CHAR | 3 | 0 | |||||
39 | SAPSYS | INT4 | 10 | 0 | |||||
40 | ABAPREP | SYREPID | PROGRAMM | CHAR | 40 | 0 | ABAP Program: Current Main Program | * | |
41 | TXCODE | DB2TXNAME | CHAR | 80 | 0 | transaction / thread name | |||
42 | ENDUSER | CHAR | 14 | 0 | |||||
43 | J2EESERV | CHAR | 20 | 0 | |||||
44 | QWACPARR | CHAR | 10 | 0 | |||||
45 | QW0148CI | CHAR | 128 | 0 | |||||
46 | QW0148ST | DB2W0148ST | CHAR | 2 | 0 | Indicates the status of the conversation or socket |
History
Last changed by/on | SAP | 20140117 |
SAP Release Created in |