SAP ABAP Table DB6PMSAPP (DB6: Application 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	DB6PMSAPP	Table Relationship Diagram
Short Description	DB6: Application 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	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
4	AUTH_ID	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
5	AGENT_ID	☐			DEC	22	0
6	AGENT_PID	☐			DEC	22	0
7	APPL_NAME	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
8	CLI_PID	☐			DEC	22	0
9	CLI_HOST	☐	NI_HOSTNAME		CHAR	63	0	Host Name
10	CLI_PLATFO	☐			CHAR	25	0
11	AP_STATUS	☐			CHAR	50	0
12	BP_QAL	☐			DEC	8	2
13	BP_AV_RTM	☐			DEC	22	2
14	BP_AV_WTM	☐			DEC	22	2
15	BP_D_HITRT	☐			DEC	8	2
16	BP_I_HITRT	☐			DEC	8	2
17	PL_D_LRS	☐			DEC	22	0
18	PL_D_PRS	☐			DEC	22	0
19	PL_D_WS	☐			DEC	22	0
20	PL_I_LRS	☐			DEC	22	0
21	PL_I_PRS	☐			DEC	22	0
22	PL_I_WS	☐			DEC	22	0
23	PL_RD_TM	☐			DEC	22	0
24	PL_WT_TM	☐			DEC	22	0
25	DIRCT_RDS	☐			DEC	22	0
26	DIRCT_WTS	☐			DEC	22	0
27	DIRCT_RTM	☐			DEC	22	0
28	DIRCT_WTM	☐			DEC	22	0
29	DIRCT_RRQS	☐			DEC	22	0
30	DIRCT_WRQS	☐			DEC	22	0
31	AV_DCT_RTM	☐			DEC	22	0
32	AV_DCT_WTM	☐			DEC	22	0
33	AV_DCT_RDS	☐			DEC	22	0
34	AV_DCT_WTS	☐			DEC	22	0
35	PL_D_TE	☐			DEC	22	0
36	PL_D_FE	☐			DEC	22	0
37	PL_I_TE	☐			DEC	22	0
38	PL_I_FE	☐			DEC	22	0
39	LCK_ESCALS	☐			DEC	22	0
40	X_LCK_ESCA	☐			DEC	22	0
41	LCK_WAITS	☐			DEC	22	0
42	LCK_W_TM	☐			DEC	22	0
43	AV_WTM_LCK	☐			DEC	22	2
44	LCKS_HELD	☐			DEC	22	0
45	DEADLOCKS	☐			DEC	22	0
46	LCK_TMOUT	☐			DEC	22	0
47	CMMT_SQLST	☐			DEC	22	0
48	RBCK_SQLST	☐			DEC	22	0
49	SELC_SQLST	☐			DEC	22	0
50	UID_SQLST	☐			DEC	22	0
51	DYN_SQLST	☐			DEC	22	0
52	STC_SQLST	☐			DEC	22	0
53	FAIL_SQLST	☐			DEC	22	0
54	DDL_SQLST	☐			DEC	22	0
55	RW_DELETED	☐			DEC	22	0
56	RW_INSRTED	☐			DEC	22	0
57	RW_SELECED	☐			DEC	22	0
58	RW_UPDATED	☐			DEC	22	0
59	TOT_SORTS	☐			DEC	22	0
60	TOT_SRT_TM	☐			DEC	22	0
61	AV_SORT_TM	☐			DEC	22	2
62	SRT_OF	☐			DEC	22	0
63	CATCA_QAL	☐			DEC	8	2
64	PKG_CA_QAL	☐			DEC	8	2
65	CATCA_LKU	☐			DEC	22	0
66	CATCA_INS	☐			DEC	22	0
67	CATCA_OF	☐			DEC	22	0
68	CATCA_HPFL	☐			DEC	22	0
69	PKG_CA_LKU	☐			DEC	22	0
70	PKG_CA_INS	☐			DEC	22	0
71	AP_CON_DT	☐			DATS	8	0
72	AP_CON_TM	☐			TIMS	6	0
73	AP_IDLE_TM	☐			DEC	22	0
74	PF_WTTM	☐			DEC	22	0
75	AGT_UCP_S	☐			DEC	22	0
76	AGT_SCT_S	☐			DEC	22	0
77	CRD_AG_PID	☐			DEC	22	0
78	NUM_ASS_AG	☐			DEC	22	0
79	ASS_AGT_TP	☐			DEC	22	0
80	AGT_STOLEN	☐			DEC	22	0
81	UOW_STRTDT	☐			DATS	8	0
82	UOW_STRTTM	☐			TIMS	6	0
83	UOW_STOPDT	☐			DATS	8	0
84	UOW_STOPTM	☐			TIMS	6	0
85	UOW_LWTM	☐			DEC	22	0
86	UOW_LGSPUD	☐			DEC	22	0
87	PR_UOW_SDT	☐			DATS	8	0
88	PR_UOW_STM	☐			TIMS	6	0
89	UOW_ELA_S	☐			DEC	22	0
90	UOW_ELA_MS	☐			DEC	22	0
91	UOW_CMPSTA	☐			CHAR	50	0
92	TOT_HAJN	☐			DEC	22	0
93	TOT_HALOOP	☐			DEC	22	0
94	HAJN_OF	☐			DEC	22	0
95	HAJN_SM_OF	☐			DEC	22	0
96	PL_TD_LRS	☐			DEC	22	0
97	PL_TD_PRS	☐			DEC	22	0
98	PL_TI_LRS	☐			DEC	22	0
99	PL_TI_PRS	☐			DEC	22	0
100	POOL_XDA_L_READS	☐			DEC	22	0
101	POOL_XDA_P_READS	☐			DEC	22	0
102	POOL_XDA_WRITES	☐			DEC	22	0
103	PL_TEMP_XDA_L_RD	☐			DEC	22	0
104	PL_TEMP_XDA_P_RD	☐			DEC	22	0
105	ELPSD_EXC_TIM_MS	☐			DEC	22	0
106	ELPSD_EXC_TIM_S	☐			DEC	22	0
107	INACT_STMTHISTSZ	☐			DEC	22	0
108	LOCK_TIMEOUT_VAL	☐			DEC	22	0
109	PRV_WS_NUM_OVFL	☐			DEC	22	0
110	PRV_WS_SCT_INSRT	☐			DEC	22	0
111	PRV_WS_SCT_LKUP	☐			DEC	22	0
112	PRV_WS_SIZE_TOP	☐			DEC	22	0
113	SHR_WS_NUM_OVFL	☐			DEC	22	0
114	SHR_WS_SCT_INSRT	☐			DEC	22	0
115	SHR_WS_SCT_LKUP	☐			DEC	22	0
116	SHR_WS_SIZE_TOP	☐			DEC	22	0
117	SESSION_AUTH_ID	☐			CHAR	128	0
118	TPMON_ACC_STR	☐			CHAR	200	0
119	TPMON_CLIENT_APP	☐			CHAR	256	0
120	TPMON_CLIENT_UID	☐			CHAR	256	0
121	TPMON_CLIENT_WKS	☐			CHAR	256	0
122	AUTHORITY_LEVEL	☐			CHAR	512	0
123	OLAP_FUNC_OVERFLOWS	☐			DEC	22	0
124	TOTAL_OLAP_FUNCS	☐			DEC	22	0
125	WORKLOAD_ID	☐			INT4	10	0
126	IS_SYSTEM_APPL	☐			INT2	5	0
127	AGENT_PRIO	☐			INT2	5	0
128	AGENT_PRIO_MAX	☐			INT2	5	0
129	AGENT_PRIO_MIN	☐			INT2	5	0
130	PREFETCH_PRIO	☐			INT2	5	0
131	PREFETCH_PRIO_MAX	☐			INT2	5	0
132	PREFETCH_PRIO_MIN	☐			INT2	5	0
133	POOL_COL_L_READS	☐			DEC	22	0
134	POOL_COL_P_READS	☐			DEC	22	0
135	POOL_TEMP_COL_L_READS	☐			DEC	22	0
136	POOL_TEMP_COL_P_READS	☐			DEC	22	0
137	POOL_COL_WRITES	☐			DEC	22	0
138	BP_C_HITRT	☐			DEC	8	0

History

Last changed by/on	SAP	20140117
SAP Release Created in	46C