SAP ABAP Table DB2QTGA (DB2/390: Data Sharing Locking for Given Thread)
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
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390
Basic Data
| Table Category | INTTAB | Structure |
| Structure | DB2QTGA |
Table Relationship Diagram 
|
| Short Description | DB2/390: Data Sharing Locking for Given Thread |
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 |  QTGALPLK |
DB2TGSLPLK | DB2DEC10V | DEC | 10 | 0 | Number of lock requests for P-locks | ||
| 2 | QTGAUPLK |
DB2TGSUPLK | DB2DEC10V | DEC | 10 | 0 | Number of unlock requests for P-locks | ||
| 3 | QTGACPLK |
DB2TGSCPLK | DB2DEC10V | DEC | 10 | 0 | Number of Change Requests for P-Locks | ||
| 4 | QTGALSLM |
DB2TGSLSLM | DB2DEC10V | DEC | 10 | 0 | Number of lock requests propagated to MVS XES synchronously | ||
| 5 | QTGACSLM |
DB2TGSCSLM | DB2DEC10V | DEC | 10 | 0 | No. of Change Requests Propagated to MVS XES Synchronously | ||
| 6 | QTGAUSLM |
DB2TGSUSLM | DB2DEC10V | DEC | 10 | 0 | Number of IRLM unlock requests propagated to MVS XES synch. | ||
| 7 | QTGAIGLO |
DB2TGSIGLO | DB2DEC10V | DEC | 10 | 0 | Number of suspends caused by IRLM global resource contention | ||
| 8 | QTGASGLO |
DB2TGSSGLO | DB2DEC10V | DEC | 10 | 0 | Suspends caused by MVS XES global resource contention | ||
| 9 | QTGAFLSE |
DB2TGSFLSE | DB2DEC10V | DEC | 10 | 0 | Number of suspends because of false contentions | ||
| 10 | QTGADRTA |
DB2TGSDRTA | DB2DEC10V | DEC | 10 | 0 | Incompatible retained lock | ||
| 11 | QTGANTFY |
DB2TGSNTFY | DB2DEC10V | DEC | 10 | 0 | Number of Notification Messages Sent to Other Members | ||
| 12 | GCONTRATE |
DB2TGCONRA | DB2CHAR10 | CHAR | 10 | 0 | Global contention rate | ||
| 13 | FCONTRATE |
DB2TFCONRA | DB2CHAR10 | CHAR | 10 | 0 | False contention rate | ||
| 14 | TLOPTRATE |
DB2TTLOPRA | DB2CHAR10 | CHAR | 10 | 0 | Transaction locking optimization rate |
History
| Last changed by/on | SAP | 20141013 |
| SAP Release Created in | 700 |
