SAP ABAP Table DB6_XCHG_APPLUOW (DB6: exchange data for calling the appl / UOW details)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Basic Data

Table Category	INTTAB	Structure
Structure	DB6_XCHG_APPLUOW	Table Relationship Diagram
Short Description	DB6: exchange data for calling the appl / UOW details

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	WA_UOW	☐	DB6MON_UOW		STRU	0	0
2	SERVICE_SUPERCLASS_NAME	☐			SSTR	128	0
3	SERVICE_SUBCLASS_NAME	☐			SSTR	128	0
4	SERVICE_CLASS_ID	☐			INT4	10	0
5	MEMBER	☐			INT4	10	0
6	COORD_MEMBER	☐			INT4	10	0
7	APPLICATION_HANDLE	☐			DEC	22	0
8	WORKLOAD_NAME	☐			SSTR	128	0
9	WORKLOAD_OCCURRENCE_ID	☐			INT4	10	0
10	UOW_ID	☐			INT4	10	0
11	WORKLOAD_OCCURRENCE_STATE	☐			CHAR	32	0
12	CLIENT_WRKSTNNAME	☐			STRG	0	0
13	CLIENT_ACCTNG	☐			STRG	0	0
14	CLIENT_USERID	☐			STRG	0	0
15	CLIENT_APPLNAME	☐			STRG	0	0
16	UOW_START_TIME	☐			STRG	0	0
17	ACT_ABORTED_TOTAL	☐			DEC	22	0
18	ACT_COMPLETED_TOTAL	☐			DEC	22	0
19	ACT_REJECTED_TOTAL	☐			DEC	22	0
20	AGENT_WAIT_TIME	☐			DEC	22	0
21	AGENT_WAITS_TOTAL	☐			DEC	22	0
22	POOL_DATA_L_READS	☐			DEC	22	0
23	POOL_INDEX_L_READS	☐			DEC	22	0
24	POOL_TEMP_DATA_L_READS	☐			DEC	22	0
25	POOL_TEMP_INDEX_L_READS	☐			DEC	22	0
26	POOL_TEMP_XDA_L_READS	☐			DEC	22	0
27	POOL_XDA_L_READS	☐			DEC	22	0
28	POOL_DATA_P_READS	☐			DEC	22	0
29	POOL_INDEX_P_READS	☐			DEC	22	0
30	POOL_TEMP_DATA_P_READS	☐			DEC	22	0
31	POOL_TEMP_INDEX_P_READS	☐			DEC	22	0
32	POOL_TEMP_XDA_P_READS	☐			DEC	22	0
33	POOL_XDA_P_READS	☐			DEC	22	0
34	POOL_DATA_WRITES	☐			DEC	22	0
35	POOL_INDEX_WRITES	☐			DEC	22	0
36	POOL_XDA_WRITES	☐			DEC	22	0
37	POOL_READ_TIME	☐			DEC	22	0
38	POOL_WRITE_TIME	☐			DEC	22	0
39	CLIENT_IDLE_WAIT_TIME	☐			DEC	22	0
40	DEADLOCKS	☐			DEC	22	0
41	DIRECT_READS	☐			DEC	22	0
42	DIRECT_READ_TIME	☐			DEC	22	0
43	DIRECT_WRITES	☐			DEC	22	0
44	DIRECT_WRITE_TIME	☐			DEC	22	0
45	DIRECT_READ_REQS	☐			DEC	22	0
46	DIRECT_WRITE_REQS	☐			DEC	22	0
47	FCM_RECV_VOLUME	☐			DEC	22	0
48	FCM_RECVS_TOTAL	☐			DEC	22	0
49	FCM_SEND_VOLUME	☐			DEC	22	0
50	FCM_SENDS_TOTAL	☐			DEC	22	0
51	FCM_RECV_WAIT_TIME	☐			DEC	22	0
52	FCM_SEND_WAIT_TIME	☐			DEC	22	0
53	IPC_RECV_VOLUME	☐			DEC	22	0
54	IPC_RECV_WAIT_TIME	☐			DEC	22	0
55	IPC_RECVS_TOTAL	☐			DEC	22	0
56	IPC_SEND_VOLUME	☐			DEC	22	0
57	IPC_SEND_WAIT_TIME	☐			DEC	22	0
58	IPC_SENDS_TOTAL	☐			DEC	22	0
59	LOCK_ESCALS	☐			DEC	22	0
60	LOCK_TIMEOUTS	☐			DEC	22	0
61	LOCK_WAIT_TIME	☐			DEC	22	0
62	LOCK_WAITS	☐			DEC	22	0
63	LOG_BUFFER_WAIT_TIME	☐			DEC	22	0
64	NUM_LOG_BUFFER_FULL	☐			DEC	22	0
65	LOG_DISK_WAIT_TIME	☐			DEC	22	0
66	LOG_DISK_WAITS_TOTAL	☐			DEC	22	0
67	NUM_LOCKS_HELD	☐			DEC	22	0
68	RQSTS_COMPLETED_TOTAL	☐			DEC	22	0
69	ROWS_MODIFIED	☐			DEC	22	0
70	ROWS_READ	☐			DEC	22	0
71	ROWS_RETURNED	☐			DEC	22	0
72	TCPIP_RECV_VOLUME	☐			DEC	22	0
73	TCPIP_SEND_VOLUME	☐			DEC	22	0
74	TCPIP_RECV_WAIT_TIME	☐			DEC	22	0
75	TCPIP_RECVS_TOTAL	☐			DEC	22	0
76	TCPIP_SEND_WAIT_TIME	☐			DEC	22	0
77	TCPIP_SENDS_TOTAL	☐			DEC	22	0
78	TOTAL_APP_RQST_TIME	☐			DEC	22	0
79	TOTAL_RQST_TIME	☐			DEC	22	0
80	WLM_QUEUE_TIME_TOTAL	☐			DEC	22	0
81	WLM_QUEUE_ASSIGNMENTS_TOTAL	☐			DEC	22	0
82	TOTAL_CPU_TIME	☐			DEC	22	0
83	TOTAL_WAIT_TIME	☐			DEC	22	0
84	APP_RQSTS_COMPLETED_TOTAL	☐			DEC	22	0
85	TOTAL_SECTION_SORT_TIME	☐			DEC	22	0
86	TOTAL_SECTION_SORT_PROC_TIME	☐			DEC	22	0
87	TOTAL_SECTION_SORTS	☐			DEC	22	0
88	TOTAL_SORTS	☐			DEC	22	0
89	POST_THRESHOLD_SORTS	☐			DEC	22	0
90	POST_SHRTHRESHOLD_SORTS	☐			DEC	22	0
91	SORT_OVERFLOWS	☐			DEC	22	0
92	TOTAL_COMPILE_TIME	☐			DEC	22	0
93	TOTAL_COMPILE_PROC_TIME	☐			DEC	22	0
94	TOTAL_COMPILATIONS	☐			DEC	22	0
95	TOTAL_IMPLICIT_COMPILE_TIME	☐			DEC	22	0
96	TOTAL_IMPL_COMPILE_PROC_TIME	☐			DEC	22	0
97	TOTAL_IMPLICIT_COMPILATIONS	☐			DEC	22	0
98	TOTAL_SECTION_TIME	☐			DEC	22	0
99	TOTAL_SECTION_PROC_TIME	☐			DEC	22	0
100	TOTAL_APP_SECTION_EXECUTIONS	☐			DEC	22	0
101	TOTAL_ACT_TIME	☐			DEC	22	0
102	TOTAL_ACT_WAIT_TIME	☐			DEC	22	0
103	ACT_RQSTS_TOTAL	☐			DEC	22	0
104	TOTAL_ROUTINE_TIME	☐			DEC	22	0
105	TOTAL_ROUTINE_INVOCATIONS	☐			DEC	22	0
106	TOTAL_COMMIT_TIME	☐			DEC	22	0
107	TOTAL_COMMIT_PROC_TIME	☐			DEC	22	0
108	TOTAL_APP_COMMITS	☐			DEC	22	0
109	INT_COMMITS	☐			DEC	22	0
110	TOTAL_ROLLBACK_TIME	☐			DEC	22	0
111	TOTAL_ROLLBACK_PROC_TIME	☐			DEC	22	0
112	TOTAL_APP_ROLLBACKS	☐			DEC	22	0
113	INT_ROLLBACKS	☐			DEC	22	0
114	TOTAL_RUNSTATS_TIME	☐			DEC	22	0
115	TOTAL_RUNSTATS_PROC_TIME	☐			DEC	22	0
116	TOTAL_RUNSTATS	☐			DEC	22	0
117	TOTAL_REORG_TIME	☐			DEC	22	0
118	TOTAL_REORG_PROC_TIME	☐			DEC	22	0
119	TOTAL_REORGS	☐			DEC	22	0
120	TOTAL_LOAD_TIME	☐			DEC	22	0
121	TOTAL_LOAD_PROC_TIME	☐			DEC	22	0
122	TOTAL_LOADS	☐			DEC	22	0
123	CAT_CACHE_INSERTS	☐			DEC	22	0
124	CAT_CACHE_LOOKUPS	☐			DEC	22	0
125	PKG_CACHE_INSERTS	☐			DEC	22	0
126	PKG_CACHE_LOOKUPS	☐			DEC	22	0
127	THRESH_VIOLATIONS	☐			DEC	22	0
128	NUM_LW_THRESH_EXCEEDED	☐			DEC	22	0
129	UOW_LOG_SPACE_USED	☐			DEC	22	0
130	UOW_RUNTIME	☐			DEC	22	0
131	LAST_EXECUTABLE_ID	☐			RSTR	0	0
132	POOL_QUALITY	☐			DEC	6	2
133	APPLICATION_HANDLE_STR	☐			STRG	0	0
134	COORD_WORKLOAD_OCC_STATE	☐			CHAR	32	0
135	HAS_ACTIVE_WLOCCACT	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
136	HAS_COORD_AGENT	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
137	HAS_UNCOMMITTED_ACTIVITY	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
138	PREFETCH_WAITS	☐			DEC	22	0
139	PREFETCH_WAIT_TIME	☐			DEC	22	0
140	PL_QUED_ASYNC_DATA_PAGES	☐			DEC	22	0
141	PL_QUED_ASYNC_DATA_REQS	☐			DEC	22	0
142	PL_QUED_ASYNC_INDEX_PAGES	☐			DEC	22	0
143	PL_QUED_ASYNC_INDEX_REQS	☐			DEC	22	0
144	PL_QUED_ASYNC_OTHER_REQS	☐			DEC	22	0
145	PL_QUED_ASYNC_TEMP_DATA_PAGES	☐			DEC	22	0
146	PL_QUED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
147	PL_QUED_ASYNC_TEMP_INDEX_PAGES	☐			DEC	22	0
148	PL_QUED_ASYNC_TEMP_INDEX_REQS	☐			DEC	22	0
149	PL_QUED_ASYNC_TEMP_XDA_PAGES	☐			DEC	22	0
150	PL_QUED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
151	PL_QUED_ASYNC_XDA_PAGES	☐			DEC	22	0
152	PL_QUED_ASYNC_XDA_REQS	☐			DEC	22	0
153	PL_FAILED_ASYNC_DATA_REQS	☐			DEC	22	0
154	PL_FAILED_ASYNC_INDEX_REQS	☐			DEC	22	0
155	PL_FAILED_ASYNC_OTHER_REQS	☐			DEC	22	0
156	PL_FAILED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
157	PL_FAILED_ASYNC_TEMP_INDEX_REQ	☐			DEC	22	0
158	PL_FAILED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
159	PL_FAILED_ASYNC_XDA_REQS	☐			DEC	22	0
160	POOL_COL_L_READS	☐			DEC	22	0
161	POOL_COL_P_READS	☐			DEC	22	0
162	POOL_TEMP_COL_L_READS	☐			DEC	22	0
163	POOL_TEMP_COL_P_READS	☐			DEC	22	0
164	POOL_COL_WRITES	☐			DEC	22	0
165	PL_QUED_ASYNC_COL_PAGES	☐			DEC	22	0
166	PL_QUED_ASYNC_COL_REQS	☐			DEC	22	0
167	PL_QUED_ASYNC_TEMP_COL_PAGES	☐			DEC	22	0
168	PL_QUED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
169	PL_FAILED_ASYNC_COL_REQS	☐			DEC	22	0
170	PL_FAILED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
171	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics - Direct Reads
172	PL_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
173	PL_D_GBP_INVALID_PAGES	☐			DEC	22	0
174	PL_D_GBP_L_READS	☐			DEC	22	0
175	PL_D_GBP_P_READS	☐			DEC	22	0
176	PL_D_LBP_PAGES_FOUND	☐			DEC	22	0
177	PL_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
178	PL_I_GBP_INVALID_PAGES	☐			DEC	22	0
179	PL_I_GBP_L_READS	☐			DEC	22	0
180	PL_I_GBP_P_READS	☐			DEC	22	0
181	PL_I_LBP_PAGES_FOUND	☐			DEC	22	0
182	PL_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
183	PL_X_GBP_INVALID_PAGES	☐			DEC	22	0
184	PL_X_GBP_L_READS	☐			DEC	22	0
185	PL_X_GBP_P_READS	☐			DEC	22	0
186	PL_X_LBP_PAGES_FOUND	☐			DEC	22	0
187	PL_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
188	PL_C_GBP_INVALID_PAGES	☐			DEC	22	0
189	PL_C_GBP_L_READS	☐			DEC	22	0
190	PL_C_GBP_P_READS	☐			DEC	22	0
191	PL_C_LBP_PAGES_FOUND	☐			DEC	22	0
192	LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
193	LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
194	GBP_HIT_RATIO	☐			DEC	22	2
195	D_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
196	D_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
197	D_GBP_HIT_RATIO	☐			DEC	22	2
198	I_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
199	I_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
200	I_GBP_HIT_RATIO	☐			DEC	22	2
201	X_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
202	X_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
203	X_GBP_HIT_RATIO	☐			DEC	22	2
204	C_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
205	C_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
206	C_GBP_HIT_RATIO	☐			DEC	22	2
207	IT_WLOCCACTS	☐	DB6WLM_WLOCCACT_TAB		TTYP	0	0
208	IT_SCAGENTS	☐	DB6WLM_SC_AGENTS_TAB		TTYP	0	0
209	IT_AGENT_MEM_POOLS	☐	DB6PMSAGENT_MEMORY_POOL_TAB		TTYP	0	0

History

Last changed by/on	SAP	20141013
SAP Release Created in	720