SAP ABAP Table DB6PM1ST4 (DB6: Initial Screen of Transaction ST04)

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	DB6PM1ST4	Table Relationship Diagram
Short Description	DB6: Initial Screen of Transaction ST04

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

History

Last changed by/on	SAP	20141013
SAP Release Created in