SAP ABAP Table DB6_VIEW_APPLICATION_DETAIL (DB6: Application Snapshot Details)

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_VIEW_APPLICATION_DETAIL	Table Relationship Diagram
Short Description	DB6: Application Snapshot Details

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	ROW_SELECT	☐	DB6_VIEW_ROW_SELECTOR		STRU	0	0
2	CURRENT	☐			INT4	10	0
3	TOTAL	☐			INT4	10	0
4	TABSSTMT	☐	DB6PMSTMT		STRU	0	0
5	COMPTIME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
6	PARTITN	☐			INT4	10	0
7	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
8	AGENT_ID	☐			DEC	22	0
9	STMT_TYPE	☐			CHAR	25	0
10	STMT_OPERA	☐			CHAR	50	0
11	RW_READ	☐			DEC	22	0
12	RW_WRITTEN	☐			DEC	22	0
13	STMT_LEN	☐			INT4	10	0
14	STMT_TEXT	☐			STRG	0	0
15	PL_TD_LRS	☐			DEC	22	0
16	PL_TD_PRS	☐			DEC	22	0
17	PL_TI_LRS	☐			DEC	22	0
18	PL_TI_PRS	☐			DEC	22	0
19	BLKCURSOR	☐			CHAR	10	0
20	STMTELAS	☐			DEC	22	0
21	STMTELAMS	☐			DEC	22	0
22	PL_D_LRS	☐			DEC	22	0
23	PL_D_PRS	☐			DEC	22	0
24	PL_I_LRS	☐			DEC	22	0
25	PL_I_PRS	☐			DEC	22	0
26	STMTSTRTDT	☐			DATS	8	0
27	STMTSTRTTM	☐			TIMS	6	0
28	STMTSTOPDT	☐			DATS	8	0
29	STMTSTOPTM	☐			TIMS	6	0
30	TOT_SRT_TM	☐			DEC	22	0
31	STMT_SORTS	☐			DEC	22	0
32	SRT_OF	☐			DEC	22	0
33	TABSAPPL	☐	DB6PMSAPP		STRU	0	0
34	COMPTIME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
35	PARTITN	☐			INT4	10	0
36	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
37	AUTH_ID	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
38	AGENT_ID	☐			DEC	22	0
39	AGENT_PID	☐			DEC	22	0
40	APPL_NAME	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
41	CLI_PID	☐			DEC	22	0
42	CLI_HOST	☐	NI_HOSTNAME		CHAR	63	0	Host Name
43	CLI_PLATFO	☐			CHAR	25	0
44	AP_STATUS	☐			CHAR	50	0
45	BP_QAL	☐			DEC	8	2
46	BP_AV_RTM	☐			DEC	22	2
47	BP_AV_WTM	☐			DEC	22	2
48	BP_D_HITRT	☐			DEC	8	2
49	BP_I_HITRT	☐			DEC	8	2
50	PL_D_LRS	☐			DEC	22	0
51	PL_D_PRS	☐			DEC	22	0
52	PL_D_WS	☐			DEC	22	0
53	PL_I_LRS	☐			DEC	22	0
54	PL_I_PRS	☐			DEC	22	0
55	PL_I_WS	☐			DEC	22	0
56	PL_RD_TM	☐			DEC	22	0
57	PL_WT_TM	☐			DEC	22	0
58	DIRCT_RDS	☐			DEC	22	0
59	DIRCT_WTS	☐			DEC	22	0
60	DIRCT_RTM	☐			DEC	22	0
61	DIRCT_WTM	☐			DEC	22	0
62	DIRCT_RRQS	☐			DEC	22	0
63	DIRCT_WRQS	☐			DEC	22	0
64	AV_DCT_RTM	☐			DEC	22	0
65	AV_DCT_WTM	☐			DEC	22	0
66	AV_DCT_RDS	☐			DEC	22	0
67	AV_DCT_WTS	☐			DEC	22	0
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	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	TOT_SORTS	☐			DEC	22	0
93	TOT_SRT_TM	☐			DEC	22	0
94	AV_SORT_TM	☐			DEC	22	2
95	SRT_OF	☐			DEC	22	0
96	CATCA_QAL	☐			DEC	8	2
97	PKG_CA_QAL	☐			DEC	8	2
98	CATCA_LKU	☐			DEC	22	0
99	CATCA_INS	☐			DEC	22	0
100	CATCA_OF	☐			DEC	22	0
101	CATCA_HPFL	☐			DEC	22	0
102	PKG_CA_LKU	☐			DEC	22	0
103	PKG_CA_INS	☐			DEC	22	0
104	AP_CON_DT	☐			DATS	8	0
105	AP_CON_TM	☐			TIMS	6	0
106	AP_IDLE_TM	☐			DEC	22	0
107	PF_WTTM	☐			DEC	22	0
108	AGT_UCP_S	☐			DEC	22	0
109	AGT_SCT_S	☐			DEC	22	0
110	CRD_AG_PID	☐			DEC	22	0
111	NUM_ASS_AG	☐			DEC	22	0
112	ASS_AGT_TP	☐			DEC	22	0
113	AGT_STOLEN	☐			DEC	22	0
114	UOW_STRTDT	☐			DATS	8	0
115	UOW_STRTTM	☐			TIMS	6	0
116	UOW_STOPDT	☐			DATS	8	0
117	UOW_STOPTM	☐			TIMS	6	0
118	UOW_LWTM	☐			DEC	22	0
119	UOW_LGSPUD	☐			DEC	22	0
120	PR_UOW_SDT	☐			DATS	8	0
121	PR_UOW_STM	☐			TIMS	6	0
122	UOW_ELA_S	☐			DEC	22	0
123	UOW_ELA_MS	☐			DEC	22	0
124	UOW_CMPSTA	☐			CHAR	50	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	POOL_XDA_L_READS	☐			DEC	22	0
134	POOL_XDA_P_READS	☐			DEC	22	0
135	POOL_XDA_WRITES	☐			DEC	22	0
136	PL_TEMP_XDA_L_RD	☐			DEC	22	0
137	PL_TEMP_XDA_P_RD	☐			DEC	22	0
138	ELPSD_EXC_TIM_MS	☐			DEC	22	0
139	ELPSD_EXC_TIM_S	☐			DEC	22	0
140	INACT_STMTHISTSZ	☐			DEC	22	0
141	LOCK_TIMEOUT_VAL	☐			DEC	22	0
142	PRV_WS_NUM_OVFL	☐			DEC	22	0
143	PRV_WS_SCT_INSRT	☐			DEC	22	0
144	PRV_WS_SCT_LKUP	☐			DEC	22	0
145	PRV_WS_SIZE_TOP	☐			DEC	22	0
146	SHR_WS_NUM_OVFL	☐			DEC	22	0
147	SHR_WS_SCT_INSRT	☐			DEC	22	0
148	SHR_WS_SCT_LKUP	☐			DEC	22	0
149	SHR_WS_SIZE_TOP	☐			DEC	22	0
150	SESSION_AUTH_ID	☐			CHAR	128	0
151	TPMON_ACC_STR	☐			CHAR	200	0
152	TPMON_CLIENT_APP	☐			CHAR	256	0
153	TPMON_CLIENT_UID	☐			CHAR	256	0
154	TPMON_CLIENT_WKS	☐			CHAR	256	0
155	AUTHORITY_LEVEL	☐			CHAR	512	0
156	OLAP_FUNC_OVERFLOWS	☐			DEC	22	0
157	TOTAL_OLAP_FUNCS	☐			DEC	22	0
158	WORKLOAD_ID	☐			INT4	10	0
159	IS_SYSTEM_APPL	☐			INT2	5	0
160	AGENT_PRIO	☐			INT2	5	0
161	AGENT_PRIO_MAX	☐			INT2	5	0
162	AGENT_PRIO_MIN	☐			INT2	5	0
163	PREFETCH_PRIO	☐			INT2	5	0
164	PREFETCH_PRIO_MAX	☐			INT2	5	0
165	PREFETCH_PRIO_MIN	☐			INT2	5	0
166	POOL_COL_L_READS	☐			DEC	22	0
167	POOL_COL_P_READS	☐			DEC	22	0
168	POOL_TEMP_COL_L_READS	☐			DEC	22	0
169	POOL_TEMP_COL_P_READS	☐			DEC	22	0
170	POOL_COL_WRITES	☐			DEC	22	0
171	BP_C_HITRT	☐			DEC	8	0
172	MEMORY_POOLS	☐	DB6PMSAGENT_MEMORY_POOL_TAB		TTYP	0	0
173	ASSIGNED_AGENTS	☐	DB6WLM_SC_AGENTS_TAB		TTYP	0	0

History

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