SAP ABAP Table DB6_AGENTUOW (DB6: SC Agent + UOW overview)

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_AGENTUOW	Table Relationship Diagram
Short Description	DB6: SC Agent + UOW overview

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

History

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