SAP ABAP Table DB6PMSQC (DB6: SQL Cache Snapshot and Percentage Columns)

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	DB6PMSQC	Table Relationship Diagram
Short Description	DB6: SQL Cache Snapshot and Percentage Columns

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	ARTIF_KEY	☐			INT4	10	0
4	CALLERFLAG	☐			CHAR	1	0
5	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
6	PRGVERS	☐			CHAR	20	0
7	NUM_EXECUT	☐			DEC	22	0
8	NUM_COMPIL	☐			DEC	22	0
9	PREPTWORST	☐			DEC	22	0
10	PREPTBEST	☐			DEC	22	0
11	INT_RW_DEL	☐			DEC	22	0
12	INT_RW_INS	☐			DEC	22	0
13	RW_READ	☐			DEC	22	0
14	INT_RW_UPD	☐			DEC	22	0
15	RW_WRITTEN	☐			DEC	22	0
16	STMT_SORTS	☐			DEC	22	0
17	TOTEXETS	☐			DEC	22	0
18	TOTEXETMS	☐			DEC	22	0
19	TOTUSRCTS	☐			DEC	22	0
20	TOTUSRCTMS	☐			DEC	22	0
21	TOTSYSCTS	☐			DEC	22	0
22	TOTSYSCTMS	☐			DEC	22	0
23	EXETMSPCT	☐			DEC	22	2
24	READPCT	☐			DEC	22	2
25	WRITTENPCT	☐			DEC	22	2
26	AVGEXECTMS	☐			DEC	22	2
27	AVGRRTMS	☐			DEC	22	2
28	AVGRWTMS	☐			DEC	22	2
29	DB_NAME	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
30	STMT_LEN	☐			INT4	10	0
31	STMT_TEXT	☐			STRG	0	0
32	AUTH_ID	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
33	PL_D_LRS	☐			DEC	22	0
34	PL_D_PRS	☐			DEC	22	0
35	PL_I_LRS	☐			DEC	22	0
36	PL_I_PRS	☐			DEC	22	0
37	PL_TD_LRS	☐			DEC	22	0
38	PL_TD_PRS	☐			DEC	22	0
39	PL_TI_LRS	☐			DEC	22	0
40	PL_TI_PRS	☐			DEC	22	0
41	SORT_OVERFLOWS	☐			DEC	22	0
42	TOTAL_SORT_TIME	☐			DEC	22	0
43	PL_XDA_LRS	☐			DEC	22	0
44	PL_XDA_PRS	☐			DEC	22	0
45	PL_TEMP_XDA_LRS	☐			DEC	22	0
46	PL_TEMP_XDA_PRS	☐			DEC	22	0
47	COLOR	☐	LVC_CIFNM	CHAR30	CHAR	30	0	ALV control: Field name with simple row color coding
48	BP_QAL	☐			DEC	8	2
49	STATS_FABRICATE_TIME	☐			DEC	22	0
50	SYNC_RUNSTATS_TIME	☐			DEC	22	0
51	ROWS_RETURNED	☐			DEC	22	0
52	STMT_PKGCACHE_ID	☐			DEC	22	0
53	INSERT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
54	ACC_EFFICIENCY	☐			DEC	22	1
55	BPGETS_ROWRET	☐			DEC	22	1
56	BPGETS_EXEC	☐			DEC	22	1
57	SHORT_STMT_TEXT	☐			STRG	0	0
58	PL_COL_LRS	☐			DEC	22	0
59	PL_COL_PRS	☐			DEC	22	0
60	PL_TEMP_COL_LRS	☐			DEC	22	0
61	PL_TEMP_COL_PRS	☐			DEC	22	0

History

Last changed by/on	SAP	20141013
SAP Release Created in