SAP ABAP Table DB6PMSQ_DBS (DB6: Temporary database store for 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	TRANSP	Transparent table
Transparent table	DB6PMSQ_DBS	Table Relationship Diagram
Short Description	DB6: Temporary database store for SQL Cache

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	SYSID	☑	DBA_SYSID	DBA_SYSID	CHAR	8	0	DBA Cockpit: System Identification
2	COMPTIME	☑	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
3	PARTITN	☑			INT4	10	0
4	ARTIF_KEY	☑			INT4	10	0
5	CALLERFLAG	☑			CHAR	1	0
6	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
7	PRGVERS	☐			CHAR	20	0
8	NUM_EXECUT	☐			DEC	22	0
9	NUM_COMPIL	☐			DEC	22	0
10	PREPTWORST	☐			DEC	22	0
11	PREPTBEST	☐			DEC	22	0
12	INT_RW_DEL	☐			DEC	22	0
13	INT_RW_INS	☐			DEC	22	0
14	RW_READ	☐			DEC	22	0
15	INT_RW_UPD	☐			DEC	22	0
16	RW_WRITTEN	☐			DEC	22	0
17	STMT_SORTS	☐			DEC	22	0
18	TOTEXETS	☐			DEC	22	0
19	TOTEXETMS	☐			DEC	22	0
20	TOTUSRCTS	☐			DEC	22	0
21	TOTUSRCTMS	☐			DEC	22	0
22	TOTSYSCTS	☐			DEC	22	0
23	TOTSYSCTMS	☐			DEC	22	0
24	DB_NAME	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
25	PL_D_LRS	☐			DEC	22	0
26	PL_D_PRS	☐			DEC	22	0
27	PL_I_LRS	☐			DEC	22	0
28	PL_I_PRS	☐			DEC	22	0
29	PL_TD_LRS	☐			DEC	22	0
30	PL_TD_PRS	☐			DEC	22	0
31	PL_TI_LRS	☐			DEC	22	0
32	PL_TI_PRS	☐			DEC	22	0
33	SORT_OVERFLOWS	☐			DEC	22	0
34	TOTAL_SORT_TIME	☐			DEC	22	0
35	PL_XDA_LRS	☐			DEC	22	0
36	PL_XDA_PRS	☐			DEC	22	0
37	PL_TEMP_XDA_LRS	☐			DEC	22	0
38	PL_TEMP_XDA_PRS	☐			DEC	22	0
39	STATS_FABRICATE_	☐			DEC	22	0
40	SYNC_RUNSTATS_TI	☐			DEC	22	0
41	ROWS_RETURNED	☐			DEC	22	0
42	STMT_PKGCACHE_ID	☐			DEC	22	0
43	INSERT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
44	STMT_LEN	☐			INT2	5	0
45	STMT_TEXT	☐			LCHR	32000	0

History

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