SAP ABAP Table DB4_VIEW_PERF_OVERVIEW (DB4: View data for performance overview)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Table Category	INTTAB	Structure
Structure	DB4_VIEW_PERF_OVERVIEW	Table Relationship Diagram
Short Description	DB4: View data for performance overview

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	SAP_SID	☐			STRG	0	0
2	SCHEMA_NAME	☐			STRG	0	0
3	SAP_TYPE	☐			STRG	0	0
4	ASP_NUMBER	☐			INT2	5	0
5	ASP_DEVICE	☐			STRG	0	0
6	HOST_ID_KEY	☐			STRG	0	0
7	HOST_ID	☐			INT4	10	0
8	HOST_NAME	☐			STRG	0	0
9	IPLDATA_HOST_NAME_TAB	☐	DBAKEYVAL_TAB		TTYP	0	0
10	OSRELEASE	☐			STRG	0	0
11	SERIAL_NUMBER	☐			STRG	0	0
12	IPL_TIME_NR	☐			STRG	0	0
13	IPL_NUMBER	☐			INT4	10	0
14	IPL_TIME	☐			STRG	0	0
15	IPLDATA_TIME_TAB	☐	DBAKEYVAL_TAB		TTYP	0	0
16	CUMULATIVE	☐			STRG	0	0
17	CUM_LEVEL	☐			INT4	10	0
18	CUM_STATUS	☐			INT2	5	0
19	HIPER	☐			STRG	0	0
20	HIPER_LEVEL	☐			INT4	10	0
21	HIPER_STATUS	☐			INT2	5	0
22	DBGROUP	☐			STRG	0	0
23	DBGROUP_LEVEL	☐			INT4	10	0
24	DBGROUP_STATUS	☐			INT2	5	0
25	SQL_SUMMARY_TS_KEY	☐			STRG	0	0
26	SQL_SUMMARY_TS_LOCAL	☐			STRG	0	0
27	SQL_SUMMARY_TS_UTC	☐			STRG	0	0
28	SQL_SUMMARY_TS_LOCAL_LIST	☐	DBAKEYVAL_TAB		TTYP	0	0
29	SUM_INTERVAL_SECS	☐			INT4	10	0
30	SUM_NUMBER_CALLS	☐			INT4	10	0
31	SUM_TIME_PER_CALL_MS	☐			DEC	15	5
32	SUM_NUMBER_ROWS	☐			INT4	10	0
33	SUM_TBLSCAN_NUMBER	☐			INT4	10	0
34	SUM_TBLSCAN_TOT_MS	☐			DEC	15	0
35	SUM_TMPMETH_NUMBER	☐			INT4	10	0
36	SUM_TMPMETH_TOT_MS	☐			DEC	15	0
37	NUMBER_PACKAGES	☐			INT4	10	0
38	PKG_TOTALSIZE_KB	☐			DEC	15	0
39	LARGE_PKG01_LIBRFILE	☐			STRG	0	0
40	LARGE_PKG01_LIB	☐			STRG	0	0
41	LARGE_PKG01_NAME	☐			STRG	0	0
42	LARGE_PKG01_SIZE_KB	☐			DEC	15	0
43	CPU_DATA_TS_ID	☐			STRG	0	0
44	CPU_DATA_TS_LOCAL	☐			STRG	0	0
45	CPU_DATA_TS_UTC	☐			STRG	0	0
46	CPU_DATA_TS_LIST	☐	DBAKEYVAL_TAB		TTYP	0	0
47	MIN_AVAIL_MIN	☐			DEC	21	3
48	AVG_AVAIL_USED_AVG	☐			DEC	21	3
49	AVG_WAIT_DBLOCK_SECS_WP_AVG	☐			DEC	21	3
50	MAX_WAIT_DBLOCK_SECS_WP_MAX	☐			DEC	21	3
51	AVG_WAIT_NDBLOCK_SECS_WP_AVG	☐			DEC	21	3
52	MAX_WAIT_NDBLOCK_SECS_WP_MAX	☐			DEC	21	3
53	AVG_DISK_ASP_SIZE_MB	☐			DEC	21	3
54	MAX_DISK_ASP_FULL_PERCENT	☐			DEC	21	3
55	DISK_BALANCE_QUALITY	☐			DEC	21	3
56	MAX_DISK_SERVTIME_MAX	☐			DEC	21	3
57	AVG_DISK_SERVTIME_AVG	☐			DEC	21	3
58	PICK_RCV	☐			CHAR	70	0

History

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