SAP ABAP Table DB6_VIEW_WLM_THRVIOLATION_D (DB6: view data for WLM threshold violation detail screen)

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_WLM_THRVIOLATION_D	Table Relationship Diagram
Short Description	DB6: view data for WLM threshold violation detail screen

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	ACTIVITY_DETAILS	☐	DB6WLM_ACTIVITY		STRU	0	0
2	ACT_EXEC_TIME	☐			DEC	22	0
3	ACTIVATE_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
4	ACTIVITY_ID	☐			DEC	22	0
5	ACTIVITY_SECONDARY_ID	☐			INT2	5	0
6	ACTIVITY_TYPE	☐			STRG	0	0
7	UOW_ID	☐			INT4	10	0
8	PARENT_ACTIVITY_ID	☐			DEC	22	0
9	PARENT_UOW_ID	☐			INT4	10	0
10	AGENT_ID	☐			DEC	22	0
11	APPL_ID	☐			STRG	0	0
12	APPL_NAME	☐			STRG	0	0
13	COORD_PARTITION_NUM	☐	DB6PARTNAM		CHAR	4	0	DB6: Partition Name for Listbox Element
14	DB_WORK_ACTION_SET_ID	☐			INT4	10	0
15	DB_WORK_CLASS_ID	☐			INT4	10	0
16	PARTIAL_RECORD	☐			INT2	5	0
17	POOL_DATA_L_READS	☐			DEC	22	0
18	POOL_DATA_P_READS	☐			DEC	22	0
19	POOL_INDEX_L_READS	☐			DEC	22	0
20	POOL_INDEX_P_READS	☐			DEC	22	0
21	POOL_TEMP_DATA_L_READS	☐			DEC	22	0
22	POOL_TEMP_DATA_P_READS	☐			DEC	22	0
23	POOL_TEMP_INDEX_L_READS	☐			DEC	22	0
24	POOL_TEMP_INDEX_P_READS	☐			DEC	22	0
25	POOL_TEMP_XDA_L_READS	☐			DEC	22	0
26	POOL_TEMP_XDA_P_READS	☐			DEC	22	0
27	POOL_XDA_L_READS	☐			DEC	22	0
28	POOL_XDA_P_READS	☐			DEC	22	0
29	POOL_TEMP_COL_L_READS	☐			DEC	22	0
30	POOL_TEMP_COL_P_READS	☐			DEC	22	0
31	POOL_COL_L_READS	☐			DEC	22	0
32	POOL_COL_P_READS	☐			DEC	22	0
33	PREP_TIME	☐			DEC	22	0
34	SYSTEM_CPU_TIME	☐			DEC	22	0
35	USER_CPU_TIME	☐			DEC	22	0
36	QUERY_CARD_ESTIMATE	☐			DEC	22	0
37	QUERY_COST_ESTIMATE	☐			DEC	22	0
38	ROWS_FETCHED	☐			DEC	22	0
39	ROWS_MODIFIED	☐			DEC	22	0
40	ROWS_RETURNED	☐			DEC	22	0
41	SC_WORK_ACTION_SET_ID	☐			INT4	10	0
42	SC_WORK_CLASS_ID	☐			INT4	10	0
43	SERVICE_SUBCLASS_NAME	☐			STRG	0	0
44	SERVICE_SUPERCLASS_NAME	☐			STRG	0	0
45	WORKLOAD_ID	☐			INT4	10	0
46	WORKLOAD_OCCURRENCE_ID	☐			INT4	10	0
47	SESSION_AUTH_ID	☐			STRG	0	0
48	TOTAL_SORT_TIME	☐			DEC	22	0
49	TOTAL_SORTS	☐			DEC	22	0
50	SORT_OVERFLOWS	☐			DEC	22	0
51	SQLCODE	☐			INT4	10	0
52	SQLSTATE	☐			CHAR	5	0
53	TIME_COMPLETED	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
54	TIME_CREATED	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
55	TIME_STARTED	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
56	TPMON_ACC_STR	☐			STRG	0	0
57	TPMON_CLIENT_APP	☐			STRG	0	0
58	TPMON_CLIENT_USERID	☐			STRG	0	0
59	TPMON_CLIENT_WKSTN	☐			STRG	0	0
60	EXPANDED	☐			CHAR	1	0
61	BP_QUALITY	☐			DEC	6	2
62	ACTIVITYSTMTS	☐	DB6WLM_ACTIVITYSTMT_TAB		TTYP	0	0
63	ACTIVITYVALS	☐	DB6WLM_ACTIVITYVALS_TAB		TTYP	0	0
64	ACTIVITYVALS_DISP	☐	DB6WLM_ACTIVITYVALS_DISP_TAB		TTYP	0	0
65	SHOW_V97_FEATURES	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
66	ACTIVITYSTMT	☐	DB6WLM_ACTIVITYSTMT		STRU	0	0
67	ACTIVATE_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
68	ACTIVITY_ID	☐			DEC	22	0
69	ACTIVITY_SECONDARY_ID	☐			INT2	5	0
70	UOW_ID	☐			INT4	10	0
71	APPL_ID	☐			STRG	0	0
72	COMP_ENV_DESCR	☐			RSTR	0	0
73	SECTION_ENV	☐			RSTR	0	0
74	SECTION_NUMBER	☐			DEC	22	0
75	STMT_FIRST_USE_TIME	☐			STRG	0	0
76	STMT_ISOLATION	☐			DEC	22	0
77	STMT_LAST_USE_TIME	☐			STRG	0	0
78	STMT_LOCK_TIMEOUT	☐			INT4	10	0
79	STMT_NEST_LEVEL	☐			DEC	22	0
80	STMT_PKGCACHE_ID	☐			DEC	22	0
81	STMT_QUERY_ID	☐			DEC	22	0
82	STMT_SOURCE_ID	☐			DEC	22	0
83	STMT_TYPE	☐			DEC	22	0
84	STMT_TEXT	☐			STRG	0	0
85	WLM_EVMONS	☐	CL_DB6_WLM_EVMONS		REF	0	0

History

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