SAP ABAP Table DB2QTXA (SSC statitics and accounting data mapping)

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

Basic Data

Table Category	INTTAB	Structure
Structure	DB2QTXA	Table Relationship Diagram
Short Description	SSC statitics and accounting data mapping

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	QTXADEA	☐	DB2TXADEA	DB2INT4	INT4	10	0	Number of deadlocks
2	QTXASLOC	☐	DB2TXASLOC	DB2INT4	INT4	10	0	Number of lock suspensions
3	QTXATIM	☐	DB2TXATIM	DB2INT4	INT4	10	0	Number of timeouts
4	QTXALES	☐	DB2TXALES	DB2INT4	INT4	10	0	Number of lock escalations (shared)
5	QTXALEX	☐	DB2TXALEX	DB2INT4	INT4	10	0	Number of lock escalations (exclusive)
6	QTXANPL	☐	DB2TXANLP	DB2INT4	INT4	10	0	Maximum page or row locks held
7	QTXAFLG1	☐	DB2BIT01	DB2CHAR01	CHAR	1	0	Field type char, length 1, bit field
8	QTXARES1	☐	DB2RES01	DB2CHAR01	CHAR	1	0	Field type char, length 1, reserved
9	QTXARLID	☐	DB2CHAR02	DB2CHAR02	CHAR	2	0	Field type char, length 2
10	QTXAPREC	☐	DB2TXAPREC	DB2INT4	INT4	10	0	Precedence How Limit determined
11	QTXASLMT	☐	DB2TXASLMT	DB2INT4	INT4	10	0	Limit in SU's - ASUTIME Column
12	QTXACLMT	☐	DB2TXACLMT	DB2INT4	INT4	10	0	Limit in CPU 16 microseconds
13	QTXACHUS	☐	DB2TXACHUS	DB2INT4	INT4	10	0	Highest amt CPU 16 microsec used in successful DB2 call
14	QTXASLAT	☐	DB2TXASLAT	DB2INT4	INT4	10	0	Number of latch suspensions
15	QTXASOTH	☐	DB2TXASOTH	DB2INT4	INT4	10	0	Number of other suspensions
16	QTXALOCK	☐	DB2TXALOCK	DB2INT4	INT4	10	0	Number of lock requests
17	QTXALOCKD	☐	DB2TXALOCKD	DB2DEC10V	DEC	10	0	Number of lock requests
18	QTXAUNLK	☐	DB2TXAUNLK	DB2INT4	INT4	10	0	Number of unlock requests
19	QTXAUNLKD	☐	DB2TXAUNLKD	DB2DEC10V	DEC	10	0	Number of unlock requests
20	QTXAQRY	☐	DB2TXAQRY	DB2INT4	INT4	10	0	Number of query requests
21	QTXACHG	☐	DB2TXACHG	DB2INT4	INT4	10	0	Number of change requests
22	QTXAIRLM	☐	DB2TXAIRLM	DB2INT4	INT4	10	0	Number of other requests
23	QTXACLNO	☐	DB2TXACLNO	DB2INT4	INT4	10	0	Number of claim requests
24	QTXACLUN	☐	DB2TXACLUN	DB2INT4	INT4	10	0	Number of claim requests that were unsuccessful
25	QTXADRNO	☐	DB2TXADRNO	DB2INT4	INT4	10	0	Number of drain requests
26	QTXADRUN	☐	DB2TXADRUN	DB2INT4	INT4	10	0	Number of drain requests that were unsuccessful

History

Last changed by/on	SAP	20110908
SAP Release Created in