SAP ABAP Table DB6_VIEW_DBSNAP (DB6: View Data of Database Snapshot)

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_DBSNAP	Table Relationship Diagram
Short Description	DB6: View Data of Database Snapshot

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	DESCRIPTION	☐			STRG	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

History

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