SAP ABAP Table DB2LOCKS (Locked DB2-Resources and their Holders and Waiters)
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 | DB2LOCKS | Table Relationship Diagram |
Short Description | Locked DB2-Resources and their Holders and Waiters |
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 | USERID | DB2SUCNT | INT2 | INT2 | 5 | 0 | DB2/OS390: Unique counter | ||
2 | LOCKID | DB2SINT | DB2INT2V | INT2 | 5 | 0 | Small integer (2 bytes) | ||
3 | LOCKMOD_DB | DB2LOCKMOD | DB2CHAR06 | CHAR | 6 | 0 | The mode of the lock held on the resource | ||
4 | RESTYPE | DB2RESTYPE | CHAR20 | CHAR | 20 | 0 | The type of resource held by a lock | ||
5 | DBOWNER | DB2DBOWNER | DB2CHAR16 | CHAR | 16 | 0 | The name of the DB2 database | ||
6 | PAGESET | DB2PAGESET | DB2CHAR22 | CHAR | 22 | 0 | Object name | ||
7 | DURATION | DB2LOCKDUR | CHAR12 | CHAR | 12 | 0 | Lock duration of the thread holding the resource | ||
8 | LOCKTYPE | DB2LOCKTYP | CHAR10 | CHAR | 10 | 0 | State of lock | ||
9 | LOCKATRI | DB2LOCKATT | CHAR6 | CHAR | 6 | 0 | Lock attribute (logical lock or physical lock) | ||
10 | HOLD_WAIT | DB2_HOLD_WAIT | CHAR1 | CHAR | 1 | 0 | Detectionflag for Holders(H) or Waiters(W) for DB2Resources | ||
11 | .INCLUDE | 0 | 0 | DB2 Performance Monitor: Thread List | |||||
12 | HDSUBSYSID | DB2SWPSSID | DB2CHAR04 | CHAR | 4 | 0 | DB2 subsystem ID | ||
13 | HDATDAT | DB2SWPATDT | DB2DATE | DATS | 8 | 0 | Date when sampling is taken | ||
14 | HDATTIM | DB2SWPATTM | DB2TIME | TIMS | 6 | 0 | Time when sampling is taken | ||
15 | HDLRESTIME | DB2SWPLRTM | DB2TIME | TIMS | 6 | 0 | Time of last reset | ||
16 | ACE | DB2RAW04 | DB2INT4 | INT4 | 10 | 0 | Field type raw, length 8, 4 bytes | ||
17 | JOBNAME | DB2THDJOB | DB2CHAR8 | CHAR | 8 | 0 | The job name of the thread. | ||
18 | DBPLAN | DB2WHCPLAN | CHAR128 | CHAR | 128 | 0 | DB2 plan name | ||
19 | AUTHID | DB2WHCAID | CHAR128 | CHAR | 128 | 0 | The authorization ID under which the transaction is running | ||
20 | CORRID | DB2WHCCV | DB2CHAR16 | CHAR | 16 | 0 | The correlation ID of the thread (IP address) | ||
21 | CONNID | DB2WHCCN | DB2CHAR08 | CHAR | 8 | 0 | The connection ID of the thread | ||
22 | THDSTAT | DB2W0148AI | DB2CHAR16 | CHAR | 16 | 0 | The status of the thread | ||
23 | FILLER | DB2CHAR08 | DB2CHAR08 | CHAR | 8 | 0 | Field type char, length 8 | ||
24 | SQLCNT | DB2THDSQL | DB2INT4 | INT4 | 10 | 0 | The total number of executed SQL statements | ||
25 | DBCOMMIT | DB2WACCOMM | DB2INT4 | INT4 | 10 | 0 | The number of successful phase 2 or single-phase commits | ||
26 | ABORT | DB2WACABRT | DB2INT4 | INT4 | 10 | 0 | Total number of rollback requests | ||
27 | GETPAGE | DB2BACGET | DB2INT4U | INT4 | 10 | 0 | Number of Getpage Requests | ||
28 | UPDPAGE | DB2BACSWS | DB2INT4U | INT4 | 10 | 0 | The number of times a buffer update occurs for the agent | ||
29 | LOCKS | DB2THDLOCK | DB2INT4 | INT4 | 10 | 0 | The total number of currently hold locks. | ||
30 | CPUTIME | DB2WACAJST | DB2INT4 | INT4 | 10 | 0 | The accumulated home CPU time a thread spent in DB2 | ||
31 | ELTIME | DB2THDELT | DB2INT4 | INT4 | 10 | 0 | Time elapsed since DB2 thread was started | ||
32 | LOCKMOD | DB2LOCKMOD | DB2CHAR06 | CHAR | 6 | 0 | The mode of the lock held on the resource | ||
33 | ACTTIME | DB2THDTACT | DB2CHAR16 | CHAR | 16 | 0 | Activity time (Class 1 elapsed time) | ||
34 | TIMEINDB2 | DB2INDB2 | DB2TIMEP | CHAR | 8 | 0 | Percentage of time spent in DB2 | ||
35 | PROCINDB2 | DB2PROCDB2 | DB2TIMEP | CHAR | 8 | 0 | Percentage of time spent processing in DB2 | ||
36 | WPTYPE | DB2PROCTYP | CHAR | 11 | 0 | process type | |||
37 | WPNUMBER | DB2PROCID | NUMC | 19 | 0 | process ID | |||
38 | WPID | DB2WPID | DB2NUMC10 | NUMC | 10 | 0 | Work process ID | ||
39 | ASHOST | DB2ASHOST | DB2CHAR32 | CHAR | 32 | 0 | Application server host name | ||
40 | THDREQ | DB2W0148RC | DB2INT4 | INT4 | 10 | 0 | Number of Requests Sent to DB2 | ||
41 | ADTHRSTA | DB2DTHRSTA | DB2CHAR22 | CHAR | 22 | 0 | Status of the thread | ||
42 | PRCINDB2 | DB2PRCIN | DB2CHAR10 | CHAR | 10 | 0 | Thread activity: % processing in DB2 | ||
43 | SSPINDB2 | DB2SSPIN | DB2CHAR10 | CHAR | 10 | 0 | Prozent der Zeit für die DB2-Verarbeitung (CPU-Zeit) | ||
44 | DS_MEMBER | CHAR | 8 | 0 | |||||
45 | THDMLOCKS | NUMC | 10 | 0 | |||||
46 | CONNNAME | CHAR | 30 | 0 | |||||
47 | QMDAPLAT | CHAR | 18 | 0 | |||||
48 | QWHDRQNM | CHAR | 128 | 0 | |||||
49 | SAPSID | CHAR | 3 | 0 | |||||
50 | SAPSYS | INT4 | 10 | 0 | |||||
51 | ABAPREP | SYREPID | PROGRAMM | CHAR | 40 | 0 | ABAP Program: Current Main Program | * | |
52 | TXCODE | DB2TXNAME | CHAR | 80 | 0 | transaction / thread name | |||
53 | ENDUSER | CHAR | 14 | 0 | |||||
54 | J2EESERV | CHAR | 20 | 0 | |||||
55 | QWACPARR | CHAR | 10 | 0 | |||||
56 | QW0148CI | CHAR | 128 | 0 | |||||
57 | QW0148ST | DB2W0148ST | CHAR | 2 | 0 | Indicates the status of the conversation or socket | |||
58 | .INCLUDE | 0 | 0 | Number of Waiters and Holders on a Resource | |||||
59 | NQW1503H | INT4 | INT4 | INT4 | 10 | 0 | Natural number | ||
60 | NQW1503W | INT4 | INT4 | INT4 | 10 | 0 | Natural number |
History
Last changed by/on | SAP | 20140117 |
SAP Release Created in | 700 |