SAP ABAP Table DB6PMSD (DB6: Database 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	DB6PMSD	Table Relationship Diagram
Short Description	DB6: Database 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	COMPTIME	☑	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
2	PARTITN	☑			INT4	10	0
3	CALLERFLAG	☑			CHAR	1	0
4	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
5	PRGVERS	☐			CHAR	20	0
6	IN_DB_ALIA	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
7	DB_NAME	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
8	DB_PATH	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
9	LCKS_HELD	☐			DEC	22	0
10	LCK_WAITS	☐			DEC	22	0
11	LCK_W_TM	☐			DEC	22	0
12	LCK_LSTIU	☐			DEC	22	0
13	DEADLOCKS	☐			DEC	22	0
14	LCK_ESCALS	☐			DEC	22	0
15	X_LCK_ESCA	☐			DEC	22	0
16	LCK_WTING	☐			DEC	22	0
17	SRT_HP_ALO	☐			DEC	22	0
18	TOT_SORTS	☐			DEC	22	0
19	TOT_SRT_TM	☐			DEC	22	0
20	SRT_OF	☐			DEC	22	0
21	ACTIV_SORT	☐			DEC	22	0
22	PL_D_LRS	☐			DEC	22	0
23	PL_D_PRS	☐			DEC	22	0
24	PL_D_WS	☐			DEC	22	0
25	PL_I_LRS	☐			DEC	22	0
26	PL_I_PRS	☐			DEC	22	0
27	PL_I_WS	☐			DEC	22	0
28	PL_RD_TM	☐			DEC	22	0
29	PL_WT_TM	☐			DEC	22	0
30	FLS_CLOSED	☐			DEC	22	0
31	CMMT_SQLST	☐			DEC	22	0
32	RBCK_SQLST	☐			DEC	22	0
33	DYN_SQLST	☐			DEC	22	0
34	STC_SQLST	☐			DEC	22	0
35	FAIL_SQLST	☐			DEC	22	0
36	SELC_SQLST	☐			DEC	22	0
37	DDL_SQLST	☐			DEC	22	0
38	UID_SQLST	☐			DEC	22	0
39	INT_ATRBND	☐			DEC	22	0
40	INT_RW_DEL	☐			DEC	22	0
41	INT_RW_UPD	☐			DEC	22	0
42	INT_CMMTS	☐			DEC	22	0
43	INT_RB	☐			DEC	22	0
44	INT_DL_RB	☐			DEC	22	0
45	RW_DELETED	☐			DEC	22	0
46	RW_INSRTED	☐			DEC	22	0
47	RW_UPDATED	☐			DEC	22	0
48	RW_SELECED	☐			DEC	22	0
49	BIND_PRECC	☐			DEC	22	0
50	DB_CN_TM	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
51	LAST_RESET	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
52	LAST_BKUP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
53	TOTAL_CONS	☐			DEC	22	0
54	APL_CUR_CO	☐			DEC	22	0
55	APL_IN_DB2	☐			DEC	22	0
56	SEC_LGUSTP	☐			DEC	22	0
57	TOT_LGUTOP	☐			DEC	22	0
58	SEC_LGALLO	☐			DEC	22	0
59	NUM_SCDBS	☐			DEC	22	0
60	PL_A_IRS	☐			DEC	22	0
61	PL_D_TE	☐			DEC	22	0
62	PL_I_TE	☐			DEC	22	0
63	PL_I_FE	☐			DEC	22	0
64	PL_D_FEI	☐			DEC	22	0
65	DB_STATUS	☐			CHAR	25	0
66	LCK_TMOUT	☐			DEC	22	0
67	CN_TOP	☐			DEC	22	0
68	DB_HP_TOP	☐			DEC	22	0
69	PL_A_DRS	☐			DEC	22	0
70	PL_A_DWS	☐			DEC	22	0
71	PL_A_IWS	☐			DEC	22	0
72	PL_A_RTM	☐			DEC	22	0
73	PL_A_WTM	☐			DEC	22	0
74	PL_A_DRRQ	☐			DEC	22	0
75	PL_LSNGCL	☐			DEC	22	0
76	PL_DPSCL	☐			DEC	22	0
77	PL_DPTCL	☐			DEC	22	0
78	DIRCT_RDS	☐			DEC	22	0
79	DIRCT_WTS	☐			DEC	22	0
80	DIRCT_RRQS	☐			DEC	22	0
81	DIRCT_WRQS	☐			DEC	22	0
82	DIRCT_RTM	☐			DEC	22	0
83	DIRCT_WTM	☐			DEC	22	0
84	INT_RW_INS	☐			DEC	22	0
85	LOG_READS	☐			DEC	22	0
86	LOG_WRITES	☐			DEC	22	0
87	PKG_CA_LKU	☐			DEC	22	0
88	PKG_CA_INS	☐			DEC	22	0
89	CATCA_LKU	☐			DEC	22	0
90	CATCA_INS	☐			DEC	22	0
91	CATCA_OF	☐			DEC	22	0
92	CATCA_HPFL	☐			DEC	22	0
93	CAT_NODE	☐			DEC	22	0
94	TOT_SEC_CN	☐			DEC	22	0
95	NUM_ASS_AG	☐			DEC	22	0
96	AGENTS_TOP	☐			DEC	22	0
97	CRD_AG_TOP	☐			DEC	22	0
98	DB_LOCAT	☐			CHAR	25	0
99	SERV_PLATF	☐			CHAR	25	0
100	CAT_ND_NME	☐	DB6LONGID		CHAR	32	0	DB6: Long identifier
101	PF_WTTM	☐			DEC	22	0
102	AP_SEC_LKU	☐			DEC	22	0
103	AP_SEC_INS	☐			DEC	22	0
104	TOT_HAJN	☐			DEC	22	0
105	TOT_HALOOP	☐			DEC	22	0
106	HAJN_OF	☐			DEC	22	0
107	HAJN_SM_OF	☐			DEC	22	0
108	TOT_LGUSED	☐			DEC	22	0
109	TOT_LGAVL	☐			DEC	22	0
110	UNREADPFPG	☐			DEC	22	0
111	PKG_NUM_OV	☐			DEC	22	0
112	PKG_SZ_TOP	☐			DEC	22	0
113	PL_TD_LRS	☐			DEC	22	0
114	PL_TD_PRS	☐			DEC	22	0
115	PL_TI_LRS	☐			DEC	22	0
116	PL_TI_PRS	☐			DEC	22	0
117	PL_A_IRRQ	☐			DEC	22	0
118	CATCASZTOP	☐			DEC	22	0
119	LOGREADTS	☐			DEC	22	0
120	LOGREADTNS	☐			DEC	22	0
121	LOGWRITS	☐			DEC	22	0
122	LOGWRITNS	☐			DEC	22	0
123	NUMLOGWRIO	☐			DEC	22	0
124	NUMLOGRDIO	☐			DEC	22	0
125	NUMLOGPPIO	☐			DEC	22	0
126	NUMLOGBFUL	☐			DEC	22	0
127	NUMLOGDFND	☐			DEC	22	0
128	LOGREDOREC	☐			DEC	22	0
129	LOGHELDDTY	☐			DEC	22	0
130	ACTIVE_HASH_JOIN	☐			DEC	22	0
131	DBNAME	☐			CHAR	100	0
132	PL_ASYNC_XDA_RDS	☐			DEC	22	0
133	PL_ASYNC_XDA_RRQ	☐			DEC	22	0
134	PL_ASYNC_XDA_WRT	☐			DEC	22	0
135	PL_TEMP_XDA_L_RD	☐			DEC	22	0
136	PL_TEMP_XDA_P_RD	☐			DEC	22	0
137	POOL_XDA_L_READS	☐			DEC	22	0
138	POOL_XDA_P_READS	☐			DEC	22	0
139	POOL_XDA_WRITES	☐			DEC	22	0
140	POST_SHRTHRS_HAJ	☐			DEC	22	0
141	POST_SHRTHRS_SRT	☐			DEC	22	0
142	SMALLEST_LOG_AVL	☐			DEC	22	0
143	APPL_ID_OLDEST_X	☐			DEC	22	0
144	ELPSD_EXC_TIM_MS	☐			DEC	22	0
145	ELPSD_EXC_TIM_S	☐			DEC	22	0
146	NUM_DB_STORPATHS	☐			DEC	22	0
147	NUM_INDOUBT_TRAN	☐			DEC	22	0
148	PL_NO_VICTIM_BUF	☐			DEC	22	0
149	ROWS_READ	☐			DEC	22	0
150	PRV_WS_NUM_OVFL	☐			DEC	22	0
151	PRV_WS_SCT_INSRT	☐			DEC	22	0
152	PRV_WS_SCT_LKUP	☐			DEC	22	0
153	PRV_WS_SIZE_TOP	☐			DEC	22	0
154	SHR_WS_NUM_OVFL	☐			DEC	22	0
155	SHR_WS_SCT_INSRT	☐			DEC	22	0
156	SHR_WS_SCT_LKUP	☐			DEC	22	0
157	SHR_WS_SIZE_TOP	☐			DEC	22	0
158	SORT_SHRHEAP_ALL	☐			DEC	22	0
159	SORT_SHRHEAP_TOP	☐			DEC	22	0
160	ACTIVE_OLAP_FUNCS	☐			DEC	22	0
161	ASYNC_RUNSTATS	☐			DEC	22	0
162	NUM_THRESHOLD_VIOLATIONS	☐			DEC	22	0
163	OLAP_FUNC_OVERFLOWS	☐			DEC	22	0
164	STATS_CACHE_SIZE	☐			DEC	22	0
165	STATS_FABRICATE_TIME	☐			DEC	22	0
166	STATS_FABRICATIONS	☐			DEC	22	0
167	SYNC_RUNSTATS	☐			DEC	22	0
168	SYNC_RUNSTATS_TIME	☐			DEC	22	0
169	POOL_COL_L_READS	☐			DEC	22	0
170	POOL_COL_P_READS	☐			DEC	22	0
171	POOL_TEMP_COL_L_READS	☐			DEC	22	0
172	POOL_TEMP_COL_P_READS	☐			DEC	22	0
173	POOL_COL_WRITES	☐			DEC	22	0

History

Last changed by/on	SAP	20140117
SAP Release Created in