SAP ABAP Table DB6_VIEW_TBSNAP_DETAIL (DB6: View Data of Tablespace Snapshot 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_TBSNAP_DETAIL	Table Relationship Diagram
Short Description	DB6: View Data of Tablespace Snapshot 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	RELATIVE_LOG_INDEX	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
2	COUNT_ROWS	☐			INT4	10	0
3	TABS	☐	DB6PMSTBS		STRU	0	0
4	DBMSTRTTME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
5	COMPTIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
6	PARTITN	☐			INT4	10	0
7	TBS_NAME	☐	DB6TSPNAME		CHAR	30	0	DB6: Tablespace Name
8	BP_QAL	☐			DEC	8	2
9	BP_AV_RTM	☐			DEC	22	2
10	BP_AV_WTM	☐			DEC	22	2
11	BP_D_HITRT	☐			DEC	8	2
12	BP_I_HITRT	☐			DEC	8	2
13	PL_D_LRS	☐			DEC	22	0
14	PL_D_PRS	☐			DEC	22	0
15	PL_D_WS	☐			DEC	22	0
16	BP_D_SPRS	☐			DEC	22	0
17	BP_D_SWS	☐			DEC	22	0
18	PL_I_LRS	☐			DEC	22	0
19	PL_I_PRS	☐			DEC	22	0
20	PL_I_WS	☐			DEC	22	0
21	BP_I_SPRS	☐			DEC	22	0
22	BP_I_SWS	☐			DEC	22	0
23	PL_RD_TM	☐			DEC	22	0
24	PL_WT_TM	☐			DEC	22	0
25	AV_ASP_RTM	☐			DEC	22	2
26	AV_ASP_WTM	☐			DEC	22	2
27	PL_A_DRS	☐			DEC	22	0
28	PL_A_DWS	☐			DEC	22	0
29	PL_A_IRS	☐			DEC	22	0
30	PL_A_IWS	☐			DEC	22	0
31	PL_A_RTM	☐			DEC	22	0
32	PL_A_WTM	☐			DEC	22	0
33	DIRCT_RDS	☐			DEC	22	0
34	DIRCT_WTS	☐			DEC	22	0
35	DIRCT_RTM	☐			DEC	22	0
36	DIRCT_WTM	☐			DEC	22	0
37	DIRCT_RRQS	☐			DEC	22	0
38	DIRCT_WRQS	☐			DEC	22	0
39	AVG_DIRECT_WTM	☐			DEC	22	2
40	AVG_DIRECT_RTM	☐			DEC	22	2
41	AVG_PHYSICAL_WTM	☐			DEC	22	2
42	AVG_PHYSICAL_RTM	☐			DEC	22	2
43	POOL_PHYSICAL_WRITES	☐			DEC	22	0
44	POOL_PHYSICAL_READS	☐			DEC	22	0
45	AV_DCT_RTM	☐			DEC	22	2
46	AV_DCT_WTM	☐			DEC	22	2
47	AV_DCT_RDS	☐			DEC	22	2
48	AV_DCT_WTS	☐			DEC	22	2
49	PL_D_TE	☐			DEC	22	0
50	PL_D_FE	☐			DEC	22	0
51	PL_I_TE	☐			DEC	22	0
52	PL_I_FE	☐			DEC	22	0
53	PL_TD_LRS	☐			DEC	22	0
54	PL_TD_PRS	☐			DEC	22	0
55	PL_TI_LRS	☐			DEC	22	0
56	PL_TI_PRS	☐			DEC	22	0
57	PL_A_DRRQ	☐			DEC	22	0
58	PL_A_IRRQ	☐			DEC	22	0
59	PL_ASYNC_XDA_RDS	☐			DEC	22	0
60	PL_ASYNC_XDA_RRQ	☐			DEC	22	0
61	PL_ASYNC_XDA_WRT	☐			DEC	22	0
62	PL_TEMP_XDA_L_RD	☐			DEC	22	0
63	PL_TEMP_XDA_P_RD	☐			DEC	22	0
64	POOL_XDA_L_READS	☐			DEC	22	0
65	POOL_XDA_P_READS	☐			DEC	22	0
66	POOL_XDA_WRITES	☐			DEC	22	0
67	PL_NO_VICTIM_BUF	☐			DEC	22	0
68	COLOR	☐	LVC_CIFNM	CHAR30	CHAR	30	0	ALV control: Field name with simple row color coding
69	BPNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
70	UNREADPFPG	☐			DEC	22	0
71	TOTAL_IO	☐			DEC	22	0
72	TOTAL_READ_IO	☐			DEC	22	0
73	TOTAL_WRITE_IO	☐			DEC	22	0
74	PREFETCH_WAITS	☐			DEC	22	0
75	PREFETCH_WAIT_TIME	☐			DEC	22	0
76	SKP_PRF_DATA_P_READS	☐			DEC	22	0
77	SKP_PRF_INDEX_P_READS	☐			DEC	22	0
78	SKP_PRF_TEMP_DATA_P_READS	☐			DEC	22	0
79	SKP_PRF_TEMP_INDEX_P_READS	☐			DEC	22	0
80	SKP_PRF_TEMP_XDA_P_READS	☐			DEC	22	0
81	SKP_PRF_UOW_DATA_P_READS	☐			DEC	22	0
82	SKP_PRF_UOW_INDEX_P_READS	☐			DEC	22	0
83	SKP_PRF_UOW_TEMP_DATA_P_READS	☐			DEC	22	0
84	SKP_PRF_UOW_TEMP_INDEX_P_READS	☐			DEC	22	0
85	SKP_PRF_UOW_TEMP_XDA_P_READS	☐			DEC	22	0
86	SKP_PRF_UOW_XDA_P_READS	☐			DEC	22	0
87	SKP_PRF_XDA_P_READS	☐			DEC	22	0
88	PL_QUED_ASYNC_DATA_PAGES	☐			DEC	22	0
89	PL_QUED_ASYNC_DATA_REQS	☐			DEC	22	0
90	PL_QUED_ASYNC_INDEX_PAGES	☐			DEC	22	0
91	PL_QUED_ASYNC_INDEX_REQS	☐			DEC	22	0
92	PL_QUED_ASYNC_OTHER_REQS	☐			DEC	22	0
93	PL_QUED_ASYNC_TEMP_DATA_PAGES	☐			DEC	22	0
94	PL_QUED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
95	PL_QUED_ASYNC_TEMP_INDEX_PAGES	☐			DEC	22	0
96	PL_QUED_ASYNC_TEMP_INDEX_REQS	☐			DEC	22	0
97	PL_QUED_ASYNC_TEMP_XDA_PAGES	☐			DEC	22	0
98	PL_QUED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
99	PL_QUED_ASYNC_XDA_PAGES	☐			DEC	22	0
100	PL_QUED_ASYNC_XDA_REQS	☐			DEC	22	0
101	PL_FAILED_ASYNC_DATA_REQS	☐			DEC	22	0
102	PL_FAILED_ASYNC_INDEX_REQS	☐			DEC	22	0
103	PL_FAILED_ASYNC_OTHER_REQS	☐			DEC	22	0
104	PL_FAILED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
105	PL_FAILED_ASYNC_TEMP_INDEX_REQ	☐			DEC	22	0
106	PL_FAILED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
107	PL_FAILED_ASYNC_XDA_REQS	☐			DEC	22	0
108	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
109	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics - Direct Reads
110	PL_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
111	PL_D_GBP_INVALID_PAGES	☐			DEC	22	0
112	PL_D_GBP_L_READS	☐			DEC	22	0
113	PL_D_GBP_P_READS	☐			DEC	22	0
114	PL_D_LBP_PAGES_FOUND	☐			DEC	22	0
115	PL_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
116	PL_I_GBP_INVALID_PAGES	☐			DEC	22	0
117	PL_I_GBP_L_READS	☐			DEC	22	0
118	PL_I_GBP_P_READS	☐			DEC	22	0
119	PL_I_LBP_PAGES_FOUND	☐			DEC	22	0
120	PL_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
121	PL_X_GBP_INVALID_PAGES	☐			DEC	22	0
122	PL_X_GBP_L_READS	☐			DEC	22	0
123	PL_X_GBP_P_READS	☐			DEC	22	0
124	PL_X_LBP_PAGES_FOUND	☐			DEC	22	0
125	PL_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
126	PL_C_GBP_INVALID_PAGES	☐			DEC	22	0
127	PL_C_GBP_L_READS	☐			DEC	22	0
128	PL_C_GBP_P_READS	☐			DEC	22	0
129	PL_C_LBP_PAGES_FOUND	☐			DEC	22	0
130	LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
131	LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
132	GBP_HIT_RATIO	☐			DEC	22	2
133	D_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
134	D_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
135	D_GBP_HIT_RATIO	☐			DEC	22	2
136	I_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
137	I_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
138	I_GBP_HIT_RATIO	☐			DEC	22	2
139	X_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
140	X_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
141	X_GBP_HIT_RATIO	☐			DEC	22	2
142	C_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
143	C_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
144	C_GBP_HIT_RATIO	☐			DEC	22	2
145	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
146	PL_A_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
147	PL_A_D_GBP_INVALID_PAGES	☐			DEC	22	0
148	PL_A_D_GBP_L_READS	☐			DEC	22	0
149	PL_A_D_GBP_P_READS	☐			DEC	22	0
150	PL_A_D_LBP_PAGES_FOUND	☐			DEC	22	0
151	PL_A_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
152	PL_A_I_GBP_INVALID_PAGES	☐			DEC	22	0
153	PL_A_I_GBP_L_READS	☐			DEC	22	0
154	PL_A_I_GBP_P_READS	☐			DEC	22	0
155	PL_A_I_LBP_PAGES_FOUND	☐			DEC	22	0
156	PL_A_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
157	PL_A_X_GBP_INVALID_PAGES	☐			DEC	22	0
158	PL_A_X_GBP_L_READS	☐			DEC	22	0
159	PL_A_X_GBP_P_READS	☐			DEC	22	0
160	PL_A_X_LBP_PAGES_FOUND	☐			DEC	22	0
161	LBP_HIT_RATIO	☐			DEC	22	2
162	PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
163	D_LBP_HIT_RATIO	☐			DEC	22	2
164	D_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
165	I_LBP_HIT_RATIO	☐			DEC	22	2
166	I_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
167	X_LBP_HIT_RATIO	☐			DEC	22	2
168	X_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
169	PL_A_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
170	PL_A_C_GBP_INVALID_PAGES	☐			DEC	22	0
171	PL_A_C_GBP_L_READS	☐			DEC	22	0
172	PL_A_C_GBP_P_READS	☐			DEC	22	0
173	PL_A_C_LBP_PAGES_FOUND	☐			DEC	22	0
174	C_LBP_HIT_RATIO	☐			DEC	22	2
175	C_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
176	POOL_COL_L_READS	☐			DEC	22	0
177	POOL_COL_P_READS	☐			DEC	22	0
178	POOL_TEMP_COL_L_READS	☐			DEC	22	0
179	POOL_TEMP_COL_P_READS	☐			DEC	22	0
180	POOL_COL_WRITES	☐			DEC	22	0
181	PL_QUED_ASYNC_COL_PAGES	☐			DEC	22	0
182	PL_QUED_ASYNC_COL_REQS	☐			DEC	22	0
183	PL_QUED_ASYNC_TEMP_COL_PAGES	☐			DEC	22	0
184	PL_QUED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
185	PL_FAILED_ASYNC_COL_REQS	☐			DEC	22	0
186	PL_FAILED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
187	SKP_PRF_COL_P_READS	☐			DEC	22	0
188	SKP_PRF_TEMP_COL_P_READS	☐			DEC	22	0
189	SKP_PRF_UOW_COL_P_READS	☐			DEC	22	0
190	SKP_PRF_UOW_TEMP_COL_P_READS	☐			DEC	22	0
191	PL_ASYNC_COL_RDS	☐			DEC	22	0
192	PL_ASYNC_COL_RRQ	☐			DEC	22	0
193	PL_ASYNC_COL_WRT	☐			DEC	22	0
194	BP_C_HITRT	☐			DEC	8	2
195	BP_C_SPRS	☐			DEC	22	0
196	BP_C_SWS	☐			DEC	22	0
197	WA_DB6PMSTBS_HIST	☐	DB6PMSTBS		STRU	0	0
198	DBMSTRTTME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
199	COMPTIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
200	PARTITN	☐			INT4	10	0
201	TBS_NAME	☐	DB6TSPNAME		CHAR	30	0	DB6: Tablespace Name
202	BP_QAL	☐			DEC	8	2
203	BP_AV_RTM	☐			DEC	22	2
204	BP_AV_WTM	☐			DEC	22	2
205	BP_D_HITRT	☐			DEC	8	2
206	BP_I_HITRT	☐			DEC	8	2
207	PL_D_LRS	☐			DEC	22	0
208	PL_D_PRS	☐			DEC	22	0
209	PL_D_WS	☐			DEC	22	0
210	BP_D_SPRS	☐			DEC	22	0
211	BP_D_SWS	☐			DEC	22	0
212	PL_I_LRS	☐			DEC	22	0
213	PL_I_PRS	☐			DEC	22	0
214	PL_I_WS	☐			DEC	22	0
215	BP_I_SPRS	☐			DEC	22	0
216	BP_I_SWS	☐			DEC	22	0
217	PL_RD_TM	☐			DEC	22	0
218	PL_WT_TM	☐			DEC	22	0
219	AV_ASP_RTM	☐			DEC	22	2
220	AV_ASP_WTM	☐			DEC	22	2
221	PL_A_DRS	☐			DEC	22	0
222	PL_A_DWS	☐			DEC	22	0
223	PL_A_IRS	☐			DEC	22	0
224	PL_A_IWS	☐			DEC	22	0
225	PL_A_RTM	☐			DEC	22	0
226	PL_A_WTM	☐			DEC	22	0
227	DIRCT_RDS	☐			DEC	22	0
228	DIRCT_WTS	☐			DEC	22	0
229	DIRCT_RTM	☐			DEC	22	0
230	DIRCT_WTM	☐			DEC	22	0
231	DIRCT_RRQS	☐			DEC	22	0
232	DIRCT_WRQS	☐			DEC	22	0
233	AVG_DIRECT_WTM	☐			DEC	22	2
234	AVG_DIRECT_RTM	☐			DEC	22	2
235	AVG_PHYSICAL_WTM	☐			DEC	22	2
236	AVG_PHYSICAL_RTM	☐			DEC	22	2
237	POOL_PHYSICAL_WRITES	☐			DEC	22	0
238	POOL_PHYSICAL_READS	☐			DEC	22	0
239	AV_DCT_RTM	☐			DEC	22	2
240	AV_DCT_WTM	☐			DEC	22	2
241	AV_DCT_RDS	☐			DEC	22	2
242	AV_DCT_WTS	☐			DEC	22	2
243	PL_D_TE	☐			DEC	22	0
244	PL_D_FE	☐			DEC	22	0
245	PL_I_TE	☐			DEC	22	0
246	PL_I_FE	☐			DEC	22	0
247	PL_TD_LRS	☐			DEC	22	0
248	PL_TD_PRS	☐			DEC	22	0
249	PL_TI_LRS	☐			DEC	22	0
250	PL_TI_PRS	☐			DEC	22	0
251	PL_A_DRRQ	☐			DEC	22	0
252	PL_A_IRRQ	☐			DEC	22	0
253	PL_ASYNC_XDA_RDS	☐			DEC	22	0
254	PL_ASYNC_XDA_RRQ	☐			DEC	22	0
255	PL_ASYNC_XDA_WRT	☐			DEC	22	0
256	PL_TEMP_XDA_L_RD	☐			DEC	22	0
257	PL_TEMP_XDA_P_RD	☐			DEC	22	0
258	POOL_XDA_L_READS	☐			DEC	22	0
259	POOL_XDA_P_READS	☐			DEC	22	0
260	POOL_XDA_WRITES	☐			DEC	22	0
261	PL_NO_VICTIM_BUF	☐			DEC	22	0
262	COLOR	☐	LVC_CIFNM	CHAR30	CHAR	30	0	ALV control: Field name with simple row color coding
263	BPNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
264	UNREADPFPG	☐			DEC	22	0
265	TOTAL_IO	☐			DEC	22	0
266	TOTAL_READ_IO	☐			DEC	22	0
267	TOTAL_WRITE_IO	☐			DEC	22	0
268	PREFETCH_WAITS	☐			DEC	22	0
269	PREFETCH_WAIT_TIME	☐			DEC	22	0
270	SKP_PRF_DATA_P_READS	☐			DEC	22	0
271	SKP_PRF_INDEX_P_READS	☐			DEC	22	0
272	SKP_PRF_TEMP_DATA_P_READS	☐			DEC	22	0
273	SKP_PRF_TEMP_INDEX_P_READS	☐			DEC	22	0
274	SKP_PRF_TEMP_XDA_P_READS	☐			DEC	22	0
275	SKP_PRF_UOW_DATA_P_READS	☐			DEC	22	0
276	SKP_PRF_UOW_INDEX_P_READS	☐			DEC	22	0
277	SKP_PRF_UOW_TEMP_DATA_P_READS	☐			DEC	22	0
278	SKP_PRF_UOW_TEMP_INDEX_P_READS	☐			DEC	22	0
279	SKP_PRF_UOW_TEMP_XDA_P_READS	☐			DEC	22	0
280	SKP_PRF_UOW_XDA_P_READS	☐			DEC	22	0
281	SKP_PRF_XDA_P_READS	☐			DEC	22	0
282	PL_QUED_ASYNC_DATA_PAGES	☐			DEC	22	0
283	PL_QUED_ASYNC_DATA_REQS	☐			DEC	22	0
284	PL_QUED_ASYNC_INDEX_PAGES	☐			DEC	22	0
285	PL_QUED_ASYNC_INDEX_REQS	☐			DEC	22	0
286	PL_QUED_ASYNC_OTHER_REQS	☐			DEC	22	0
287	PL_QUED_ASYNC_TEMP_DATA_PAGES	☐			DEC	22	0
288	PL_QUED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
289	PL_QUED_ASYNC_TEMP_INDEX_PAGES	☐			DEC	22	0
290	PL_QUED_ASYNC_TEMP_INDEX_REQS	☐			DEC	22	0
291	PL_QUED_ASYNC_TEMP_XDA_PAGES	☐			DEC	22	0
292	PL_QUED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
293	PL_QUED_ASYNC_XDA_PAGES	☐			DEC	22	0
294	PL_QUED_ASYNC_XDA_REQS	☐			DEC	22	0
295	PL_FAILED_ASYNC_DATA_REQS	☐			DEC	22	0
296	PL_FAILED_ASYNC_INDEX_REQS	☐			DEC	22	0
297	PL_FAILED_ASYNC_OTHER_REQS	☐			DEC	22	0
298	PL_FAILED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
299	PL_FAILED_ASYNC_TEMP_INDEX_REQ	☐			DEC	22	0
300	PL_FAILED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
301	PL_FAILED_ASYNC_XDA_REQS	☐			DEC	22	0
302	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
303	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics - Direct Reads
304	PL_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
305	PL_D_GBP_INVALID_PAGES	☐			DEC	22	0
306	PL_D_GBP_L_READS	☐			DEC	22	0
307	PL_D_GBP_P_READS	☐			DEC	22	0
308	PL_D_LBP_PAGES_FOUND	☐			DEC	22	0
309	PL_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
310	PL_I_GBP_INVALID_PAGES	☐			DEC	22	0
311	PL_I_GBP_L_READS	☐			DEC	22	0
312	PL_I_GBP_P_READS	☐			DEC	22	0
313	PL_I_LBP_PAGES_FOUND	☐			DEC	22	0
314	PL_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
315	PL_X_GBP_INVALID_PAGES	☐			DEC	22	0
316	PL_X_GBP_L_READS	☐			DEC	22	0
317	PL_X_GBP_P_READS	☐			DEC	22	0
318	PL_X_LBP_PAGES_FOUND	☐			DEC	22	0
319	PL_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
320	PL_C_GBP_INVALID_PAGES	☐			DEC	22	0
321	PL_C_GBP_L_READS	☐			DEC	22	0
322	PL_C_GBP_P_READS	☐			DEC	22	0
323	PL_C_LBP_PAGES_FOUND	☐			DEC	22	0
324	LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
325	LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
326	GBP_HIT_RATIO	☐			DEC	22	2
327	D_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
328	D_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
329	D_GBP_HIT_RATIO	☐			DEC	22	2
330	I_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
331	I_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
332	I_GBP_HIT_RATIO	☐			DEC	22	2
333	X_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
334	X_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
335	X_GBP_HIT_RATIO	☐			DEC	22	2
336	C_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
337	C_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
338	C_GBP_HIT_RATIO	☐			DEC	22	2
339	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
340	PL_A_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
341	PL_A_D_GBP_INVALID_PAGES	☐			DEC	22	0
342	PL_A_D_GBP_L_READS	☐			DEC	22	0
343	PL_A_D_GBP_P_READS	☐			DEC	22	0
344	PL_A_D_LBP_PAGES_FOUND	☐			DEC	22	0
345	PL_A_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
346	PL_A_I_GBP_INVALID_PAGES	☐			DEC	22	0
347	PL_A_I_GBP_L_READS	☐			DEC	22	0
348	PL_A_I_GBP_P_READS	☐			DEC	22	0
349	PL_A_I_LBP_PAGES_FOUND	☐			DEC	22	0
350	PL_A_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
351	PL_A_X_GBP_INVALID_PAGES	☐			DEC	22	0
352	PL_A_X_GBP_L_READS	☐			DEC	22	0
353	PL_A_X_GBP_P_READS	☐			DEC	22	0
354	PL_A_X_LBP_PAGES_FOUND	☐			DEC	22	0
355	LBP_HIT_RATIO	☐			DEC	22	2
356	PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
357	D_LBP_HIT_RATIO	☐			DEC	22	2
358	D_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
359	I_LBP_HIT_RATIO	☐			DEC	22	2
360	I_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
361	X_LBP_HIT_RATIO	☐			DEC	22	2
362	X_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
363	PL_A_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
364	PL_A_C_GBP_INVALID_PAGES	☐			DEC	22	0
365	PL_A_C_GBP_L_READS	☐			DEC	22	0
366	PL_A_C_GBP_P_READS	☐			DEC	22	0
367	PL_A_C_LBP_PAGES_FOUND	☐			DEC	22	0
368	C_LBP_HIT_RATIO	☐			DEC	22	2
369	C_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
370	POOL_COL_L_READS	☐			DEC	22	0
371	POOL_COL_P_READS	☐			DEC	22	0
372	POOL_TEMP_COL_L_READS	☐			DEC	22	0
373	POOL_TEMP_COL_P_READS	☐			DEC	22	0
374	POOL_COL_WRITES	☐			DEC	22	0
375	PL_QUED_ASYNC_COL_PAGES	☐			DEC	22	0
376	PL_QUED_ASYNC_COL_REQS	☐			DEC	22	0
377	PL_QUED_ASYNC_TEMP_COL_PAGES	☐			DEC	22	0
378	PL_QUED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
379	PL_FAILED_ASYNC_COL_REQS	☐			DEC	22	0
380	PL_FAILED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
381	SKP_PRF_COL_P_READS	☐			DEC	22	0
382	SKP_PRF_TEMP_COL_P_READS	☐			DEC	22	0
383	SKP_PRF_UOW_COL_P_READS	☐			DEC	22	0
384	SKP_PRF_UOW_TEMP_COL_P_READS	☐			DEC	22	0
385	PL_ASYNC_COL_RDS	☐			DEC	22	0
386	PL_ASYNC_COL_RRQ	☐			DEC	22	0
387	PL_ASYNC_COL_WRT	☐			DEC	22	0
388	BP_C_HITRT	☐			DEC	8	2
389	BP_C_SPRS	☐			DEC	22	0
390	BP_C_SWS	☐			DEC	22	0
391	WA_DB6PMSTBS	☐	DB6PMSTBS		STRU	0	0
392	DBMSTRTTME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
393	COMPTIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
394	PARTITN	☐			INT4	10	0
395	TBS_NAME	☐	DB6TSPNAME		CHAR	30	0	DB6: Tablespace Name
396	BP_QAL	☐			DEC	8	2
397	BP_AV_RTM	☐			DEC	22	2
398	BP_AV_WTM	☐			DEC	22	2
399	BP_D_HITRT	☐			DEC	8	2
400	BP_I_HITRT	☐			DEC	8	2
401	PL_D_LRS	☐			DEC	22	0
402	PL_D_PRS	☐			DEC	22	0
403	PL_D_WS	☐			DEC	22	0
404	BP_D_SPRS	☐			DEC	22	0
405	BP_D_SWS	☐			DEC	22	0
406	PL_I_LRS	☐			DEC	22	0
407	PL_I_PRS	☐			DEC	22	0
408	PL_I_WS	☐			DEC	22	0
409	BP_I_SPRS	☐			DEC	22	0
410	BP_I_SWS	☐			DEC	22	0
411	PL_RD_TM	☐			DEC	22	0
412	PL_WT_TM	☐			DEC	22	0
413	AV_ASP_RTM	☐			DEC	22	2
414	AV_ASP_WTM	☐			DEC	22	2
415	PL_A_DRS	☐			DEC	22	0
416	PL_A_DWS	☐			DEC	22	0
417	PL_A_IRS	☐			DEC	22	0
418	PL_A_IWS	☐			DEC	22	0
419	PL_A_RTM	☐			DEC	22	0
420	PL_A_WTM	☐			DEC	22	0
421	DIRCT_RDS	☐			DEC	22	0
422	DIRCT_WTS	☐			DEC	22	0
423	DIRCT_RTM	☐			DEC	22	0
424	DIRCT_WTM	☐			DEC	22	0
425	DIRCT_RRQS	☐			DEC	22	0
426	DIRCT_WRQS	☐			DEC	22	0
427	AVG_DIRECT_WTM	☐			DEC	22	2
428	AVG_DIRECT_RTM	☐			DEC	22	2
429	AVG_PHYSICAL_WTM	☐			DEC	22	2
430	AVG_PHYSICAL_RTM	☐			DEC	22	2
431	POOL_PHYSICAL_WRITES	☐			DEC	22	0
432	POOL_PHYSICAL_READS	☐			DEC	22	0
433	AV_DCT_RTM	☐			DEC	22	2
434	AV_DCT_WTM	☐			DEC	22	2
435	AV_DCT_RDS	☐			DEC	22	2
436	AV_DCT_WTS	☐			DEC	22	2
437	PL_D_TE	☐			DEC	22	0
438	PL_D_FE	☐			DEC	22	0
439	PL_I_TE	☐			DEC	22	0
440	PL_I_FE	☐			DEC	22	0
441	PL_TD_LRS	☐			DEC	22	0
442	PL_TD_PRS	☐			DEC	22	0
443	PL_TI_LRS	☐			DEC	22	0
444	PL_TI_PRS	☐			DEC	22	0
445	PL_A_DRRQ	☐			DEC	22	0
446	PL_A_IRRQ	☐			DEC	22	0
447	PL_ASYNC_XDA_RDS	☐			DEC	22	0
448	PL_ASYNC_XDA_RRQ	☐			DEC	22	0
449	PL_ASYNC_XDA_WRT	☐			DEC	22	0
450	PL_TEMP_XDA_L_RD	☐			DEC	22	0
451	PL_TEMP_XDA_P_RD	☐			DEC	22	0
452	POOL_XDA_L_READS	☐			DEC	22	0
453	POOL_XDA_P_READS	☐			DEC	22	0
454	POOL_XDA_WRITES	☐			DEC	22	0
455	PL_NO_VICTIM_BUF	☐			DEC	22	0
456	COLOR	☐	LVC_CIFNM	CHAR30	CHAR	30	0	ALV control: Field name with simple row color coding
457	BPNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
458	UNREADPFPG	☐			DEC	22	0
459	TOTAL_IO	☐			DEC	22	0
460	TOTAL_READ_IO	☐			DEC	22	0
461	TOTAL_WRITE_IO	☐			DEC	22	0
462	PREFETCH_WAITS	☐			DEC	22	0
463	PREFETCH_WAIT_TIME	☐			DEC	22	0
464	SKP_PRF_DATA_P_READS	☐			DEC	22	0
465	SKP_PRF_INDEX_P_READS	☐			DEC	22	0
466	SKP_PRF_TEMP_DATA_P_READS	☐			DEC	22	0
467	SKP_PRF_TEMP_INDEX_P_READS	☐			DEC	22	0
468	SKP_PRF_TEMP_XDA_P_READS	☐			DEC	22	0
469	SKP_PRF_UOW_DATA_P_READS	☐			DEC	22	0
470	SKP_PRF_UOW_INDEX_P_READS	☐			DEC	22	0
471	SKP_PRF_UOW_TEMP_DATA_P_READS	☐			DEC	22	0
472	SKP_PRF_UOW_TEMP_INDEX_P_READS	☐			DEC	22	0
473	SKP_PRF_UOW_TEMP_XDA_P_READS	☐			DEC	22	0
474	SKP_PRF_UOW_XDA_P_READS	☐			DEC	22	0
475	SKP_PRF_XDA_P_READS	☐			DEC	22	0
476	PL_QUED_ASYNC_DATA_PAGES	☐			DEC	22	0
477	PL_QUED_ASYNC_DATA_REQS	☐			DEC	22	0
478	PL_QUED_ASYNC_INDEX_PAGES	☐			DEC	22	0
479	PL_QUED_ASYNC_INDEX_REQS	☐			DEC	22	0
480	PL_QUED_ASYNC_OTHER_REQS	☐			DEC	22	0
481	PL_QUED_ASYNC_TEMP_DATA_PAGES	☐			DEC	22	0
482	PL_QUED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
483	PL_QUED_ASYNC_TEMP_INDEX_PAGES	☐			DEC	22	0
484	PL_QUED_ASYNC_TEMP_INDEX_REQS	☐			DEC	22	0
485	PL_QUED_ASYNC_TEMP_XDA_PAGES	☐			DEC	22	0
486	PL_QUED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
487	PL_QUED_ASYNC_XDA_PAGES	☐			DEC	22	0
488	PL_QUED_ASYNC_XDA_REQS	☐			DEC	22	0
489	PL_FAILED_ASYNC_DATA_REQS	☐			DEC	22	0
490	PL_FAILED_ASYNC_INDEX_REQS	☐			DEC	22	0
491	PL_FAILED_ASYNC_OTHER_REQS	☐			DEC	22	0
492	PL_FAILED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
493	PL_FAILED_ASYNC_TEMP_INDEX_REQ	☐			DEC	22	0
494	PL_FAILED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
495	PL_FAILED_ASYNC_XDA_REQS	☐			DEC	22	0
496	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
497	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics - Direct Reads
498	PL_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
499	PL_D_GBP_INVALID_PAGES	☐			DEC	22	0
500	PL_D_GBP_L_READS	☐			DEC	22	0
501	PL_D_GBP_P_READS	☐			DEC	22	0
502	PL_D_LBP_PAGES_FOUND	☐			DEC	22	0
503	PL_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
504	PL_I_GBP_INVALID_PAGES	☐			DEC	22	0
505	PL_I_GBP_L_READS	☐			DEC	22	0
506	PL_I_GBP_P_READS	☐			DEC	22	0
507	PL_I_LBP_PAGES_FOUND	☐			DEC	22	0
508	PL_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
509	PL_X_GBP_INVALID_PAGES	☐			DEC	22	0
510	PL_X_GBP_L_READS	☐			DEC	22	0
511	PL_X_GBP_P_READS	☐			DEC	22	0
512	PL_X_LBP_PAGES_FOUND	☐			DEC	22	0
513	PL_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
514	PL_C_GBP_INVALID_PAGES	☐			DEC	22	0
515	PL_C_GBP_L_READS	☐			DEC	22	0
516	PL_C_GBP_P_READS	☐			DEC	22	0
517	PL_C_LBP_PAGES_FOUND	☐			DEC	22	0
518	LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
519	LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
520	GBP_HIT_RATIO	☐			DEC	22	2
521	D_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
522	D_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
523	D_GBP_HIT_RATIO	☐			DEC	22	2
524	I_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
525	I_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
526	I_GBP_HIT_RATIO	☐			DEC	22	2
527	X_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
528	X_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
529	X_GBP_HIT_RATIO	☐			DEC	22	2
530	C_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
531	C_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
532	C_GBP_HIT_RATIO	☐			DEC	22	2
533	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
534	PL_A_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
535	PL_A_D_GBP_INVALID_PAGES	☐			DEC	22	0
536	PL_A_D_GBP_L_READS	☐			DEC	22	0
537	PL_A_D_GBP_P_READS	☐			DEC	22	0
538	PL_A_D_LBP_PAGES_FOUND	☐			DEC	22	0
539	PL_A_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
540	PL_A_I_GBP_INVALID_PAGES	☐			DEC	22	0
541	PL_A_I_GBP_L_READS	☐			DEC	22	0
542	PL_A_I_GBP_P_READS	☐			DEC	22	0
543	PL_A_I_LBP_PAGES_FOUND	☐			DEC	22	0
544	PL_A_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
545	PL_A_X_GBP_INVALID_PAGES	☐			DEC	22	0
546	PL_A_X_GBP_L_READS	☐			DEC	22	0
547	PL_A_X_GBP_P_READS	☐			DEC	22	0
548	PL_A_X_LBP_PAGES_FOUND	☐			DEC	22	0
549	LBP_HIT_RATIO	☐			DEC	22	2
550	PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
551	D_LBP_HIT_RATIO	☐			DEC	22	2
552	D_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
553	I_LBP_HIT_RATIO	☐			DEC	22	2
554	I_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
555	X_LBP_HIT_RATIO	☐			DEC	22	2
556	X_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
557	PL_A_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
558	PL_A_C_GBP_INVALID_PAGES	☐			DEC	22	0
559	PL_A_C_GBP_L_READS	☐			DEC	22	0
560	PL_A_C_GBP_P_READS	☐			DEC	22	0
561	PL_A_C_LBP_PAGES_FOUND	☐			DEC	22	0
562	C_LBP_HIT_RATIO	☐			DEC	22	2
563	C_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
564	POOL_COL_L_READS	☐			DEC	22	0
565	POOL_COL_P_READS	☐			DEC	22	0
566	POOL_TEMP_COL_L_READS	☐			DEC	22	0
567	POOL_TEMP_COL_P_READS	☐			DEC	22	0
568	POOL_COL_WRITES	☐			DEC	22	0
569	PL_QUED_ASYNC_COL_PAGES	☐			DEC	22	0
570	PL_QUED_ASYNC_COL_REQS	☐			DEC	22	0
571	PL_QUED_ASYNC_TEMP_COL_PAGES	☐			DEC	22	0
572	PL_QUED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
573	PL_FAILED_ASYNC_COL_REQS	☐			DEC	22	0
574	PL_FAILED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
575	SKP_PRF_COL_P_READS	☐			DEC	22	0
576	SKP_PRF_TEMP_COL_P_READS	☐			DEC	22	0
577	SKP_PRF_UOW_COL_P_READS	☐			DEC	22	0
578	SKP_PRF_UOW_TEMP_COL_P_READS	☐			DEC	22	0
579	PL_ASYNC_COL_RDS	☐			DEC	22	0
580	PL_ASYNC_COL_RRQ	☐			DEC	22	0
581	PL_ASYNC_COL_WRT	☐			DEC	22	0
582	BP_C_HITRT	☐			DEC	8	2
583	BP_C_SPRS	☐			DEC	22	0
584	BP_C_SWS	☐			DEC	22	0
585	IT_DB6PMSTBS	☐	DB6PMSTBS_TAB		TTYP	0	0

History

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