SAP ABAP Table DB6_VIEW_BUFFERPOOL_LIST (DB6: View Data of Bufferpool 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_BUFFERPOOL_LIST	Table Relationship Diagram
Short Description	DB6: View Data of Bufferpool 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	IT_DB6PMSBP	☐	DB6PMSBP_TAB		TTYP	0	0
2	CHARTDATA	☐	DB6_CHARTENGINE_DATA		STRU	0	0
3	XML_GRAPHDATA	☐			RSTR	0	0
4	XML_GRAPHCUST	☐			RSTR	0	0
5	DATA_TAB	☐	DBA_CHARTDATA_TAB		TTYP	0	0
6	SELECTION	☐	DB6PM_HISTCHARTSEL		STRU	0	0
7	TIMESTAMP_FROM	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
8	TIMESTAMP_TO	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
9	WA_DB6PMSBP	☐	DB6PMSBP		STRU	0	0
10	DBMSTRTTME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
11	COMPTIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
12	PARTITN	☐			INT4	10	0
13	BP_NAME	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
14	BP_NUM	☐			DEC	22	0
15	BUFFPAGE	☐			DEC	22	0
16	BP_SZ	☐			DEC	22	0
17	BP_QAL	☐			DEC	8	2
18	BP_AV_RTM	☐			DEC	22	2
19	BP_AV_WTM	☐			DEC	22	2
20	BP_D_HITRT	☐			DEC	8	2
21	BP_I_HITRT	☐			DEC	8	2
22	PL_D_LRS	☐			DEC	22	0
23	PL_D_PRS	☐			DEC	22	0
24	PL_D_WS	☐			DEC	22	0
25	BP_D_SPRS	☐			DEC	22	0
26	BP_D_SWS	☐			DEC	22	0
27	PL_I_LRS	☐			DEC	22	0
28	PL_I_PRS	☐			DEC	22	0
29	PL_I_WS	☐			DEC	22	0
30	BP_I_SPRS	☐			DEC	22	0
31	BP_I_SWS	☐			DEC	22	0
32	PL_RD_TM	☐			DEC	22	0
33	PL_WT_TM	☐			DEC	22	0
34	AV_ASP_RTM	☐			DEC	22	2
35	AV_ASP_WTM	☐			DEC	22	2
36	PL_A_DRS	☐			DEC	22	0
37	PL_A_DWS	☐			DEC	22	0
38	PL_A_IRS	☐			DEC	22	0
39	PL_A_IWS	☐			DEC	22	0
40	PL_A_RTM	☐			DEC	22	0
41	PL_A_WTM	☐			DEC	22	0
42	DIRCT_RDS	☐			DEC	22	0
43	DIRCT_WTS	☐			DEC	22	0
44	DIRCT_RTM	☐			DEC	22	0
45	DIRCT_WTM	☐			DEC	22	0
46	DIRCT_RRQS	☐			DEC	22	0
47	DIRCT_WRQS	☐			DEC	22	0
48	AV_DCT_RTM	☐			DEC	22	2
49	AV_DCT_WTM	☐			DEC	22	2
50	AV_DCT_RDS	☐			DEC	22	2
51	AV_DCT_WTS	☐			DEC	22	2
52	PL_D_TE	☐			DEC	22	0
53	PL_D_FE	☐			DEC	22	0
54	PL_I_TE	☐			DEC	22	0
55	PL_I_FE	☐			DEC	22	0
56	PL_TD_LRS	☐			DEC	22	0
57	PL_TD_PRS	☐			DEC	22	0
58	PL_TI_LRS	☐			DEC	22	0
59	PL_TI_PRS	☐			DEC	22	0
60	PL_A_DRRQ	☐			DEC	22	0
61	PL_A_IRRQ	☐			DEC	22	0
62	CURBUFFSZ	☐			DEC	22	0
63	NEWBUFFSZ	☐			DEC	22	0
64	AUTOSIZE_LABEL	☐			CHAR	3	0
65	AUTOSIZE	☐			CHAR	1	0
66	PGS_FROM_BLOCKIO	☐			DEC	22	0
67	PGS_FROM_VECTRIO	☐			DEC	22	0
68	PHYS_PAGE_MAPS	☐			DEC	22	0
69	PL_ASYNC_XDA_RD	☐			DEC	22	0
70	PL_ASYNC_XDA_RRQ	☐			DEC	22	0
71	PL_ASYNC_XDA_WRT	☐			DEC	22	0
72	PL_NO_VICTIM_BUF	☐			DEC	22	0
73	POOL_XDA_L_READS	☐			DEC	22	0
74	POOL_XDA_P_READS	☐			DEC	22	0
75	POOL_XDA_WRITES	☐			DEC	22	0
76	PL_TEMP_XDA_L_RD	☐			DEC	22	0
77	PL_TEMP_XDA_P_RD	☐			DEC	22	0
78	VECTORED_IOS	☐			DEC	22	0
79	BP_PAGES_LEFT	☐			DEC	22	0
80	BP_TBSP_USE_CNT	☐			DEC	22	0
81	PCT_SIZE	☐			DEC	8	0
82	PCT_LREADS	☐			DEC	8	0
83	PCT_PREADS	☐			DEC	8	0
84	PCT_ASYNC_READS	☐			DEC	8	0
85	UNREADPFPG	☐			DEC	22	0
86	PREFETCH_WAITS	☐			DEC	22	0
87	PREFETCH_WAIT_TIME	☐			DEC	22	0
88	SKP_PRF_DATA_P_READS	☐			DEC	22	0
89	SKP_PRF_INDEX_P_READS	☐			DEC	22	0
90	SKP_PRF_TEMP_DATA_P_READS	☐			DEC	22	0
91	SKP_PRF_TEMP_INDEX_P_READS	☐			DEC	22	0
92	SKP_PRF_TEMP_XDA_P_READS	☐			DEC	22	0
93	SKP_PRF_UOW_DATA_P_READS	☐			DEC	22	0
94	SKP_PRF_UOW_INDEX_P_READS	☐			DEC	22	0
95	SKP_PRF_UOW_TEMP_DATA_P_READS	☐			DEC	22	0
96	SKP_PRF_UOW_TEMP_INDEX_P_READS	☐			DEC	22	0
97	SKP_PRF_UOW_TEMP_XDA_P_READS	☐			DEC	22	0
98	SKP_PRF_UOW_XDA_P_READS	☐			DEC	22	0
99	SKP_PRF_XDA_P_READS	☐			DEC	22	0
100	PL_QUED_ASYNC_DATA_PAGES	☐			DEC	22	0
101	PL_QUED_ASYNC_DATA_REQS	☐			DEC	22	0
102	PL_QUED_ASYNC_INDEX_PAGES	☐			DEC	22	0
103	PL_QUED_ASYNC_INDEX_REQS	☐			DEC	22	0
104	PL_QUED_ASYNC_OTHER_REQS	☐			DEC	22	0
105	PL_QUED_ASYNC_TEMP_DATA_PAGES	☐			DEC	22	0
106	PL_QUED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
107	PL_QUED_ASYNC_TEMP_INDEX_PAGES	☐			DEC	22	0
108	PL_QUED_ASYNC_TEMP_INDEX_REQS	☐			DEC	22	0
109	PL_QUED_ASYNC_TEMP_XDA_PAGES	☐			DEC	22	0
110	PL_QUED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
111	PL_QUED_ASYNC_XDA_PAGES	☐			DEC	22	0
112	PL_QUED_ASYNC_XDA_REQS	☐			DEC	22	0
113	PL_FAILED_ASYNC_DATA_REQS	☐			DEC	22	0
114	PL_FAILED_ASYNC_INDEX_REQS	☐			DEC	22	0
115	PL_FAILED_ASYNC_OTHER_REQS	☐			DEC	22	0
116	PL_FAILED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
117	PL_FAILED_ASYNC_TEMP_INDEX_REQ	☐			DEC	22	0
118	PL_FAILED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
119	PL_FAILED_ASYNC_XDA_REQS	☐			DEC	22	0
120	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
121	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics - Direct Reads
122	PL_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
123	PL_D_GBP_INVALID_PAGES	☐			DEC	22	0
124	PL_D_GBP_L_READS	☐			DEC	22	0
125	PL_D_GBP_P_READS	☐			DEC	22	0
126	PL_D_LBP_PAGES_FOUND	☐			DEC	22	0
127	PL_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
128	PL_I_GBP_INVALID_PAGES	☐			DEC	22	0
129	PL_I_GBP_L_READS	☐			DEC	22	0
130	PL_I_GBP_P_READS	☐			DEC	22	0
131	PL_I_LBP_PAGES_FOUND	☐			DEC	22	0
132	PL_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
133	PL_X_GBP_INVALID_PAGES	☐			DEC	22	0
134	PL_X_GBP_L_READS	☐			DEC	22	0
135	PL_X_GBP_P_READS	☐			DEC	22	0
136	PL_X_LBP_PAGES_FOUND	☐			DEC	22	0
137	PL_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
138	PL_C_GBP_INVALID_PAGES	☐			DEC	22	0
139	PL_C_GBP_L_READS	☐			DEC	22	0
140	PL_C_GBP_P_READS	☐			DEC	22	0
141	PL_C_LBP_PAGES_FOUND	☐			DEC	22	0
142	LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
143	LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
144	GBP_HIT_RATIO	☐			DEC	22	2
145	D_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
146	D_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
147	D_GBP_HIT_RATIO	☐			DEC	22	2
148	I_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
149	I_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
150	I_GBP_HIT_RATIO	☐			DEC	22	2
151	X_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
152	X_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
153	X_GBP_HIT_RATIO	☐			DEC	22	2
154	C_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
155	C_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
156	C_GBP_HIT_RATIO	☐			DEC	22	2
157	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
158	PL_A_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
159	PL_A_D_GBP_INVALID_PAGES	☐			DEC	22	0
160	PL_A_D_GBP_L_READS	☐			DEC	22	0
161	PL_A_D_GBP_P_READS	☐			DEC	22	0
162	PL_A_D_LBP_PAGES_FOUND	☐			DEC	22	0
163	PL_A_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
164	PL_A_I_GBP_INVALID_PAGES	☐			DEC	22	0
165	PL_A_I_GBP_L_READS	☐			DEC	22	0
166	PL_A_I_GBP_P_READS	☐			DEC	22	0
167	PL_A_I_LBP_PAGES_FOUND	☐			DEC	22	0
168	PL_A_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
169	PL_A_X_GBP_INVALID_PAGES	☐			DEC	22	0
170	PL_A_X_GBP_L_READS	☐			DEC	22	0
171	PL_A_X_GBP_P_READS	☐			DEC	22	0
172	PL_A_X_LBP_PAGES_FOUND	☐			DEC	22	0
173	LBP_HIT_RATIO	☐			DEC	22	2
174	PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
175	D_LBP_HIT_RATIO	☐			DEC	22	2
176	D_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
177	I_LBP_HIT_RATIO	☐			DEC	22	2
178	I_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
179	X_LBP_HIT_RATIO	☐			DEC	22	2
180	X_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
181	PL_A_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
182	PL_A_C_GBP_INVALID_PAGES	☐			DEC	22	0
183	PL_A_C_GBP_L_READS	☐			DEC	22	0
184	PL_A_C_GBP_P_READS	☐			DEC	22	0
185	PL_A_C_LBP_PAGES_FOUND	☐			DEC	22	0
186	C_LBP_HIT_RATIO	☐			DEC	22	2
187	C_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
188	SIZE_MB	☐			DEC	22	2
189	POOL_COL_L_READS	☐			DEC	22	0
190	POOL_COL_P_READS	☐			DEC	22	0
191	POOL_TEMP_COL_L_READS	☐			DEC	22	0
192	POOL_TEMP_COL_P_READS	☐			DEC	22	0
193	POOL_COL_WRITES	☐			DEC	22	0
194	PL_QUED_ASYNC_COL_PAGES	☐			DEC	22	0
195	PL_QUED_ASYNC_COL_REQS	☐			DEC	22	0
196	PL_QUED_ASYNC_TEMP_COL_PAGES	☐			DEC	22	0
197	PL_QUED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
198	PL_FAILED_ASYNC_COL_REQS	☐			DEC	22	0
199	PL_FAILED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
200	SKP_PRF_COL_P_READS	☐			DEC	22	0
201	SKP_PRF_TEMP_COL_P_READS	☐			DEC	22	0
202	SKP_PRF_UOW_COL_P_READS	☐			DEC	22	0
203	SKP_PRF_UOW_TEMP_COL_P_READS	☐			DEC	22	0
204	BP_C_HITRT	☐			DEC	8	0
205	BP_C_SPRS	☐			DEC	22	0
206	BP_C_SWS	☐			DEC	22	0
207	PL_ASYNC_COL_RDS	☐			DEC	22	0
208	PL_ASYNC_COL_RRQ	☐			DEC	22	0
209	PL_ASYNC_COL_WRT	☐			DEC	22	0
210	DETAIL_VISIBLE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
211	DRILLDOWN	☐	DBA_LISTBOX_VALUE	DBA_LISTBOX_VALUE	CHAR	40	0	DBA Cockpit: Listbox Value
212	DRILLDOWN_LIST	☐	DBA_LISTBOX_LIST		TTYP	0	0
213	DRILLDOWN_SELECTION	☐	DBA_LISTBOX_VALUE	DBA_LISTBOX_VALUE	CHAR	40	0	DBA Cockpit: Listbox Value

History

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