SAP ABAP Table DB6PMSQ (DB6: Snapshot SQL Cache)

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	DB6PMSQ	Table Relationship Diagram
Short Description	DB6: Snapshot SQL Cache

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	DB_NAME	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
24	PL_D_LRS	☐			DEC	22	0
25	PL_D_PRS	☐			DEC	22	0
26	PL_I_LRS	☐			DEC	22	0
27	PL_I_PRS	☐			DEC	22	0
28	PL_TD_LRS	☐			DEC	22	0
29	PL_TD_PRS	☐			DEC	22	0
30	PL_TI_LRS	☐			DEC	22	0
31	PL_TI_PRS	☐			DEC	22	0
32	SORT_OVERFLOWS	☐			DEC	22	0
33	TOTAL_SORT_TIME	☐			DEC	22	0
34	PL_XDA_LRS	☐			DEC	22	0
35	PL_XDA_PRS	☐			DEC	22	0
36	PL_TEMP_XDA_LRS	☐			DEC	22	0
37	PL_TEMP_XDA_PRS	☐			DEC	22	0
38	STATS_FABRICATE_TIME	☐			DEC	22	0
39	SYNC_RUNSTATS_TIME	☐			DEC	22	0
40	ROWS_RETURNED	☐			DEC	22	0
41	STMT_PKGCACHE_ID	☐			DEC	22	0
42	INSERT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
43	STMT_LEN	☐			INT4	10	0
44	STMT_TEXT	☐			STRG	0	0

History

Last changed by/on	SAP	20110908
SAP Release Created in