SAP ABAP Table DB6_VIEW_AGENTUOW_DETAILS (DB6: view data structure for Agent / 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_VIEW_AGENTUOW_DETAILS	Table Relationship Diagram
Short Description	DB6: view data structure for Agent / 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_SCAGENTS	☐	DB6WLM_SC_AGENTS_TAB		TTYP	0	0
208	IT_WLOCCACTS	☐	DB6WLM_WLOCCACT_TAB		TTYP	0	0
209	WA_SCAGENTS	☐	DB6WLM_SC_AGENTS		STRU	0	0
210	SSC_NAME	☐			CHAR	128	0
211	SC_NAME	☐			CHAR	128	0
212	APPL_HANDLE	☐			DEC	22	0
213	PARTITN	☐	DB6PARTNAM		CHAR	4	0	DB6: Partition Name for Listbox Element
214	DBPARTITIONNUM	☐			INT4	10	0
215	ENTITY	☐			CHAR	32	0
216	WL_NAME	☐			CHAR	128	0
217	WL_OCCURRENCE_ID	☐			INT4	10	0
218	UOW_ID	☐			INT4	10	0
219	ACTIVITY_ID	☐			INT4	10	0
220	PARENT_UOW_ID	☐			INT4	10	0
221	PARENT_ACTIVITY_ID	☐			INT4	10	0
222	AGENT_TID	☐			DEC	22	0
223	AGENT_TYPE	☐			CHAR	32	0
224	SMP_COORDINATOR	☐			CHAR	4	0
225	AGENT_SUBTYPE	☐			CHAR	32	0
226	AGENT_STATE	☐			CHAR	32	0
227	EVENT_TYPE	☐			CHAR	32	0
228	EVENT_OBJECT	☐			CHAR	32	0
229	EVENT_STATE	☐			CHAR	32	0
230	REQUEST_ID	☐			CHAR	64	0
231	REQUEST_TYPE	☐			CHAR	32	0
232	NESTING_LEVEL	☐			INT4	10	0
233	INVOCATION_ID	☐			INT4	10	0
234	ROUTINE_ID	☐			INT4	10	0
235	EVENT_OBJECT_NAME	☐			STRG	0	0
236	APPLICATION_NAME	☐			SSTR	128	0
237	APPLICATION_ID	☐			SSTR	128	0
238	CLIENT_PID	☐			DEC	22	0
239	SESSION_AUTH_ID	☐			SSTR	128	0
240	REQUEST_START_TIME	☐			STRG	0	0
241	AGENT_STATE_LAST_UPDATE_TIME	☐			STRG	0	0
242	EXECUTABLE_ID	☐			RSTR	0	0
243	CURRENT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
244	IPADDRESS	☐	NI_NODEADDR	NI_NODEADDR	CHAR	45	0	IP Address
245	WA_WLOCCACTS	☐	DB6WLM_WLOCCACT		STRU	0	0
246	COORD_MEMBER_IMAGE	☐	DB6PARTNAM		CHAR	4	0	DB6: Partition Name for Listbox Element
247	MEMBER_IMAGE	☐	DB6PARTNAM		CHAR	4	0	DB6: Partition Name for Listbox Element
248	APPLICATION_HANDLE	☐			DEC	22	0
249	DBPARTITIONNUM	☐			INT4	10	0
250	COORD_PARTITION_NUM	☐			INT4	10	0
251	LOCAL_START_TIME	☐			STRG	0	0
252	UOW_ID	☐			INT4	10	0
253	ACTIVITY_ID	☐			INT4	10	0
254	PARENT_UOW_ID	☐			INT4	10	0
255	PARENT_ACTIVITY_ID	☐			INT4	10	0
256	ACTIVITY_STATE	☐			CHAR	32	0
257	ACTIVITY_TYPE	☐			CHAR	32	0
258	NESTING_LEVEL	☐			INT4	10	0
259	INVOCATION_ID	☐			INT4	10	0
260	ROUTINE_ID	☐			INT4	10	0
261	UTILITY_ID	☐			INT4	10	0
262	SERVICE_CLASS_ID	☐			INT4	10	0
263	DATABASE_WORK_ACTION_SET_ID	☐			INT4	10	0
264	DATABASE_WORK_CLASS_ID	☐			INT4	10	0
265	SC_WORK_ACTION_SET_ID	☐			INT4	10	0
266	SC_WORK_CLASS_ID	☐			INT4	10	0
267	EXECUTABLE_ID	☐			RSTR	0	0
268	TOTAL_CPU_TIME	☐			DEC	22	0
269	ROWS_READ	☐			DEC	22	0
270	ROWS_RETURNED	☐			DEC	22	0
271	QUERY_COST_ESTIMATE	☐			DEC	22	0
272	DIRECT_READS	☐			DEC	22	0
273	DIRECT_WRITES	☐			DEC	22	0
274	PKGC_STMT	☐	DB6MON_PKGC_STMT		STRU	0	0
275	.INCLUDE	☐				0	0	DB6: Package Cache Statement DB structure
276	MEMBER	☐			INT4	10	0
277	SECTION_TYPE	☐			CHAR	1	0
278	INSERT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
279	EXECUTABLE_ID	☐			RSTR	0	0
280	PACKAGE_SCHEMA	☐			SSTR	128	0
281	PACKAGE_NAME	☐			SSTR	128	0
282	PACKAGE_VERSION_ID	☐			SSTR	64	0
283	SECTION_NUMBER	☐			DEC	22	0
284	EFFECTIVE_ISOLATION	☐			CHAR	2	0
285	NUM_EXECUTIONS	☐			DEC	22	0
286	NUM_EXEC_WITH_METRICS	☐			DEC	22	0
287	PREP_TIME	☐			DEC	22	0
288	TOTAL_ACT_TIME	☐			DEC	22	0
289	TOTAL_ACT_WAIT_TIME	☐			DEC	22	0
290	TOTAL_CPU_TIME	☐			DEC	22	0
291	POOL_READ_TIME	☐			DEC	22	0
292	POOL_WRITE_TIME	☐			DEC	22	0
293	DIRECT_READ_TIME	☐			DEC	22	0
294	DIRECT_WRITE_TIME	☐			DEC	22	0
295	LOCK_WAIT_TIME	☐			DEC	22	0
296	TOTAL_SECTION_SORT_TIME	☐			DEC	22	0
297	TOTAL_SECTION_SORT_PROC_TIME	☐			DEC	22	0
298	TOTAL_SECTION_SORTS	☐			DEC	22	0
299	LOCK_ESCALS	☐			DEC	22	0
300	LOCK_WAITS	☐			DEC	22	0
301	ROWS_MODIFIED	☐			DEC	22	0
302	ROWS_READ	☐			DEC	22	0
303	ROWS_RETURNED	☐			DEC	22	0
304	DIRECT_READS	☐			DEC	22	0
305	DIRECT_READ_REQS	☐			DEC	22	0
306	DIRECT_WRITES	☐			DEC	22	0
307	DIRECT_WRITE_REQS	☐			DEC	22	0
308	POOL_DATA_L_READS	☐			DEC	22	0
309	POOL_TEMP_DATA_L_READS	☐			DEC	22	0
310	POOL_XDA_L_READS	☐			DEC	22	0
311	POOL_TEMP_XDA_L_READS	☐			DEC	22	0
312	POOL_INDEX_L_READS	☐			DEC	22	0
313	POOL_TEMP_INDEX_L_READS	☐			DEC	22	0
314	POOL_DATA_P_READS	☐			DEC	22	0
315	POOL_TEMP_DATA_P_READS	☐			DEC	22	0
316	POOL_XDA_P_READS	☐			DEC	22	0
317	POOL_TEMP_XDA_P_READS	☐			DEC	22	0
318	POOL_INDEX_P_READS	☐			DEC	22	0
319	POOL_TEMP_INDEX_P_READS	☐			DEC	22	0
320	POOL_DATA_WRITES	☐			DEC	22	0
321	POOL_XDA_WRITES	☐			DEC	22	0
322	POOL_INDEX_WRITES	☐			DEC	22	0
323	TOTAL_SORTS	☐			DEC	22	0
324	POST_THRESHOLD_SORTS	☐			DEC	22	0
325	POST_SHRTHRESHOLD_SORTS	☐			DEC	22	0
326	SORT_OVERFLOWS	☐			DEC	22	0
327	WLM_QUEUE_TIME_TOTAL	☐			DEC	22	0
328	WLM_QUEUE_ASSIGNMENTS_TOTAL	☐			DEC	22	0
329	DEADLOCKS	☐			DEC	22	0
330	FCM_RECV_VOLUME	☐			DEC	22	0
331	FCM_RECVS_TOTAL	☐			DEC	22	0
332	FCM_SEND_VOLUME	☐			DEC	22	0
333	FCM_SENDS_TOTAL	☐			DEC	22	0
334	FCM_RECV_WAIT_TIME	☐			DEC	22	0
335	FCM_SEND_WAIT_TIME	☐			DEC	22	0
336	LOCK_TIMEOUTS	☐			DEC	22	0
337	LOG_BUFFER_WAIT_TIME	☐			DEC	22	0
338	NUM_LOG_BUFFER_FULL	☐			DEC	22	0
339	LOG_DISK_WAIT_TIME	☐			DEC	22	0
340	LOG_DISK_WAITS_TOTAL	☐			DEC	22	0
341	LAST_METRICS_UPDATE	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
342	NUM_COORD_EXEC	☐			DEC	22	0
343	NUM_COORD_EXEC_WITH_METRICS	☐			DEC	22	0
344	VALID	☐			CHAR	1	0
345	TOTAL_ROUTINE_TIME	☐			DEC	22	0
346	TOTAL_ROUTINE_INVOCATIONS	☐			DEC	22	0
347	ROUTINE_ID	☐			DEC	22	0
348	STMT_TYPE_ID	☐			CHAR	32	0
349	QUERY_COST_ESTIMATE	☐			DEC	22	0
350	STMT_PKG_CACHE_ID	☐			DEC	22	0
351	COORD_STMT_EXEC_TIME	☐			DEC	22	0
352	STMT_EXEC_TIME	☐			DEC	22	0
353	TOTAL_SECTION_TIME	☐			DEC	22	0
354	TOTAL_SECTION_PROC_TIME	☐			DEC	22	0
355	TOTAL_ROUTINE_NON_SECT_TIME	☐			DEC	22	0
356	TOTAL_ROUTINE_NON_SECT_PROC_TI	☐			DEC	22	0
357	AVG_COORD_STMT_EXEC_TIME	☐			DEC	22	2
358	ROWS_READ_PER_ROWS_PROCESSED	☐			DEC	22	0
359	BP_GETS_PER_ROWS_PROCESSED	☐			DEC	22	0
360	POOL_QUALITY	☐			DEC	6	2
361	COORD_MEMBER	☐			INT4	10	0
362	MEMBER_COUNT	☐			INT2	5	0
363	PREFETCH_WAITS	☐			DEC	22	0
364	PREFETCH_WAIT_TIME	☐			DEC	22	0
365	PL_QUED_ASYNC_DATA_PAGES	☐			DEC	22	0
366	PL_QUED_ASYNC_DATA_REQS	☐			DEC	22	0
367	PL_QUED_ASYNC_INDEX_PAGES	☐			DEC	22	0
368	PL_QUED_ASYNC_INDEX_REQS	☐			DEC	22	0
369	PL_QUED_ASYNC_OTHER_REQS	☐			DEC	22	0
370	PL_QUED_ASYNC_TEMP_DATA_PAGES	☐			DEC	22	0
371	PL_QUED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
372	PL_QUED_ASYNC_TEMP_INDEX_PAGES	☐			DEC	22	0
373	PL_QUED_ASYNC_TEMP_INDEX_REQS	☐			DEC	22	0
374	PL_QUED_ASYNC_TEMP_XDA_PAGES	☐			DEC	22	0
375	PL_QUED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
376	PL_QUED_ASYNC_XDA_PAGES	☐			DEC	22	0
377	PL_QUED_ASYNC_XDA_REQS	☐			DEC	22	0
378	PL_FAILED_ASYNC_DATA_REQS	☐			DEC	22	0
379	PL_FAILED_ASYNC_INDEX_REQS	☐			DEC	22	0
380	PL_FAILED_ASYNC_OTHER_REQS	☐			DEC	22	0
381	PL_FAILED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
382	PL_FAILED_ASYNC_TEMP_INDEX_REQ	☐			DEC	22	0
383	PL_FAILED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
384	PL_FAILED_ASYNC_XDA_REQS	☐			DEC	22	0
385	POOL_COL_L_READS	☐			DEC	22	0
386	POOL_COL_P_READS	☐			DEC	22	0
387	POOL_TEMP_COL_L_READS	☐			DEC	22	0
388	POOL_TEMP_COL_P_READS	☐			DEC	22	0
389	POOL_COL_WRITES	☐			DEC	22	0
390	PL_QUED_ASYNC_COL_PAGES	☐			DEC	22	0
391	PL_QUED_ASYNC_COL_REQS	☐			DEC	22	0
392	PL_QUED_ASYNC_TEMP_COL_PAGES	☐			DEC	22	0
393	PL_QUED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
394	PL_FAILED_ASYNC_COL_REQS	☐			DEC	22	0
395	PL_FAILED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
396	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics - Direct Reads
397	PL_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
398	PL_D_GBP_INVALID_PAGES	☐			DEC	22	0
399	PL_D_GBP_L_READS	☐			DEC	22	0
400	PL_D_GBP_P_READS	☐			DEC	22	0
401	PL_D_LBP_PAGES_FOUND	☐			DEC	22	0
402	PL_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
403	PL_I_GBP_INVALID_PAGES	☐			DEC	22	0
404	PL_I_GBP_L_READS	☐			DEC	22	0
405	PL_I_GBP_P_READS	☐			DEC	22	0
406	PL_I_LBP_PAGES_FOUND	☐			DEC	22	0
407	PL_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
408	PL_X_GBP_INVALID_PAGES	☐			DEC	22	0
409	PL_X_GBP_L_READS	☐			DEC	22	0
410	PL_X_GBP_P_READS	☐			DEC	22	0
411	PL_X_LBP_PAGES_FOUND	☐			DEC	22	0
412	PL_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
413	PL_C_GBP_INVALID_PAGES	☐			DEC	22	0
414	PL_C_GBP_L_READS	☐			DEC	22	0
415	PL_C_GBP_P_READS	☐			DEC	22	0
416	PL_C_LBP_PAGES_FOUND	☐			DEC	22	0
417	LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
418	LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
419	GBP_HIT_RATIO	☐			DEC	22	2
420	D_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
421	D_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
422	D_GBP_HIT_RATIO	☐			DEC	22	2
423	I_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
424	I_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
425	I_GBP_HIT_RATIO	☐			DEC	22	2
426	X_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
427	X_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
428	X_GBP_HIT_RATIO	☐			DEC	22	2
429	C_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
430	C_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
431	C_GBP_HIT_RATIO	☐			DEC	22	2
432	LOCK_WAITS_GLOBAL	☐			DEC	22	0
433	LOCK_WAIT_TIME_GLOBAL	☐			DEC	22	0
434	LOCK_TIMEOUTS_GLOBAL	☐			DEC	22	0
435	LOCK_ESCALS_MAXLOCKS	☐			DEC	22	0
436	LOCK_ESCALS_LOCKLIST	☐			DEC	22	0
437	LOCK_ESCALS_GLOBAL	☐			DEC	22	0
438	RECLAIM_WAIT_TIME	☐			DEC	22	0
439	SPACEMAPPAGE_RECLAIM_WAIT_TIME	☐			DEC	22	0
440	TOTAL_RECLAIM_WAIT_TIME	☐			DEC	22	0
441	CF_WAITS	☐			DEC	22	0
442	CF_WAIT_TIME	☐			DEC	22	0
443	STMT_TEXT	☐			STRG	0	0
444	COLOR	☐	LVC_CIFNM	CHAR30	CHAR	30	0	ALV control: Field name with simple row color coding
445	MEMBER_IMAGE	☐	DB6PARTNAM		CHAR	4	0	DB6: Partition Name for Listbox Element
446	SHORT_STMT_TEXT	☐			STRG	0	0
447	STMT_HASH_VALUE	☐			INT4	10	0
448	COMP_ENV_DESC	☐			RSTR	0	0
449	COORD_MEMBER_IMAGE	☐			CHAR	10	0
450	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
451	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
452	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
453	TIME_PERIOD	☐			INT4	10	0
454	EXPLAIN_VERSION	☐			INT4	10	0
455	EXPLAIN_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
456	REMOVED_DETECTION_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
457	HAS_WLOCCACT	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
458	HAS_SCAGENTS	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
459	ACTIVITIES_TITLE	☐			STRG	0	0
460	STATEMENT_TITLE	☐			STRG	0	0

History

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