SAP ABAP Table DB6_VIEW_DATABASE_DETAIL (DB6: View Data of Database History 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_DATABASE_DETAIL	Table Relationship Diagram
Short Description	DB6: View Data of Database History 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	IT_DB6PM1ST4	☐	DB6PM1ST4_TAB		TTYP	0	0
2	WA_DB6PM1ST4	☐	DB6PM1ST4		STRU	0	0
3	PARTITN	☐			INT4	10	0
4	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
5	COMPTIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
6	LAST_RESET	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
7	BUFFPAGE	☐			DEC	22	0
8	BP_SZ	☐			DEC	22	0
9	BP_QAL	☐			DEC	8	2
10	BP_AV_RTM	☐			DEC	22	2
11	BP_AV_WTM	☐			DEC	22	2
12	BP_D_HITRT	☐			DEC	8	2
13	BP_I_HITRT	☐			DEC	8	2
14	BP_NUM	☐			DEC	22	0
15	PL_D_LRS	☐			DEC	22	0
16	PL_D_PRS	☐			DEC	22	0
17	PL_D_WS	☐			DEC	22	0
18	BP_D_SPRS	☐			DEC	22	0
19	BP_D_SWS	☐			DEC	22	0
20	PL_I_LRS	☐			DEC	22	0
21	PL_I_PRS	☐			DEC	22	0
22	PL_I_WS	☐			DEC	22	0
23	BP_I_SPRS	☐			DEC	22	0
24	BP_I_SWS	☐			DEC	22	0
25	PL_RD_TM	☐			DEC	22	0
26	PL_WT_TM	☐			DEC	22	0
27	CATCA_SZ	☐			DEC	22	0
28	CATCA_QAL	☐			DEC	8	2
29	MAXAPPLS	☐			DEC	22	0
30	PKG_CA_SZ	☐			DEC	22	0
31	PKG_CA_QAL	☐			DEC	8	2
32	CATCA_LKU	☐			DEC	22	0
33	CATCA_INS	☐			DEC	22	0
34	CATCA_OF	☐			DEC	22	0
35	CATCA_HPFL	☐			DEC	22	0
36	PKG_CA_LKU	☐			DEC	22	0
37	PKG_CA_INS	☐			DEC	22	0
38	PKG_NUM_OV	☐			DEC	22	0
39	PKG_SZ_TOP	☐			DEC	22	0
40	NUM_IOSVRS	☐			DEC	22	0
41	AV_ASP_RTM	☐			DEC	22	2
42	NUM_IOCLNS	☐			DEC	22	0
43	AV_ASP_WTM	☐			DEC	22	2
44	PL_A_DRS	☐			DEC	22	0
45	PL_A_DWS	☐			DEC	22	0
46	PL_A_IRS	☐			DEC	22	0
47	PL_A_IWS	☐			DEC	22	0
48	PL_A_RTM	☐			DEC	22	0
49	PL_A_WTM	☐			DEC	22	0
50	LCKLISTSZ	☐			DEC	22	0
51	LCK_LSTIU	☐			DEC	22	0
52	LCK_ESCALS	☐			DEC	22	0
53	X_LCK_ESCA	☐			DEC	22	0
54	LCK_WAITS	☐			DEC	22	0
55	LCK_W_TM	☐			DEC	22	0
56	AV_WTM_LCK	☐			DEC	22	2
57	LCKS_HELD	☐			DEC	22	0
58	DEADLOCKS	☐			DEC	22	0
59	LCK_TMOUT	☐			DEC	22	0
60	CMMT_SQLST	☐			DEC	22	0
61	RBCK_SQLST	☐			DEC	22	0
62	SELC_SQLST	☐			DEC	22	0
63	UID_SQLST	☐			DEC	22	0
64	DYN_SQLST	☐			DEC	22	0
65	STC_SQLST	☐			DEC	22	0
66	FAIL_SQLST	☐			DEC	22	0
67	DDL_SQLST	☐			DEC	22	0
68	RW_DELETED	☐			DEC	22	0
69	RW_INSRTED	☐			DEC	22	0
70	RW_SELECED	☐			DEC	22	0
71	RW_UPDATED	☐			DEC	22	0
72	SORTHEAPSZ	☐			DEC	22	0
73	SRT_HP_ALO	☐			DEC	22	0
74	TOT_SORTS	☐			DEC	22	0
75	TOT_SRT_TM	☐			DEC	22	0
76	AV_SORT_TM	☐			DEC	22	2
77	SRT_OF	☐			DEC	22	0
78	ACTIV_SORT	☐			DEC	22	0
79	DIRCT_RDS	☐			DEC	22	0
80	DIRCT_WTS	☐			DEC	22	0
81	DIRCT_RTM	☐			DEC	22	0
82	DIRCT_WTM	☐			DEC	22	0
83	DIRCT_RRQS	☐			DEC	22	0
84	DIRCT_WRQS	☐			DEC	22	0
85	AV_DCT_RTM	☐			DEC	22	2
86	AV_DCT_WTM	☐			DEC	22	2
87	AV_DCT_RDS	☐			DEC	22	2
88	AV_DCT_WTS	☐			DEC	22	2
89	PL_D_TE	☐			DEC	22	0
90	PL_D_FE	☐			DEC	22	0
91	PL_I_TE	☐			DEC	22	0
92	PL_I_FE	☐			DEC	22	0
93	TOT_LGUTOP	☐			DEC	22	0
94	SEC_LGUSTP	☐			DEC	22	0
95	SEC_LGALLO	☐			DEC	22	0
96	LOG_READS	☐			DEC	22	0
97	LOG_WRITES	☐			DEC	22	0
98	TOT_LGUAVG	☐			DEC	22	0
99	TOT_LGUSED	☐			DEC	22	0
100	TOT_LGAVL	☐			DEC	22	0
101	LOGBUFSZ	☐			DEC	22	0
102	LOGFILSIZ	☐			DEC	22	0
103	LOGPRIMARY	☐			DEC	22	0
104	LOGSECOND	☐			DEC	22	0
105	TOT_HAJN	☐			DEC	22	0
106	TOT_HALOOP	☐			DEC	22	0
107	HAJN_OF	☐			DEC	22	0
108	HAJN_SM_OF	☐			DEC	22	0
109	PL_TD_LRS	☐			DEC	22	0
110	PL_TD_PRS	☐			DEC	22	0
111	PL_TI_LRS	☐			DEC	22	0
112	PL_TI_PRS	☐			DEC	22	0
113	PL_A_DRRQ	☐			DEC	22	0
114	PL_A_IRRQ	☐			DEC	22	0
115	CATCASZTOP	☐			DEC	22	0
116	LSNGAP_PCT	☐			DEC	8	2
117	RESTRTRNGE	☐			DEC	8	2
118	AVGLWTPPAG	☐			DEC	22	2
119	AVGLWTPIO	☐			DEC	22	2
120	AVGLRTPPAG	☐			DEC	22	2
121	AVGLRTPIO	☐			DEC	22	2
122	LGBUFHITRT	☐			DEC	8	2
123	LOGREADTS	☐			DEC	22	0
124	LOGREADTNS	☐			DEC	22	0
125	LOGWRITS	☐			DEC	22	0
126	LOGWRITNS	☐			DEC	22	0
127	NUMLOGWRIO	☐			DEC	22	0
128	NUMLOGRDIO	☐			DEC	22	0
129	NUMLOGPPIO	☐			DEC	22	0
130	NUMLOGBFUL	☐			DEC	22	0
131	NUMLOGDFND	☐			DEC	22	0
132	LOGREDOREC	☐			DEC	22	0
133	LOGHELDDTY	☐			DEC	22	0
134	SOFTMAX	☐			INT4	10	0
135	SCPERHOUR	☐			DEC	22	0
136	ACTIVE_HASH_JOIN	☐			DEC	22	0
137	DBNAME	☐			CHAR	100	0
138	PL_ASYNC_XDA_RDS	☐			DEC	22	0
139	PL_ASYNC_XDA_RRQ	☐			DEC	22	0
140	PL_ASYNC_XDA_WRT	☐			DEC	22	0
141	PL_TEMP_XDA_L_RD	☐			DEC	22	0
142	PL_TEMP_XDA_P_RD	☐			DEC	22	0
143	POOL_XDA_L_READS	☐			DEC	22	0
144	POOL_XDA_P_READS	☐			DEC	22	0
145	POOL_XDA_WRITES	☐			DEC	22	0
146	POST_SHRTHRS_HAJ	☐			DEC	22	0
147	POST_SHRTHRS_SRT	☐			DEC	22	0
148	SMALLEST_LOG_AVL	☐			DEC	22	0
149	APPL_ID_OLDEST_X	☐			DEC	22	0
150	ELPSD_EXC_TIM_MS	☐			DEC	22	0
151	ELPSD_EXC_TIM_S	☐			DEC	22	0
152	NUM_DB_STORPATHS	☐			DEC	22	0
153	NUM_INDOUBT_TRAN	☐			DEC	22	0
154	PL_NO_VICTIM_BUF	☐			DEC	22	0
155	ROWS_WRITTEN	☐			DEC	22	0
156	ROWS_READ	☐			DEC	22	0
157	PRV_WS_NUM_OVFL	☐			DEC	22	0
158	PRV_WS_SCT_INSRT	☐			DEC	22	0
159	PRV_WS_SCT_LKUP	☐			DEC	22	0
160	PRV_WS_SIZE_TOP	☐			DEC	22	0
161	SHR_WS_NUM_OVFL	☐			DEC	22	0
162	SHR_WS_SCT_INSRT	☐			DEC	22	0
163	SHR_WS_SCT_LKUP	☐			DEC	22	0
164	SHR_WS_SIZE_TOP	☐			DEC	22	0
165	SORT_SHRHEAP_ALL	☐			DEC	22	0
166	SORT_SHRHEAP_TOP	☐			DEC	22	0
167	SHEAPTRES	☐			DEC	22	0
168	ACTIVE_OLAP_FUNCS	☐			DEC	22	0
169	ASYNC_RUNSTATS	☐			DEC	22	0
170	NUM_THRESHOLD_VIOLATIONS	☐			DEC	22	0
171	OLAP_FUNC_OVERFLOWS	☐			DEC	22	0
172	STATS_CACHE_SIZE	☐			DEC	22	0
173	STATS_FABRICATE_TIME	☐			DEC	22	0
174	STATS_FABRICATIONS	☐			DEC	22	0
175	SYNC_RUNSTATS	☐			DEC	22	0
176	SYNC_RUNSTATS_TIME	☐			DEC	22	0
177	ACC_EFFICIENCY	☐			DEC	22	1
178	BPGETS_ROWRET	☐			DEC	22	1
179	BPGETS_EXEC	☐			DEC	22	1
180	SUBMISQLST	☐			DEC	22	0
181	UNREADPFPG	☐			DEC	22	0
182	PREFETCH_WAITS	☐			DEC	22	0
183	PREFETCH_WAIT_TIME	☐			DEC	22	0
184	SKP_PRF_DATA_P_READS	☐			DEC	22	0
185	SKP_PRF_INDEX_P_READS	☐			DEC	22	0
186	SKP_PRF_TEMP_DATA_P_READS	☐			DEC	22	0
187	SKP_PRF_TEMP_INDEX_P_READS	☐			DEC	22	0
188	SKP_PRF_TEMP_XDA_P_READS	☐			DEC	22	0
189	SKP_PRF_UOW_DATA_P_READS	☐			DEC	22	0
190	SKP_PRF_UOW_INDEX_P_READS	☐			DEC	22	0
191	SKP_PRF_UOW_TEMP_DATA_P_READS	☐			DEC	22	0
192	SKP_PRF_UOW_TEMP_INDEX_P_READS	☐			DEC	22	0
193	SKP_PRF_UOW_TEMP_XDA_P_READS	☐			DEC	22	0
194	SKP_PRF_UOW_XDA_P_READS	☐			DEC	22	0
195	SKP_PRF_XDA_P_READS	☐			DEC	22	0
196	PL_QUED_ASYNC_DATA_PAGES	☐			DEC	22	0
197	PL_QUED_ASYNC_DATA_REQS	☐			DEC	22	0
198	PL_QUED_ASYNC_INDEX_PAGES	☐			DEC	22	0
199	PL_QUED_ASYNC_INDEX_REQS	☐			DEC	22	0
200	PL_QUED_ASYNC_OTHER_REQS	☐			DEC	22	0
201	PL_QUED_ASYNC_TEMP_DATA_PAGES	☐			DEC	22	0
202	PL_QUED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
203	PL_QUED_ASYNC_TEMP_INDEX_PAGES	☐			DEC	22	0
204	PL_QUED_ASYNC_TEMP_INDEX_REQS	☐			DEC	22	0
205	PL_QUED_ASYNC_TEMP_XDA_PAGES	☐			DEC	22	0
206	PL_QUED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
207	PL_QUED_ASYNC_XDA_PAGES	☐			DEC	22	0
208	PL_QUED_ASYNC_XDA_REQS	☐			DEC	22	0
209	PL_FAILED_ASYNC_DATA_REQS	☐			DEC	22	0
210	PL_FAILED_ASYNC_INDEX_REQS	☐			DEC	22	0
211	PL_FAILED_ASYNC_OTHER_REQS	☐			DEC	22	0
212	PL_FAILED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
213	PL_FAILED_ASYNC_TEMP_INDEX_REQ	☐			DEC	22	0
214	PL_FAILED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
215	PL_FAILED_ASYNC_XDA_REQS	☐			DEC	22	0
216	LAST_BACKUP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
217	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
218	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics - Direct Reads
219	PL_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
220	PL_D_GBP_INVALID_PAGES	☐			DEC	22	0
221	PL_D_GBP_L_READS	☐			DEC	22	0
222	PL_D_GBP_P_READS	☐			DEC	22	0
223	PL_D_LBP_PAGES_FOUND	☐			DEC	22	0
224	PL_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
225	PL_I_GBP_INVALID_PAGES	☐			DEC	22	0
226	PL_I_GBP_L_READS	☐			DEC	22	0
227	PL_I_GBP_P_READS	☐			DEC	22	0
228	PL_I_LBP_PAGES_FOUND	☐			DEC	22	0
229	PL_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
230	PL_X_GBP_INVALID_PAGES	☐			DEC	22	0
231	PL_X_GBP_L_READS	☐			DEC	22	0
232	PL_X_GBP_P_READS	☐			DEC	22	0
233	PL_X_LBP_PAGES_FOUND	☐			DEC	22	0
234	PL_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
235	PL_C_GBP_INVALID_PAGES	☐			DEC	22	0
236	PL_C_GBP_L_READS	☐			DEC	22	0
237	PL_C_GBP_P_READS	☐			DEC	22	0
238	PL_C_LBP_PAGES_FOUND	☐			DEC	22	0
239	LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
240	LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
241	GBP_HIT_RATIO	☐			DEC	22	2
242	D_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
243	D_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
244	D_GBP_HIT_RATIO	☐			DEC	22	2
245	I_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
246	I_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
247	I_GBP_HIT_RATIO	☐			DEC	22	2
248	X_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
249	X_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
250	X_GBP_HIT_RATIO	☐			DEC	22	2
251	C_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
252	C_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
253	C_GBP_HIT_RATIO	☐			DEC	22	2
254	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
255	PL_A_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
256	PL_A_D_GBP_INVALID_PAGES	☐			DEC	22	0
257	PL_A_D_GBP_L_READS	☐			DEC	22	0
258	PL_A_D_GBP_P_READS	☐			DEC	22	0
259	PL_A_D_LBP_PAGES_FOUND	☐			DEC	22	0
260	PL_A_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
261	PL_A_I_GBP_INVALID_PAGES	☐			DEC	22	0
262	PL_A_I_GBP_L_READS	☐			DEC	22	0
263	PL_A_I_GBP_P_READS	☐			DEC	22	0
264	PL_A_I_LBP_PAGES_FOUND	☐			DEC	22	0
265	PL_A_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
266	PL_A_X_GBP_INVALID_PAGES	☐			DEC	22	0
267	PL_A_X_GBP_L_READS	☐			DEC	22	0
268	PL_A_X_GBP_P_READS	☐			DEC	22	0
269	PL_A_X_LBP_PAGES_FOUND	☐			DEC	22	0
270	LBP_HIT_RATIO	☐			DEC	22	2
271	PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
272	D_LBP_HIT_RATIO	☐			DEC	22	2
273	D_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
274	I_LBP_HIT_RATIO	☐			DEC	22	2
275	I_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
276	X_LBP_HIT_RATIO	☐			DEC	22	2
277	X_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
278	PL_A_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
279	PL_A_C_GBP_INVALID_PAGES	☐			DEC	22	0
280	PL_A_C_GBP_L_READS	☐			DEC	22	0
281	PL_A_C_GBP_P_READS	☐			DEC	22	0
282	PL_A_C_LBP_PAGES_FOUND	☐			DEC	22	0
283	C_LBP_HIT_RATIO	☐			DEC	22	2
284	C_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
285	AVG_LOGGER_WTM	☐			DEC	22	2
286	AVG_LOGGER_RTM	☐			DEC	22	2
287	POOL_COL_L_READS	☐			DEC	22	0
288	POOL_COL_P_READS	☐			DEC	22	0
289	POOL_TEMP_COL_L_READS	☐			DEC	22	0
290	POOL_TEMP_COL_P_READS	☐			DEC	22	0
291	POOL_COL_WRITES	☐			DEC	22	0
292	PL_QUED_ASYNC_COL_PAGES	☐			DEC	22	0
293	PL_QUED_ASYNC_COL_REQS	☐			DEC	22	0
294	PL_QUED_ASYNC_TEMP_COL_PAGES	☐			DEC	22	0
295	PL_QUED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
296	PL_FAILED_ASYNC_COL_REQS	☐			DEC	22	0
297	PL_FAILED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
298	BP_C_HITRT	☐			DEC	8	2
299	BP_C_SPRS	☐			DEC	22	0
300	BP_C_SWS	☐			DEC	22	0
301	PL_ASYNC_COL_RDS	☐			DEC	22	0
302	PL_ASYNC_COL_RRQ	☐			DEC	22	0
303	PL_ASYNC_COL_WRT	☐			DEC	22	0
304	SKP_PRF_COL_P_READS	☐			DEC	22	0
305	SKP_PRF_TEMP_COL_P_READS	☐			DEC	22	0
306	SKP_PRF_UOW_COL_P_READS	☐			DEC	22	0
307	SKP_PRF_UOW_TEMP_COL_P_READS	☐			DEC	22	0
308	LOCK_WAITS_GLOBAL	☐			DEC	22	0
309	LOCK_WAIT_TIME_GLOBAL	☐			DEC	22	0
310	LOCK_TIMEOUTS_GLOBAL	☐			DEC	22	0
311	LOCK_ESCALS_MAXLOCKS	☐			DEC	22	0
312	LOCK_ESCALS_LOCKLIST	☐			DEC	22	0
313	LOCK_ESCALS_GLOBAL	☐			DEC	22	0
314	RECLAIM_WAIT_TIME	☐			DEC	22	0
315	SPACEMAPPAGE_RECLAIM_WAIT_TIME	☐			DEC	22	0
316	CF_WAITS	☐			DEC	22	0
317	CF_WAIT_TIME	☐			DEC	22	0
318	WA_DB6PM1ST4_HISTORY	☐	DB6PM1ST4		STRU	0	0
319	PARTITN	☐			INT4	10	0
320	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
321	COMPTIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
322	LAST_RESET	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
323	BUFFPAGE	☐			DEC	22	0
324	BP_SZ	☐			DEC	22	0
325	BP_QAL	☐			DEC	8	2
326	BP_AV_RTM	☐			DEC	22	2
327	BP_AV_WTM	☐			DEC	22	2
328	BP_D_HITRT	☐			DEC	8	2
329	BP_I_HITRT	☐			DEC	8	2
330	BP_NUM	☐			DEC	22	0
331	PL_D_LRS	☐			DEC	22	0
332	PL_D_PRS	☐			DEC	22	0
333	PL_D_WS	☐			DEC	22	0
334	BP_D_SPRS	☐			DEC	22	0
335	BP_D_SWS	☐			DEC	22	0
336	PL_I_LRS	☐			DEC	22	0
337	PL_I_PRS	☐			DEC	22	0
338	PL_I_WS	☐			DEC	22	0
339	BP_I_SPRS	☐			DEC	22	0
340	BP_I_SWS	☐			DEC	22	0
341	PL_RD_TM	☐			DEC	22	0
342	PL_WT_TM	☐			DEC	22	0
343	CATCA_SZ	☐			DEC	22	0
344	CATCA_QAL	☐			DEC	8	2
345	MAXAPPLS	☐			DEC	22	0
346	PKG_CA_SZ	☐			DEC	22	0
347	PKG_CA_QAL	☐			DEC	8	2
348	CATCA_LKU	☐			DEC	22	0
349	CATCA_INS	☐			DEC	22	0
350	CATCA_OF	☐			DEC	22	0
351	CATCA_HPFL	☐			DEC	22	0
352	PKG_CA_LKU	☐			DEC	22	0
353	PKG_CA_INS	☐			DEC	22	0
354	PKG_NUM_OV	☐			DEC	22	0
355	PKG_SZ_TOP	☐			DEC	22	0
356	NUM_IOSVRS	☐			DEC	22	0
357	AV_ASP_RTM	☐			DEC	22	2
358	NUM_IOCLNS	☐			DEC	22	0
359	AV_ASP_WTM	☐			DEC	22	2
360	PL_A_DRS	☐			DEC	22	0
361	PL_A_DWS	☐			DEC	22	0
362	PL_A_IRS	☐			DEC	22	0
363	PL_A_IWS	☐			DEC	22	0
364	PL_A_RTM	☐			DEC	22	0
365	PL_A_WTM	☐			DEC	22	0
366	LCKLISTSZ	☐			DEC	22	0
367	LCK_LSTIU	☐			DEC	22	0
368	LCK_ESCALS	☐			DEC	22	0
369	X_LCK_ESCA	☐			DEC	22	0
370	LCK_WAITS	☐			DEC	22	0
371	LCK_W_TM	☐			DEC	22	0
372	AV_WTM_LCK	☐			DEC	22	2
373	LCKS_HELD	☐			DEC	22	0
374	DEADLOCKS	☐			DEC	22	0
375	LCK_TMOUT	☐			DEC	22	0
376	CMMT_SQLST	☐			DEC	22	0
377	RBCK_SQLST	☐			DEC	22	0
378	SELC_SQLST	☐			DEC	22	0
379	UID_SQLST	☐			DEC	22	0
380	DYN_SQLST	☐			DEC	22	0
381	STC_SQLST	☐			DEC	22	0
382	FAIL_SQLST	☐			DEC	22	0
383	DDL_SQLST	☐			DEC	22	0
384	RW_DELETED	☐			DEC	22	0
385	RW_INSRTED	☐			DEC	22	0
386	RW_SELECED	☐			DEC	22	0
387	RW_UPDATED	☐			DEC	22	0
388	SORTHEAPSZ	☐			DEC	22	0
389	SRT_HP_ALO	☐			DEC	22	0
390	TOT_SORTS	☐			DEC	22	0
391	TOT_SRT_TM	☐			DEC	22	0
392	AV_SORT_TM	☐			DEC	22	2
393	SRT_OF	☐			DEC	22	0
394	ACTIV_SORT	☐			DEC	22	0
395	DIRCT_RDS	☐			DEC	22	0
396	DIRCT_WTS	☐			DEC	22	0
397	DIRCT_RTM	☐			DEC	22	0
398	DIRCT_WTM	☐			DEC	22	0
399	DIRCT_RRQS	☐			DEC	22	0
400	DIRCT_WRQS	☐			DEC	22	0
401	AV_DCT_RTM	☐			DEC	22	2
402	AV_DCT_WTM	☐			DEC	22	2
403	AV_DCT_RDS	☐			DEC	22	2
404	AV_DCT_WTS	☐			DEC	22	2
405	PL_D_TE	☐			DEC	22	0
406	PL_D_FE	☐			DEC	22	0
407	PL_I_TE	☐			DEC	22	0
408	PL_I_FE	☐			DEC	22	0
409	TOT_LGUTOP	☐			DEC	22	0
410	SEC_LGUSTP	☐			DEC	22	0
411	SEC_LGALLO	☐			DEC	22	0
412	LOG_READS	☐			DEC	22	0
413	LOG_WRITES	☐			DEC	22	0
414	TOT_LGUAVG	☐			DEC	22	0
415	TOT_LGUSED	☐			DEC	22	0
416	TOT_LGAVL	☐			DEC	22	0
417	LOGBUFSZ	☐			DEC	22	0
418	LOGFILSIZ	☐			DEC	22	0
419	LOGPRIMARY	☐			DEC	22	0
420	LOGSECOND	☐			DEC	22	0
421	TOT_HAJN	☐			DEC	22	0
422	TOT_HALOOP	☐			DEC	22	0
423	HAJN_OF	☐			DEC	22	0
424	HAJN_SM_OF	☐			DEC	22	0
425	PL_TD_LRS	☐			DEC	22	0
426	PL_TD_PRS	☐			DEC	22	0
427	PL_TI_LRS	☐			DEC	22	0
428	PL_TI_PRS	☐			DEC	22	0
429	PL_A_DRRQ	☐			DEC	22	0
430	PL_A_IRRQ	☐			DEC	22	0
431	CATCASZTOP	☐			DEC	22	0
432	LSNGAP_PCT	☐			DEC	8	2
433	RESTRTRNGE	☐			DEC	8	2
434	AVGLWTPPAG	☐			DEC	22	2
435	AVGLWTPIO	☐			DEC	22	2
436	AVGLRTPPAG	☐			DEC	22	2
437	AVGLRTPIO	☐			DEC	22	2
438	LGBUFHITRT	☐			DEC	8	2
439	LOGREADTS	☐			DEC	22	0
440	LOGREADTNS	☐			DEC	22	0
441	LOGWRITS	☐			DEC	22	0
442	LOGWRITNS	☐			DEC	22	0
443	NUMLOGWRIO	☐			DEC	22	0
444	NUMLOGRDIO	☐			DEC	22	0
445	NUMLOGPPIO	☐			DEC	22	0
446	NUMLOGBFUL	☐			DEC	22	0
447	NUMLOGDFND	☐			DEC	22	0
448	LOGREDOREC	☐			DEC	22	0
449	LOGHELDDTY	☐			DEC	22	0
450	SOFTMAX	☐			INT4	10	0
451	SCPERHOUR	☐			DEC	22	0
452	ACTIVE_HASH_JOIN	☐			DEC	22	0
453	DBNAME	☐			CHAR	100	0
454	PL_ASYNC_XDA_RDS	☐			DEC	22	0
455	PL_ASYNC_XDA_RRQ	☐			DEC	22	0
456	PL_ASYNC_XDA_WRT	☐			DEC	22	0
457	PL_TEMP_XDA_L_RD	☐			DEC	22	0
458	PL_TEMP_XDA_P_RD	☐			DEC	22	0
459	POOL_XDA_L_READS	☐			DEC	22	0
460	POOL_XDA_P_READS	☐			DEC	22	0
461	POOL_XDA_WRITES	☐			DEC	22	0
462	POST_SHRTHRS_HAJ	☐			DEC	22	0
463	POST_SHRTHRS_SRT	☐			DEC	22	0
464	SMALLEST_LOG_AVL	☐			DEC	22	0
465	APPL_ID_OLDEST_X	☐			DEC	22	0
466	ELPSD_EXC_TIM_MS	☐			DEC	22	0
467	ELPSD_EXC_TIM_S	☐			DEC	22	0
468	NUM_DB_STORPATHS	☐			DEC	22	0
469	NUM_INDOUBT_TRAN	☐			DEC	22	0
470	PL_NO_VICTIM_BUF	☐			DEC	22	0
471	ROWS_WRITTEN	☐			DEC	22	0
472	ROWS_READ	☐			DEC	22	0
473	PRV_WS_NUM_OVFL	☐			DEC	22	0
474	PRV_WS_SCT_INSRT	☐			DEC	22	0
475	PRV_WS_SCT_LKUP	☐			DEC	22	0
476	PRV_WS_SIZE_TOP	☐			DEC	22	0
477	SHR_WS_NUM_OVFL	☐			DEC	22	0
478	SHR_WS_SCT_INSRT	☐			DEC	22	0
479	SHR_WS_SCT_LKUP	☐			DEC	22	0
480	SHR_WS_SIZE_TOP	☐			DEC	22	0
481	SORT_SHRHEAP_ALL	☐			DEC	22	0
482	SORT_SHRHEAP_TOP	☐			DEC	22	0
483	SHEAPTRES	☐			DEC	22	0
484	ACTIVE_OLAP_FUNCS	☐			DEC	22	0
485	ASYNC_RUNSTATS	☐			DEC	22	0
486	NUM_THRESHOLD_VIOLATIONS	☐			DEC	22	0
487	OLAP_FUNC_OVERFLOWS	☐			DEC	22	0
488	STATS_CACHE_SIZE	☐			DEC	22	0
489	STATS_FABRICATE_TIME	☐			DEC	22	0
490	STATS_FABRICATIONS	☐			DEC	22	0
491	SYNC_RUNSTATS	☐			DEC	22	0
492	SYNC_RUNSTATS_TIME	☐			DEC	22	0
493	ACC_EFFICIENCY	☐			DEC	22	1
494	BPGETS_ROWRET	☐			DEC	22	1
495	BPGETS_EXEC	☐			DEC	22	1
496	SUBMISQLST	☐			DEC	22	0
497	UNREADPFPG	☐			DEC	22	0
498	PREFETCH_WAITS	☐			DEC	22	0
499	PREFETCH_WAIT_TIME	☐			DEC	22	0
500	SKP_PRF_DATA_P_READS	☐			DEC	22	0
501	SKP_PRF_INDEX_P_READS	☐			DEC	22	0
502	SKP_PRF_TEMP_DATA_P_READS	☐			DEC	22	0
503	SKP_PRF_TEMP_INDEX_P_READS	☐			DEC	22	0
504	SKP_PRF_TEMP_XDA_P_READS	☐			DEC	22	0
505	SKP_PRF_UOW_DATA_P_READS	☐			DEC	22	0
506	SKP_PRF_UOW_INDEX_P_READS	☐			DEC	22	0
507	SKP_PRF_UOW_TEMP_DATA_P_READS	☐			DEC	22	0
508	SKP_PRF_UOW_TEMP_INDEX_P_READS	☐			DEC	22	0
509	SKP_PRF_UOW_TEMP_XDA_P_READS	☐			DEC	22	0
510	SKP_PRF_UOW_XDA_P_READS	☐			DEC	22	0
511	SKP_PRF_XDA_P_READS	☐			DEC	22	0
512	PL_QUED_ASYNC_DATA_PAGES	☐			DEC	22	0
513	PL_QUED_ASYNC_DATA_REQS	☐			DEC	22	0
514	PL_QUED_ASYNC_INDEX_PAGES	☐			DEC	22	0
515	PL_QUED_ASYNC_INDEX_REQS	☐			DEC	22	0
516	PL_QUED_ASYNC_OTHER_REQS	☐			DEC	22	0
517	PL_QUED_ASYNC_TEMP_DATA_PAGES	☐			DEC	22	0
518	PL_QUED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
519	PL_QUED_ASYNC_TEMP_INDEX_PAGES	☐			DEC	22	0
520	PL_QUED_ASYNC_TEMP_INDEX_REQS	☐			DEC	22	0
521	PL_QUED_ASYNC_TEMP_XDA_PAGES	☐			DEC	22	0
522	PL_QUED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
523	PL_QUED_ASYNC_XDA_PAGES	☐			DEC	22	0
524	PL_QUED_ASYNC_XDA_REQS	☐			DEC	22	0
525	PL_FAILED_ASYNC_DATA_REQS	☐			DEC	22	0
526	PL_FAILED_ASYNC_INDEX_REQS	☐			DEC	22	0
527	PL_FAILED_ASYNC_OTHER_REQS	☐			DEC	22	0
528	PL_FAILED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
529	PL_FAILED_ASYNC_TEMP_INDEX_REQ	☐			DEC	22	0
530	PL_FAILED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
531	PL_FAILED_ASYNC_XDA_REQS	☐			DEC	22	0
532	LAST_BACKUP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
533	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
534	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics - Direct Reads
535	PL_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
536	PL_D_GBP_INVALID_PAGES	☐			DEC	22	0
537	PL_D_GBP_L_READS	☐			DEC	22	0
538	PL_D_GBP_P_READS	☐			DEC	22	0
539	PL_D_LBP_PAGES_FOUND	☐			DEC	22	0
540	PL_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
541	PL_I_GBP_INVALID_PAGES	☐			DEC	22	0
542	PL_I_GBP_L_READS	☐			DEC	22	0
543	PL_I_GBP_P_READS	☐			DEC	22	0
544	PL_I_LBP_PAGES_FOUND	☐			DEC	22	0
545	PL_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
546	PL_X_GBP_INVALID_PAGES	☐			DEC	22	0
547	PL_X_GBP_L_READS	☐			DEC	22	0
548	PL_X_GBP_P_READS	☐			DEC	22	0
549	PL_X_LBP_PAGES_FOUND	☐			DEC	22	0
550	PL_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
551	PL_C_GBP_INVALID_PAGES	☐			DEC	22	0
552	PL_C_GBP_L_READS	☐			DEC	22	0
553	PL_C_GBP_P_READS	☐			DEC	22	0
554	PL_C_LBP_PAGES_FOUND	☐			DEC	22	0
555	LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
556	LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
557	GBP_HIT_RATIO	☐			DEC	22	2
558	D_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
559	D_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
560	D_GBP_HIT_RATIO	☐			DEC	22	2
561	I_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
562	I_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
563	I_GBP_HIT_RATIO	☐			DEC	22	2
564	X_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
565	X_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
566	X_GBP_HIT_RATIO	☐			DEC	22	2
567	C_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
568	C_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
569	C_GBP_HIT_RATIO	☐			DEC	22	2
570	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
571	PL_A_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
572	PL_A_D_GBP_INVALID_PAGES	☐			DEC	22	0
573	PL_A_D_GBP_L_READS	☐			DEC	22	0
574	PL_A_D_GBP_P_READS	☐			DEC	22	0
575	PL_A_D_LBP_PAGES_FOUND	☐			DEC	22	0
576	PL_A_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
577	PL_A_I_GBP_INVALID_PAGES	☐			DEC	22	0
578	PL_A_I_GBP_L_READS	☐			DEC	22	0
579	PL_A_I_GBP_P_READS	☐			DEC	22	0
580	PL_A_I_LBP_PAGES_FOUND	☐			DEC	22	0
581	PL_A_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
582	PL_A_X_GBP_INVALID_PAGES	☐			DEC	22	0
583	PL_A_X_GBP_L_READS	☐			DEC	22	0
584	PL_A_X_GBP_P_READS	☐			DEC	22	0
585	PL_A_X_LBP_PAGES_FOUND	☐			DEC	22	0
586	LBP_HIT_RATIO	☐			DEC	22	2
587	PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
588	D_LBP_HIT_RATIO	☐			DEC	22	2
589	D_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
590	I_LBP_HIT_RATIO	☐			DEC	22	2
591	I_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
592	X_LBP_HIT_RATIO	☐			DEC	22	2
593	X_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
594	PL_A_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
595	PL_A_C_GBP_INVALID_PAGES	☐			DEC	22	0
596	PL_A_C_GBP_L_READS	☐			DEC	22	0
597	PL_A_C_GBP_P_READS	☐			DEC	22	0
598	PL_A_C_LBP_PAGES_FOUND	☐			DEC	22	0
599	C_LBP_HIT_RATIO	☐			DEC	22	2
600	C_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
601	AVG_LOGGER_WTM	☐			DEC	22	2
602	AVG_LOGGER_RTM	☐			DEC	22	2
603	POOL_COL_L_READS	☐			DEC	22	0
604	POOL_COL_P_READS	☐			DEC	22	0
605	POOL_TEMP_COL_L_READS	☐			DEC	22	0
606	POOL_TEMP_COL_P_READS	☐			DEC	22	0
607	POOL_COL_WRITES	☐			DEC	22	0
608	PL_QUED_ASYNC_COL_PAGES	☐			DEC	22	0
609	PL_QUED_ASYNC_COL_REQS	☐			DEC	22	0
610	PL_QUED_ASYNC_TEMP_COL_PAGES	☐			DEC	22	0
611	PL_QUED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
612	PL_FAILED_ASYNC_COL_REQS	☐			DEC	22	0
613	PL_FAILED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
614	BP_C_HITRT	☐			DEC	8	2
615	BP_C_SPRS	☐			DEC	22	0
616	BP_C_SWS	☐			DEC	22	0
617	PL_ASYNC_COL_RDS	☐			DEC	22	0
618	PL_ASYNC_COL_RRQ	☐			DEC	22	0
619	PL_ASYNC_COL_WRT	☐			DEC	22	0
620	SKP_PRF_COL_P_READS	☐			DEC	22	0
621	SKP_PRF_TEMP_COL_P_READS	☐			DEC	22	0
622	SKP_PRF_UOW_COL_P_READS	☐			DEC	22	0
623	SKP_PRF_UOW_TEMP_COL_P_READS	☐			DEC	22	0
624	LOCK_WAITS_GLOBAL	☐			DEC	22	0
625	LOCK_WAIT_TIME_GLOBAL	☐			DEC	22	0
626	LOCK_TIMEOUTS_GLOBAL	☐			DEC	22	0
627	LOCK_ESCALS_MAXLOCKS	☐			DEC	22	0
628	LOCK_ESCALS_LOCKLIST	☐			DEC	22	0
629	LOCK_ESCALS_GLOBAL	☐			DEC	22	0
630	RECLAIM_WAIT_TIME	☐			DEC	22	0
631	SPACEMAPPAGE_RECLAIM_WAIT_TIME	☐			DEC	22	0
632	CF_WAITS	☐			DEC	22	0
633	CF_WAIT_TIME	☐			DEC	22	0

History

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