SAP ABAP Table DB6_XCHG_DATABASE_SELECTION (DB6: Exchange Data for Detailed DB/Tsp History)

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_DATABASE_SELECTION	Table Relationship Diagram
Short Description	DB6: Exchange Data for Detailed DB/Tsp History

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	TIME_SELECTION	☐	DBA_WD_TIMESLIDER		STRU	0	0
2	FROM_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
3	FROM_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
4	TO_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
5	TO_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
6	TIME_FRAME	☐	DBA_LISTBOX_VALUE	DBA_LISTBOX_VALUE	CHAR	40	0	DBA Cockpit: Listbox Value
7	RANGETYPE	☐			INT4	10	0
8	TIME_ZONE	☐			STRG	0	0
9	GRANULARITY	☐			INT4	10	0
10	TIME_RANGE_READONLY	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
11	TIME_RANGE_HIDDEN	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
12	TIME_RANGE_DESCR	☐			STRG	0	0
13	CONFIRM_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
14	GRANULARITY_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
15	AGGREGATE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
16	DRILL_SELECTION	☐			STRG	0	0
17	MEMBER_SELECTION	☐	DB6_WD_MEMBER_SELECTION		STRU	0	0
18	SELECTED_MEMBER	☐			INT4	10	0
19	MULTI_SELECTION	☐	DB6_WD_MEMBER_LIST		TTYP	0	0
20	SELECTED_GROUP	☐			STRG	0	0
21	PARTITN	☐			INT4	10	0
22	WA_DB6PM1ST4	☐	DB6PM1ST4		STRU	0	0
23	PARTITN	☐			INT4	10	0
24	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
25	COMPTIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
26	LAST_RESET	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
27	BUFFPAGE	☐			DEC	22	0
28	BP_SZ	☐			DEC	22	0
29	BP_QAL	☐			DEC	8	2
30	BP_AV_RTM	☐			DEC	22	2
31	BP_AV_WTM	☐			DEC	22	2
32	BP_D_HITRT	☐			DEC	8	2
33	BP_I_HITRT	☐			DEC	8	2
34	BP_NUM	☐			DEC	22	0
35	PL_D_LRS	☐			DEC	22	0
36	PL_D_PRS	☐			DEC	22	0
37	PL_D_WS	☐			DEC	22	0
38	BP_D_SPRS	☐			DEC	22	0
39	BP_D_SWS	☐			DEC	22	0
40	PL_I_LRS	☐			DEC	22	0
41	PL_I_PRS	☐			DEC	22	0
42	PL_I_WS	☐			DEC	22	0
43	BP_I_SPRS	☐			DEC	22	0
44	BP_I_SWS	☐			DEC	22	0
45	PL_RD_TM	☐			DEC	22	0
46	PL_WT_TM	☐			DEC	22	0
47	CATCA_SZ	☐			DEC	22	0
48	CATCA_QAL	☐			DEC	8	2
49	MAXAPPLS	☐			DEC	22	0
50	PKG_CA_SZ	☐			DEC	22	0
51	PKG_CA_QAL	☐			DEC	8	2
52	CATCA_LKU	☐			DEC	22	0
53	CATCA_INS	☐			DEC	22	0
54	CATCA_OF	☐			DEC	22	0
55	CATCA_HPFL	☐			DEC	22	0
56	PKG_CA_LKU	☐			DEC	22	0
57	PKG_CA_INS	☐			DEC	22	0
58	PKG_NUM_OV	☐			DEC	22	0
59	PKG_SZ_TOP	☐			DEC	22	0
60	NUM_IOSVRS	☐			DEC	22	0
61	AV_ASP_RTM	☐			DEC	22	2
62	NUM_IOCLNS	☐			DEC	22	0
63	AV_ASP_WTM	☐			DEC	22	2
64	PL_A_DRS	☐			DEC	22	0
65	PL_A_DWS	☐			DEC	22	0
66	PL_A_IRS	☐			DEC	22	0
67	PL_A_IWS	☐			DEC	22	0
68	PL_A_RTM	☐			DEC	22	0
69	PL_A_WTM	☐			DEC	22	0
70	LCKLISTSZ	☐			DEC	22	0
71	LCK_LSTIU	☐			DEC	22	0
72	LCK_ESCALS	☐			DEC	22	0
73	X_LCK_ESCA	☐			DEC	22	0
74	LCK_WAITS	☐			DEC	22	0
75	LCK_W_TM	☐			DEC	22	0
76	AV_WTM_LCK	☐			DEC	22	2
77	LCKS_HELD	☐			DEC	22	0
78	DEADLOCKS	☐			DEC	22	0
79	LCK_TMOUT	☐			DEC	22	0
80	CMMT_SQLST	☐			DEC	22	0
81	RBCK_SQLST	☐			DEC	22	0
82	SELC_SQLST	☐			DEC	22	0
83	UID_SQLST	☐			DEC	22	0
84	DYN_SQLST	☐			DEC	22	0
85	STC_SQLST	☐			DEC	22	0
86	FAIL_SQLST	☐			DEC	22	0
87	DDL_SQLST	☐			DEC	22	0
88	RW_DELETED	☐			DEC	22	0
89	RW_INSRTED	☐			DEC	22	0
90	RW_SELECED	☐			DEC	22	0
91	RW_UPDATED	☐			DEC	22	0
92	SORTHEAPSZ	☐			DEC	22	0
93	SRT_HP_ALO	☐			DEC	22	0
94	TOT_SORTS	☐			DEC	22	0
95	TOT_SRT_TM	☐			DEC	22	0
96	AV_SORT_TM	☐			DEC	22	2
97	SRT_OF	☐			DEC	22	0
98	ACTIV_SORT	☐			DEC	22	0
99	DIRCT_RDS	☐			DEC	22	0
100	DIRCT_WTS	☐			DEC	22	0
101	DIRCT_RTM	☐			DEC	22	0
102	DIRCT_WTM	☐			DEC	22	0
103	DIRCT_RRQS	☐			DEC	22	0
104	DIRCT_WRQS	☐			DEC	22	0
105	AV_DCT_RTM	☐			DEC	22	2
106	AV_DCT_WTM	☐			DEC	22	2
107	AV_DCT_RDS	☐			DEC	22	2
108	AV_DCT_WTS	☐			DEC	22	2
109	PL_D_TE	☐			DEC	22	0
110	PL_D_FE	☐			DEC	22	0
111	PL_I_TE	☐			DEC	22	0
112	PL_I_FE	☐			DEC	22	0
113	TOT_LGUTOP	☐			DEC	22	0
114	SEC_LGUSTP	☐			DEC	22	0
115	SEC_LGALLO	☐			DEC	22	0
116	LOG_READS	☐			DEC	22	0
117	LOG_WRITES	☐			DEC	22	0
118	TOT_LGUAVG	☐			DEC	22	0
119	TOT_LGUSED	☐			DEC	22	0
120	TOT_LGAVL	☐			DEC	22	0
121	LOGBUFSZ	☐			DEC	22	0
122	LOGFILSIZ	☐			DEC	22	0
123	LOGPRIMARY	☐			DEC	22	0
124	LOGSECOND	☐			DEC	22	0
125	TOT_HAJN	☐			DEC	22	0
126	TOT_HALOOP	☐			DEC	22	0
127	HAJN_OF	☐			DEC	22	0
128	HAJN_SM_OF	☐			DEC	22	0
129	PL_TD_LRS	☐			DEC	22	0
130	PL_TD_PRS	☐			DEC	22	0
131	PL_TI_LRS	☐			DEC	22	0
132	PL_TI_PRS	☐			DEC	22	0
133	PL_A_DRRQ	☐			DEC	22	0
134	PL_A_IRRQ	☐			DEC	22	0
135	CATCASZTOP	☐			DEC	22	0
136	LSNGAP_PCT	☐			DEC	8	2
137	RESTRTRNGE	☐			DEC	8	2
138	AVGLWTPPAG	☐			DEC	22	2
139	AVGLWTPIO	☐			DEC	22	2
140	AVGLRTPPAG	☐			DEC	22	2
141	AVGLRTPIO	☐			DEC	22	2
142	LGBUFHITRT	☐			DEC	8	2
143	LOGREADTS	☐			DEC	22	0
144	LOGREADTNS	☐			DEC	22	0
145	LOGWRITS	☐			DEC	22	0
146	LOGWRITNS	☐			DEC	22	0
147	NUMLOGWRIO	☐			DEC	22	0
148	NUMLOGRDIO	☐			DEC	22	0
149	NUMLOGPPIO	☐			DEC	22	0
150	NUMLOGBFUL	☐			DEC	22	0
151	NUMLOGDFND	☐			DEC	22	0
152	LOGREDOREC	☐			DEC	22	0
153	LOGHELDDTY	☐			DEC	22	0
154	SOFTMAX	☐			INT4	10	0
155	SCPERHOUR	☐			DEC	22	0
156	ACTIVE_HASH_JOIN	☐			DEC	22	0
157	DBNAME	☐			CHAR	100	0
158	PL_ASYNC_XDA_RDS	☐			DEC	22	0
159	PL_ASYNC_XDA_RRQ	☐			DEC	22	0
160	PL_ASYNC_XDA_WRT	☐			DEC	22	0
161	PL_TEMP_XDA_L_RD	☐			DEC	22	0
162	PL_TEMP_XDA_P_RD	☐			DEC	22	0
163	POOL_XDA_L_READS	☐			DEC	22	0
164	POOL_XDA_P_READS	☐			DEC	22	0
165	POOL_XDA_WRITES	☐			DEC	22	0
166	POST_SHRTHRS_HAJ	☐			DEC	22	0
167	POST_SHRTHRS_SRT	☐			DEC	22	0
168	SMALLEST_LOG_AVL	☐			DEC	22	0
169	APPL_ID_OLDEST_X	☐			DEC	22	0
170	ELPSD_EXC_TIM_MS	☐			DEC	22	0
171	ELPSD_EXC_TIM_S	☐			DEC	22	0
172	NUM_DB_STORPATHS	☐			DEC	22	0
173	NUM_INDOUBT_TRAN	☐			DEC	22	0
174	PL_NO_VICTIM_BUF	☐			DEC	22	0
175	ROWS_WRITTEN	☐			DEC	22	0
176	ROWS_READ	☐			DEC	22	0
177	PRV_WS_NUM_OVFL	☐			DEC	22	0
178	PRV_WS_SCT_INSRT	☐			DEC	22	0
179	PRV_WS_SCT_LKUP	☐			DEC	22	0
180	PRV_WS_SIZE_TOP	☐			DEC	22	0
181	SHR_WS_NUM_OVFL	☐			DEC	22	0
182	SHR_WS_SCT_INSRT	☐			DEC	22	0
183	SHR_WS_SCT_LKUP	☐			DEC	22	0
184	SHR_WS_SIZE_TOP	☐			DEC	22	0
185	SORT_SHRHEAP_ALL	☐			DEC	22	0
186	SORT_SHRHEAP_TOP	☐			DEC	22	0
187	SHEAPTRES	☐			DEC	22	0
188	ACTIVE_OLAP_FUNCS	☐			DEC	22	0
189	ASYNC_RUNSTATS	☐			DEC	22	0
190	NUM_THRESHOLD_VIOLATIONS	☐			DEC	22	0
191	OLAP_FUNC_OVERFLOWS	☐			DEC	22	0
192	STATS_CACHE_SIZE	☐			DEC	22	0
193	STATS_FABRICATE_TIME	☐			DEC	22	0
194	STATS_FABRICATIONS	☐			DEC	22	0
195	SYNC_RUNSTATS	☐			DEC	22	0
196	SYNC_RUNSTATS_TIME	☐			DEC	22	0
197	ACC_EFFICIENCY	☐			DEC	22	1
198	BPGETS_ROWRET	☐			DEC	22	1
199	BPGETS_EXEC	☐			DEC	22	1
200	SUBMISQLST	☐			DEC	22	0
201	UNREADPFPG	☐			DEC	22	0
202	PREFETCH_WAITS	☐			DEC	22	0
203	PREFETCH_WAIT_TIME	☐			DEC	22	0
204	SKP_PRF_DATA_P_READS	☐			DEC	22	0
205	SKP_PRF_INDEX_P_READS	☐			DEC	22	0
206	SKP_PRF_TEMP_DATA_P_READS	☐			DEC	22	0
207	SKP_PRF_TEMP_INDEX_P_READS	☐			DEC	22	0
208	SKP_PRF_TEMP_XDA_P_READS	☐			DEC	22	0
209	SKP_PRF_UOW_DATA_P_READS	☐			DEC	22	0
210	SKP_PRF_UOW_INDEX_P_READS	☐			DEC	22	0
211	SKP_PRF_UOW_TEMP_DATA_P_READS	☐			DEC	22	0
212	SKP_PRF_UOW_TEMP_INDEX_P_READS	☐			DEC	22	0
213	SKP_PRF_UOW_TEMP_XDA_P_READS	☐			DEC	22	0
214	SKP_PRF_UOW_XDA_P_READS	☐			DEC	22	0
215	SKP_PRF_XDA_P_READS	☐			DEC	22	0
216	PL_QUED_ASYNC_DATA_PAGES	☐			DEC	22	0
217	PL_QUED_ASYNC_DATA_REQS	☐			DEC	22	0
218	PL_QUED_ASYNC_INDEX_PAGES	☐			DEC	22	0
219	PL_QUED_ASYNC_INDEX_REQS	☐			DEC	22	0
220	PL_QUED_ASYNC_OTHER_REQS	☐			DEC	22	0
221	PL_QUED_ASYNC_TEMP_DATA_PAGES	☐			DEC	22	0
222	PL_QUED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
223	PL_QUED_ASYNC_TEMP_INDEX_PAGES	☐			DEC	22	0
224	PL_QUED_ASYNC_TEMP_INDEX_REQS	☐			DEC	22	0
225	PL_QUED_ASYNC_TEMP_XDA_PAGES	☐			DEC	22	0
226	PL_QUED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
227	PL_QUED_ASYNC_XDA_PAGES	☐			DEC	22	0
228	PL_QUED_ASYNC_XDA_REQS	☐			DEC	22	0
229	PL_FAILED_ASYNC_DATA_REQS	☐			DEC	22	0
230	PL_FAILED_ASYNC_INDEX_REQS	☐			DEC	22	0
231	PL_FAILED_ASYNC_OTHER_REQS	☐			DEC	22	0
232	PL_FAILED_ASYNC_TEMP_DATA_REQS	☐			DEC	22	0
233	PL_FAILED_ASYNC_TEMP_INDEX_REQ	☐			DEC	22	0
234	PL_FAILED_ASYNC_TEMP_XDA_REQS	☐			DEC	22	0
235	PL_FAILED_ASYNC_XDA_REQS	☐			DEC	22	0
236	LAST_BACKUP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
237	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
238	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics - Direct Reads
239	PL_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
240	PL_D_GBP_INVALID_PAGES	☐			DEC	22	0
241	PL_D_GBP_L_READS	☐			DEC	22	0
242	PL_D_GBP_P_READS	☐			DEC	22	0
243	PL_D_LBP_PAGES_FOUND	☐			DEC	22	0
244	PL_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
245	PL_I_GBP_INVALID_PAGES	☐			DEC	22	0
246	PL_I_GBP_L_READS	☐			DEC	22	0
247	PL_I_GBP_P_READS	☐			DEC	22	0
248	PL_I_LBP_PAGES_FOUND	☐			DEC	22	0
249	PL_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
250	PL_X_GBP_INVALID_PAGES	☐			DEC	22	0
251	PL_X_GBP_L_READS	☐			DEC	22	0
252	PL_X_GBP_P_READS	☐			DEC	22	0
253	PL_X_LBP_PAGES_FOUND	☐			DEC	22	0
254	PL_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
255	PL_C_GBP_INVALID_PAGES	☐			DEC	22	0
256	PL_C_GBP_L_READS	☐			DEC	22	0
257	PL_C_GBP_P_READS	☐			DEC	22	0
258	PL_C_LBP_PAGES_FOUND	☐			DEC	22	0
259	LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
260	LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
261	GBP_HIT_RATIO	☐			DEC	22	2
262	D_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
263	D_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
264	D_GBP_HIT_RATIO	☐			DEC	22	2
265	I_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
266	I_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
267	I_GBP_HIT_RATIO	☐			DEC	22	2
268	X_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
269	X_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
270	X_GBP_HIT_RATIO	☐			DEC	22	2
271	C_LBP_GBP_DEP_HIT_RATIO	☐			DEC	22	2
272	C_LBP_GBP_IND_HIT_RATIO	☐			DEC	22	2
273	C_GBP_HIT_RATIO	☐			DEC	22	2
274	.INCLUDE	☐				0	0	DB6: Global Buffer Pool Metrics
275	PL_A_D_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
276	PL_A_D_GBP_INVALID_PAGES	☐			DEC	22	0
277	PL_A_D_GBP_L_READS	☐			DEC	22	0
278	PL_A_D_GBP_P_READS	☐			DEC	22	0
279	PL_A_D_LBP_PAGES_FOUND	☐			DEC	22	0
280	PL_A_I_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
281	PL_A_I_GBP_INVALID_PAGES	☐			DEC	22	0
282	PL_A_I_GBP_L_READS	☐			DEC	22	0
283	PL_A_I_GBP_P_READS	☐			DEC	22	0
284	PL_A_I_LBP_PAGES_FOUND	☐			DEC	22	0
285	PL_A_X_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
286	PL_A_X_GBP_INVALID_PAGES	☐			DEC	22	0
287	PL_A_X_GBP_L_READS	☐			DEC	22	0
288	PL_A_X_GBP_P_READS	☐			DEC	22	0
289	PL_A_X_LBP_PAGES_FOUND	☐			DEC	22	0
290	LBP_HIT_RATIO	☐			DEC	22	2
291	PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
292	D_LBP_HIT_RATIO	☐			DEC	22	2
293	D_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
294	I_LBP_HIT_RATIO	☐			DEC	22	2
295	I_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
296	X_LBP_HIT_RATIO	☐			DEC	22	2
297	X_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
298	PL_A_C_GBP_INDEP_PAGES_FND_LBP	☐			DEC	22	0
299	PL_A_C_GBP_INVALID_PAGES	☐			DEC	22	0
300	PL_A_C_GBP_L_READS	☐			DEC	22	0
301	PL_A_C_GBP_P_READS	☐			DEC	22	0
302	PL_A_C_LBP_PAGES_FOUND	☐			DEC	22	0
303	C_LBP_HIT_RATIO	☐			DEC	22	2
304	C_PREFETCH_PAGES_FOUND_GBP	☐			DEC	22	2
305	AVG_LOGGER_WTM	☐			DEC	22	2
306	AVG_LOGGER_RTM	☐			DEC	22	2
307	POOL_COL_L_READS	☐			DEC	22	0
308	POOL_COL_P_READS	☐			DEC	22	0
309	POOL_TEMP_COL_L_READS	☐			DEC	22	0
310	POOL_TEMP_COL_P_READS	☐			DEC	22	0
311	POOL_COL_WRITES	☐			DEC	22	0
312	PL_QUED_ASYNC_COL_PAGES	☐			DEC	22	0
313	PL_QUED_ASYNC_COL_REQS	☐			DEC	22	0
314	PL_QUED_ASYNC_TEMP_COL_PAGES	☐			DEC	22	0
315	PL_QUED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
316	PL_FAILED_ASYNC_COL_REQS	☐			DEC	22	0
317	PL_FAILED_ASYNC_TEMP_COL_REQS	☐			DEC	22	0
318	BP_C_HITRT	☐			DEC	8	2
319	BP_C_SPRS	☐			DEC	22	0
320	BP_C_SWS	☐			DEC	22	0
321	PL_ASYNC_COL_RDS	☐			DEC	22	0
322	PL_ASYNC_COL_RRQ	☐			DEC	22	0
323	PL_ASYNC_COL_WRT	☐			DEC	22	0
324	SKP_PRF_COL_P_READS	☐			DEC	22	0
325	SKP_PRF_TEMP_COL_P_READS	☐			DEC	22	0
326	SKP_PRF_UOW_COL_P_READS	☐			DEC	22	0
327	SKP_PRF_UOW_TEMP_COL_P_READS	☐			DEC	22	0
328	LOCK_WAITS_GLOBAL	☐			DEC	22	0
329	LOCK_WAIT_TIME_GLOBAL	☐			DEC	22	0
330	LOCK_TIMEOUTS_GLOBAL	☐			DEC	22	0
331	LOCK_ESCALS_MAXLOCKS	☐			DEC	22	0
332	LOCK_ESCALS_LOCKLIST	☐			DEC	22	0
333	LOCK_ESCALS_GLOBAL	☐			DEC	22	0
334	RECLAIM_WAIT_TIME	☐			DEC	22	0
335	SPACEMAPPAGE_RECLAIM_WAIT_TIME	☐			DEC	22	0
336	CF_WAITS	☐			DEC	22	0
337	CF_WAIT_TIME	☐			DEC	22	0

History

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