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

History

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