SAP ABAP Table DB2QTGS (DB2/390: Statistics Global Locking)
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 | DB2QTGS |
Table Relationship Diagram 
|
| Short Description | DB2/390: Statistics Global Locking |
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 |  QTGSLPLK |
DB2TGSLPLK | DB2DEC10V | DEC | 10 | 0 | Number of lock requests for P-locks | ||
| 2 | QTGSUPLK |
DB2TGSUPLK | DB2DEC10V | DEC | 10 | 0 | Number of unlock requests for P-locks | ||
| 3 | QTGSCPLK |
DB2TGSCPLK | DB2DEC10V | DEC | 10 | 0 | Number of Change Requests for P-Locks | ||
| 4 | QTGSLSLM |
DB2TGSLSLM | DB2DEC10V | DEC | 10 | 0 | Number of lock requests propagated to MVS XES synchronously | ||
| 5 | QTGSUSLM |
DB2TGSUSLM | DB2DEC10V | DEC | 10 | 0 | Number of IRLM unlock requests propagated to MVS XES synch. | ||
| 6 | QTGSIGLO |
DB2TGSIGLO | DB2DEC10V | DEC | 10 | 0 | Number of suspends caused by IRLM global resource contention | ||
| 7 | QTGSSGLO |
DB2TGSSGLO | DB2DEC10V | DEC | 10 | 0 | Suspends caused by MVS XES global resource contention | ||
| 8 | QTGSFLSE |
DB2TGSFLSE | DB2DEC10V | DEC | 10 | 0 | Number of suspends because of false contentions | ||
| 9 | QTGSDRTA |
DB2TGSDRTA | DB2DEC10V | DEC | 10 | 0 | Incompatible retained lock | ||
| 10 | QTGSNTFY |
DB2TGSNTFY | DB2DEC10V | DEC | 10 | 0 | Number of Notification Messages Sent to Other Members | ||
| 11 | QTGSNTFR |
DB2TGSNTFR | DB2DEC10V | DEC | 10 | 0 | Number of Notification Messages Received from Other Members | ||
| 12 | QTGSKIDS |
DB2TGSKIDS | DB2DEC10V | DEC | 10 | 0 | Number of resources propagated by IRLM to MVS XES async. | ||
| 13 | QTGSPPPE |
DB2TGSPPPE | DB2DEC10V | DEC | 10 | 0 | Page Set/Partition P-Lock Negotiation | ||
| 14 | QTGSPGPE |
DB2TGSPGPE | DB2DEC10V | DEC | 10 | 0 | Page P-Lock Negotiation | ||
| 15 | QTGSOTPE |
DB2TGSOTPE | DB2DEC10V | DEC | 10 | 0 | Other P-Lock Negotiation | ||
| 16 | QTGSCHNP |
DB2TGSCHNP | DB2DEC10V | DEC | 10 | 0 | P-Lock Change Request During P-Lock Negotiation | ||
| 17 | QTGSPEMX |
DB2TGSPEMX | DB2DEC10V | DEC | 10 | 0 | Maximum Engines for P-Lock/Notify Exits | ||
| 18 | QTGSPEQW |
DB2TGSPEQW | DB2DEC10V | DEC | 10 | 0 | Engines Unavailable for P-Lock/Notify Exits | ||
| 19 | QTGSCSLM |
DB2TGSCSLM | DB2DEC10V | DEC | 10 | 0 | No. of Change Requests Propagated to MVS XES Synchronously | ||
| 20 | QTGSFLMG |
DB2TGSFLMG | DB2DEC10V | DEC | 10 | 0 | False contention on z/OS image |
History
| Last changed by/on | SAP | 20141013 |
| SAP Release Created in | 620 |
