SAP ABAP Table DB6_VIEW_ALERT (DB6: Alert View)

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_ALERT	Table Relationship Diagram
Short Description	DB6: Alert View

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	EX	☐			STRG	0	0
2	SPMODE	☐			STRG	0	0
3	TOGGLE_CHECKED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
4	PER_VALUE	☐			INT4	10	0
5	WA	☐	DB6PM1ST4		STRU	0	0
6	PARTITN	☐			INT4	10	0
7	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
8	COMPTIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
9	LAST_RESET	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
10	BUFFPAGE	☐			DEC	22	0
11	BP_SZ	☐			DEC	22	0
12	BP_QAL	☐			DEC	8	2
13	BP_AV_RTM	☐			DEC	22	2
14	BP_AV_WTM	☐			DEC	22	2
15	BP_D_HITRT	☐			DEC	8	2
16	BP_I_HITRT	☐			DEC	8	2
17	BP_NUM	☐			DEC	22	0
18	PL_D_LRS	☐			DEC	22	0
19	PL_D_PRS	☐			DEC	22	0
20	PL_D_WS	☐			DEC	22	0
21	BP_D_SPRS	☐			DEC	22	0
22	BP_D_SWS	☐			DEC	22	0
23	PL_I_LRS	☐			DEC	22	0
24	PL_I_PRS	☐			DEC	22	0
25	PL_I_WS	☐			DEC	22	0
26	BP_I_SPRS	☐			DEC	22	0
27	BP_I_SWS	☐			DEC	22	0
28	PL_RD_TM	☐			DEC	22	0
29	PL_WT_TM	☐			DEC	22	0
30	CATCA_SZ	☐			DEC	22	0
31	CATCA_QAL	☐			DEC	8	2
32	MAXAPPLS	☐			DEC	22	0
33	PKG_CA_SZ	☐			DEC	22	0
34	PKG_CA_QAL	☐			DEC	8	2
35	CATCA_LKU	☐			DEC	22	0
36	CATCA_INS	☐			DEC	22	0
37	CATCA_OF	☐			DEC	22	0
38	CATCA_HPFL	☐			DEC	22	0
39	PKG_CA_LKU	☐			DEC	22	0
40	PKG_CA_INS	☐			DEC	22	0
41	PKG_NUM_OV	☐			DEC	22	0
42	PKG_SZ_TOP	☐			DEC	22	0
43	NUM_IOSVRS	☐			DEC	22	0
44	AV_ASP_RTM	☐			DEC	22	2
45	NUM_IOCLNS	☐			DEC	22	0
46	AV_ASP_WTM	☐			DEC	22	2
47	PL_A_DRS	☐			DEC	22	0
48	PL_A_DWS	☐			DEC	22	0
49	PL_A_IRS	☐			DEC	22	0
50	PL_A_IWS	☐			DEC	22	0
51	PL_A_RTM	☐			DEC	22	0
52	PL_A_WTM	☐			DEC	22	0
53	LCKLISTSZ	☐			DEC	22	0
54	LCK_LSTIU	☐			DEC	22	0
55	LCK_ESCALS	☐			DEC	22	0
56	X_LCK_ESCA	☐			DEC	22	0
57	LCK_WAITS	☐			DEC	22	0
58	LCK_W_TM	☐			DEC	22	0
59	AV_WTM_LCK	☐			DEC	22	2
60	LCKS_HELD	☐			DEC	22	0
61	DEADLOCKS	☐			DEC	22	0
62	LCK_TMOUT	☐			DEC	22	0
63	CMMT_SQLST	☐			DEC	22	0
64	RBCK_SQLST	☐			DEC	22	0
65	SELC_SQLST	☐			DEC	22	0
66	UID_SQLST	☐			DEC	22	0
67	DYN_SQLST	☐			DEC	22	0
68	STC_SQLST	☐			DEC	22	0
69	FAIL_SQLST	☐			DEC	22	0
70	DDL_SQLST	☐			DEC	22	0
71	RW_DELETED	☐			DEC	22	0
72	RW_INSRTED	☐			DEC	22	0
73	RW_SELECED	☐			DEC	22	0
74	RW_UPDATED	☐			DEC	22	0
75	SORTHEAPSZ	☐			DEC	22	0
76	SRT_HP_ALO	☐			DEC	22	0
77	TOT_SORTS	☐			DEC	22	0
78	TOT_SRT_TM	☐			DEC	22	0
79	AV_SORT_TM	☐			DEC	22	2
80	SRT_OF	☐			DEC	22	0
81	ACTIV_SORT	☐			DEC	22	0
82	DIRCT_RDS	☐			DEC	22	0
83	DIRCT_WTS	☐			DEC	22	0
84	DIRCT_RTM	☐			DEC	22	0
85	DIRCT_WTM	☐			DEC	22	0
86	DIRCT_RRQS	☐			DEC	22	0
87	DIRCT_WRQS	☐			DEC	22	0
88	AV_DCT_RTM	☐			DEC	22	2
89	AV_DCT_WTM	☐			DEC	22	2
90	AV_DCT_RDS	☐			DEC	22	2
91	AV_DCT_WTS	☐			DEC	22	2
92	PL_D_TE	☐			DEC	22	0
93	PL_D_FE	☐			DEC	22	0
94	PL_I_TE	☐			DEC	22	0
95	PL_I_FE	☐			DEC	22	0
96	TOT_LGUTOP	☐			DEC	22	0
97	SEC_LGUSTP	☐			DEC	22	0
98	SEC_LGALLO	☐			DEC	22	0
99	LOG_READS	☐			DEC	22	0
100	LOG_WRITES	☐			DEC	22	0
101	TOT_LGUAVG	☐			DEC	22	0
102	TOT_LGUSED	☐			DEC	22	0
103	TOT_LGAVL	☐			DEC	22	0
104	LOGBUFSZ	☐			DEC	22	0
105	LOGFILSIZ	☐			DEC	22	0
106	LOGPRIMARY	☐			DEC	22	0
107	LOGSECOND	☐			DEC	22	0
108	TOT_HAJN	☐			DEC	22	0
109	TOT_HALOOP	☐			DEC	22	0
110	HAJN_OF	☐			DEC	22	0
111	HAJN_SM_OF	☐			DEC	22	0
112	PL_TD_LRS	☐			DEC	22	0
113	PL_TD_PRS	☐			DEC	22	0
114	PL_TI_LRS	☐			DEC	22	0
115	PL_TI_PRS	☐			DEC	22	0
116	PL_A_DRRQ	☐			DEC	22	0
117	PL_A_IRRQ	☐			DEC	22	0
118	CATCASZTOP	☐			DEC	22	0
119	LSNGAP_PCT	☐			DEC	8	2
120	RESTRTRNGE	☐			DEC	8	2
121	AVGLWTPPAG	☐			DEC	22	2
122	AVGLWTPIO	☐			DEC	22	2
123	AVGLRTPPAG	☐			DEC	22	2
124	AVGLRTPIO	☐			DEC	22	2
125	LGBUFHITRT	☐			DEC	8	2
126	LOGREADTS	☐			DEC	22	0
127	LOGREADTNS	☐			DEC	22	0
128	LOGWRITS	☐			DEC	22	0
129	LOGWRITNS	☐			DEC	22	0
130	NUMLOGWRIO	☐			DEC	22	0
131	NUMLOGRDIO	☐			DEC	22	0
132	NUMLOGPPIO	☐			DEC	22	0
133	NUMLOGBFUL	☐			DEC	22	0
134	NUMLOGDFND	☐			DEC	22	0
135	LOGREDOREC	☐			DEC	22	0
136	LOGHELDDTY	☐			DEC	22	0
137	SOFTMAX	☐			INT4	10	0
138	SCPERHOUR	☐			DEC	22	0
139	ACTIVE_HASH_JOIN	☐			DEC	22	0
140	DBNAME	☐			CHAR	100	0
141	PL_ASYNC_XDA_RDS	☐			DEC	22	0
142	PL_ASYNC_XDA_RRQ	☐			DEC	22	0
143	PL_ASYNC_XDA_WRT	☐			DEC	22	0
144	PL_TEMP_XDA_L_RD	☐			DEC	22	0
145	PL_TEMP_XDA_P_RD	☐			DEC	22	0
146	POOL_XDA_L_READS	☐			DEC	22	0
147	POOL_XDA_P_READS	☐			DEC	22	0
148	POOL_XDA_WRITES	☐			DEC	22	0
149	POST_SHRTHRS_HAJ	☐			DEC	22	0
150	POST_SHRTHRS_SRT	☐			DEC	22	0
151	SMALLEST_LOG_AVL	☐			DEC	22	0
152	APPL_ID_OLDEST_X	☐			DEC	22	0
153	ELPSD_EXC_TIM_MS	☐			DEC	22	0
154	ELPSD_EXC_TIM_S	☐			DEC	22	0
155	NUM_DB_STORPATHS	☐			DEC	22	0
156	NUM_INDOUBT_TRAN	☐			DEC	22	0
157	PL_NO_VICTIM_BUF	☐			DEC	22	0
158	ROWS_WRITTEN	☐			DEC	22	0
159	ROWS_READ	☐			DEC	22	0
160	PRV_WS_NUM_OVFL	☐			DEC	22	0
161	PRV_WS_SCT_INSRT	☐			DEC	22	0
162	PRV_WS_SCT_LKUP	☐			DEC	22	0
163	PRV_WS_SIZE_TOP	☐			DEC	22	0
164	SHR_WS_NUM_OVFL	☐			DEC	22	0
165	SHR_WS_SCT_INSRT	☐			DEC	22	0
166	SHR_WS_SCT_LKUP	☐			DEC	22	0
167	SHR_WS_SIZE_TOP	☐			DEC	22	0
168	SORT_SHRHEAP_ALL	☐			DEC	22	0
169	SORT_SHRHEAP_TOP	☐			DEC	22	0
170	SHEAPTRES	☐			DEC	22	0
171	ACTIVE_OLAP_FUNCS	☐			DEC	22	0
172	ASYNC_RUNSTATS	☐			DEC	22	0
173	NUM_THRESHOLD_VIOLATIONS	☐			DEC	22	0
174	OLAP_FUNC_OVERFLOWS	☐			DEC	22	0
175	STATS_CACHE_SIZE	☐			DEC	22	0
176	STATS_FABRICATE_TIME	☐			DEC	22	0
177	STATS_FABRICATIONS	☐			DEC	22	0
178	SYNC_RUNSTATS	☐			DEC	22	0
179	SYNC_RUNSTATS_TIME	☐			DEC	22	0
180	ACC_EFFICIENCY	☐			DEC	22	1
181	BPGETS_ROWRET	☐			DEC	22	1
182	BPGETS_EXEC	☐			DEC	22	1
183	SUBMISQLST	☐			DEC	22	0
184	UNREADPFPG	☐			DEC	22	0
185	PREFETCH_WAITS	☐			DEC	22	0
186	PREFETCH_WAIT_TIME	☐			DEC	22	0
187	SKP_PRF_DATA_P_READS	☐			DEC	22	0
188	SKP_PRF_INDEX_P_READS	☐			DEC	22	0
189	SKP_PRF_TEMP_DATA_P_READS	☐			DEC	22	0
190	SKP_PRF_TEMP_INDEX_P_READS	☐			DEC	22	0
191	SKP_PRF_TEMP_XDA_P_READS	☐			DEC	22	0
192	SKP_PRF_UOW_DATA_P_READS	☐			DEC	22	0
193	SKP_PRF_UOW_INDEX_P_READS	☐			DEC	22	0
194	SKP_PRF_UOW_TEMP_DATA_P_READS	☐			DEC	22	0
195	SKP_PRF_UOW_TEMP_INDEX_P_READS	☐			DEC	22	0
196	SKP_PRF_UOW_TEMP_XDA_P_READS	☐			DEC	22	0
197	SKP_PRF_UOW_XDA_P_READS	☐			DEC	22	0
198	SKP_PRF_XDA_P_READS	☐			DEC	22	0
199	PL_QUED_ASYNC_DATA_PAGES	☐			DEC	22	0
200	PL_QUED_ASYNC_DATA_REQS	☐			DEC	22	0
201	PL_QUED_ASYNC_INDEX_PAGES	☐			DEC	22	0
202	PL_QUED_ASYNC_INDEX_REQS	☐			DEC	22	0
203	PL_QUED_ASYNC_OTHER_REQS	☐			DEC	22	0
204	PL_QUED_ASYNC_TEMP_DATA_PAGES	☐			DEC	22	0
205	PL_QUED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
206	PL_QUED_ASYNC_TEMP_INDEX_PAGES	☐			DEC	22	0
207	PL_QUED_ASYNC_TEMP_INDEX_REQS	☐			DEC	22	0
208	PL_QUED_ASYNC_TEMP_XDA_PAGES	☐			DEC	22	0
209	PL_QUED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
210	PL_QUED_ASYNC_XDA_PAGES	☐			DEC	22	0
211	PL_QUED_ASYNC_XDA_REQS	☐			DEC	22	0
212	PL_FAILED_ASYNC_DATA_REQS	☐			DEC	22	0
213	PL_FAILED_ASYNC_INDEX_REQS	☐			DEC	22	0
214	PL_FAILED_ASYNC_OTHER_REQS	☐			DEC	22	0
215	PL_FAILED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
216	PL_FAILED_ASYNC_TEMP_INDEX_REQ	☐			DEC	22	0
217	PL_FAILED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
218	PL_FAILED_ASYNC_XDA_REQS	☐			DEC	22	0
219	LAST_BACKUP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
220	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
221	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics - Direct Reads
222	PL_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
223	PL_D_GBP_INVALID_PAGES	☐			DEC	22	0
224	PL_D_GBP_L_READS	☐			DEC	22	0
225	PL_D_GBP_P_READS	☐			DEC	22	0
226	PL_D_LBP_PAGES_FOUND	☐			DEC	22	0
227	PL_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
228	PL_I_GBP_INVALID_PAGES	☐			DEC	22	0
229	PL_I_GBP_L_READS	☐			DEC	22	0
230	PL_I_GBP_P_READS	☐			DEC	22	0
231	PL_I_LBP_PAGES_FOUND	☐			DEC	22	0
232	PL_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
233	PL_X_GBP_INVALID_PAGES	☐			DEC	22	0
234	PL_X_GBP_L_READS	☐			DEC	22	0
235	PL_X_GBP_P_READS	☐			DEC	22	0
236	PL_X_LBP_PAGES_FOUND	☐			DEC	22	0
237	PL_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
238	PL_C_GBP_INVALID_PAGES	☐			DEC	22	0
239	PL_C_GBP_L_READS	☐			DEC	22	0
240	PL_C_GBP_P_READS	☐			DEC	22	0
241	PL_C_LBP_PAGES_FOUND	☐			DEC	22	0
242	LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
243	LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
244	GBP_HIT_RATIO	☐			DEC	22	2
245	D_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
246	D_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
247	D_GBP_HIT_RATIO	☐			DEC	22	2
248	I_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
249	I_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
250	I_GBP_HIT_RATIO	☐			DEC	22	2
251	X_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
252	X_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
253	X_GBP_HIT_RATIO	☐			DEC	22	2
254	C_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
255	C_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
256	C_GBP_HIT_RATIO	☐			DEC	22	2
257	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
258	PL_A_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
259	PL_A_D_GBP_INVALID_PAGES	☐			DEC	22	0
260	PL_A_D_GBP_L_READS	☐			DEC	22	0
261	PL_A_D_GBP_P_READS	☐			DEC	22	0
262	PL_A_D_LBP_PAGES_FOUND	☐			DEC	22	0
263	PL_A_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
264	PL_A_I_GBP_INVALID_PAGES	☐			DEC	22	0
265	PL_A_I_GBP_L_READS	☐			DEC	22	0
266	PL_A_I_GBP_P_READS	☐			DEC	22	0
267	PL_A_I_LBP_PAGES_FOUND	☐			DEC	22	0
268	PL_A_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
269	PL_A_X_GBP_INVALID_PAGES	☐			DEC	22	0
270	PL_A_X_GBP_L_READS	☐			DEC	22	0
271	PL_A_X_GBP_P_READS	☐			DEC	22	0
272	PL_A_X_LBP_PAGES_FOUND	☐			DEC	22	0
273	LBP_HIT_RATIO	☐			DEC	22	2
274	PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
275	D_LBP_HIT_RATIO	☐			DEC	22	2
276	D_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
277	I_LBP_HIT_RATIO	☐			DEC	22	2
278	I_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
279	X_LBP_HIT_RATIO	☐			DEC	22	2
280	X_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
281	PL_A_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
282	PL_A_C_GBP_INVALID_PAGES	☐			DEC	22	0
283	PL_A_C_GBP_L_READS	☐			DEC	22	0
284	PL_A_C_GBP_P_READS	☐			DEC	22	0
285	PL_A_C_LBP_PAGES_FOUND	☐			DEC	22	0
286	C_LBP_HIT_RATIO	☐			DEC	22	2
287	C_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
288	AVG_LOGGER_WTM	☐			DEC	22	2
289	AVG_LOGGER_RTM	☐			DEC	22	2
290	POOL_COL_L_READS	☐			DEC	22	0
291	POOL_COL_P_READS	☐			DEC	22	0
292	POOL_TEMP_COL_L_READS	☐			DEC	22	0
293	POOL_TEMP_COL_P_READS	☐			DEC	22	0
294	POOL_COL_WRITES	☐			DEC	22	0
295	PL_QUED_ASYNC_COL_PAGES	☐			DEC	22	0
296	PL_QUED_ASYNC_COL_REQS	☐			DEC	22	0
297	PL_QUED_ASYNC_TEMP_COL_PAGES	☐			DEC	22	0
298	PL_QUED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
299	PL_FAILED_ASYNC_COL_REQS	☐			DEC	22	0
300	PL_FAILED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
301	BP_C_HITRT	☐			DEC	8	2
302	BP_C_SPRS	☐			DEC	22	0
303	BP_C_SWS	☐			DEC	22	0
304	PL_ASYNC_COL_RDS	☐			DEC	22	0
305	PL_ASYNC_COL_RRQ	☐			DEC	22	0
306	PL_ASYNC_COL_WRT	☐			DEC	22	0
307	SKP_PRF_COL_P_READS	☐			DEC	22	0
308	SKP_PRF_TEMP_COL_P_READS	☐			DEC	22	0
309	SKP_PRF_UOW_COL_P_READS	☐			DEC	22	0
310	SKP_PRF_UOW_TEMP_COL_P_READS	☐			DEC	22	0
311	LOCK_WAITS_GLOBAL	☐			DEC	22	0
312	LOCK_WAIT_TIME_GLOBAL	☐			DEC	22	0
313	LOCK_TIMEOUTS_GLOBAL	☐			DEC	22	0
314	LOCK_ESCALS_MAXLOCKS	☐			DEC	22	0
315	LOCK_ESCALS_LOCKLIST	☐			DEC	22	0
316	LOCK_ESCALS_GLOBAL	☐			DEC	22	0
317	RECLAIM_WAIT_TIME	☐			DEC	22	0
318	SPACEMAPPAGE_RECLAIM_WAIT_TIME	☐			DEC	22	0
319	CF_WAITS	☐			DEC	22	0
320	CF_WAIT_TIME	☐			DEC	22	0
321	IT_DB6PMCTBS	☐	DB6PMCTBS_TABLE		TTYP	0	0
322	MRX	☐			STRG	0	0
323	SAPRUN	☐			STRG	0	0

History

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