SAP ABAP Table DB6_XCHG_BUFFERPOOL (DB6: Exchange Data for Buffer Pool)

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_XCHG_BUFFERPOOL	Table Relationship Diagram
Short Description	DB6: Exchange Data for Buffer Pool

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

History

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