SAP ABAP Table DB6PMSA (DB6: Application Snapshot)

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	DB6PMSA	Table Relationship Diagram
Short Description	DB6: Application Snapshot

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	.INCLUDE	☐				0	0	DB6: application info snapshot part of DB6PMSA
2	PARTITN	☐			INT4	10	0
3	AGENT_ID	☐			DEC	22	0
4	AP_STATUS	☐			CHAR	50	0
5	CODEPG_ID	☐			DEC	22	0
6	NUM_ASS_AG	☐			DEC	22	0
7	CRD_NODE	☐			DEC	22	0
8	AUTHORITY_LEVEL	☐			CHAR	512	0
9	CLI_PID	☐			DEC	22	0
10	CRD_AG_PID	☐			DEC	22	0
11	STAT_CHGTM	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
12	CLI_PLATFO	☐			CHAR	25	0
13	CLI_PRTC	☐			CHAR	25	0
14	COUNTRY_CD	☐			INT4	10	0
15	APPL_NAME	☐			CHAR	256	0
16	APPL_ID	☐			CHAR	128	0
17	SEQU_NO	☐			CHAR	5	0
18	AUTH_ID	☐			CHAR	128	0
19	SESSION_AUTH_ID	☐			CHAR	128	0
20	CLI_NAME	☐			CHAR	128	0
21	CLI_PRDID	☐			CHAR	128	0
22	IN_DB_ALIA	☐			CHAR	128	0
23	CLI_DBALIA	☐			CHAR	128	0
24	DB_NAME	☐			CHAR	128	0
25	DB_PATH	☐			CHAR	1024	0
26	EXEC_ID	☐			CHAR	128	0
27	CORR_TOKEN	☐			CHAR	128	0
28	TPMON_ACC_STR	☐			CHAR	200	0
29	TPMON_CLIENT_APP	☐			CHAR	256	0
30	TPMON_CLIENT_UID	☐			CHAR	256	0
31	TPMON_CLIENT_WKS	☐			CHAR	256	0
32	WORKLOAD_ID	☐			INT4	10	0
33	IS_SYSTEM_APPL	☐			INT2	5	0
34	COMPTIME	☑	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
35	CALLERFLAG	☑			CHAR	1	0
36	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
37	PRGVERS	☐			CHAR	20	0
38	IPADDRESS	☐	NI_NODEADDR	NI_NODEADDR	CHAR	45	0	IP Address
39	LCKS_HELD	☐			DEC	22	0
40	LCK_WAITS	☐			DEC	22	0
41	LCK_W_TM	☐			DEC	22	0
42	LCK_ESCALS	☐			DEC	22	0
43	X_LCK_ESCA	☐			DEC	22	0
44	DEADLOCKS	☐			DEC	22	0
45	UOW_LWTM	☐			DEC	22	0
46	TOT_SORTS	☐			DEC	22	0
47	TOT_SRT_TM	☐			DEC	22	0
48	SRT_OF	☐			DEC	22	0
49	PL_D_LRS	☐			DEC	22	0
50	PL_D_PRS	☐			DEC	22	0
51	PL_D_WS	☐			DEC	22	0
52	PL_I_LRS	☐			DEC	22	0
53	PL_I_PRS	☐			DEC	22	0
54	PL_I_WS	☐			DEC	22	0
55	PL_RD_TM	☐			DEC	22	0
56	PL_WT_TM	☐			DEC	22	0
57	CMMT_SQLST	☐			DEC	22	0
58	RBCK_SQLST	☐			DEC	22	0
59	DYN_SQLST	☐			DEC	22	0
60	STC_SQLST	☐			DEC	22	0
61	FAIL_SQLST	☐			DEC	22	0
62	SELC_SQLST	☐			DEC	22	0
63	DDL_SQLST	☐			DEC	22	0
64	UID_SQLST	☐			DEC	22	0
65	INT_ATRBND	☐			DEC	22	0
66	INT_RW_DEL	☐			DEC	22	0
67	INT_RW_UPD	☐			DEC	22	0
68	INT_CMMTS	☐			DEC	22	0
69	INT_RB	☐			DEC	22	0
70	INT_DL_RB	☐			DEC	22	0
71	RW_DELETED	☐			DEC	22	0
72	RW_INSRTED	☐			DEC	22	0
73	RW_UPDATED	☐			DEC	22	0
74	RW_SELECED	☐			DEC	22	0
75	BIND_PRECC	☐			DEC	22	0
76	UOW_LGSPUD	☐			DEC	22	0
77	UOW_CMPSTA	☐			CHAR	50	0
78	PR_UOW_STM	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
79	UOW_STRTTM	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
80	UOW_STOPTM	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
81	OPN_RM_CR	☐			DEC	22	0
82	OPN_RM_CRB	☐			DEC	22	0
83	REJ_CR_BLK	☐			DEC	22	0
84	ACC_CU_BLK	☐			DEC	22	0
85	AP_CON_TM	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
86	CN_CMPL_TM	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
87	LAST_RESET	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
88	AP_IDLE_TM	☐			DEC	22	0
89	PL_D_TE	☐			DEC	22	0
90	PL_I_TE	☐			DEC	22	0
91	PL_I_FE	☐			DEC	22	0
92	PL_D_FE	☐			DEC	22	0
93	AUTHO_LVL	☐			DEC	22	0
94	SQL_RSCMMT	☐			DEC	22	0
95	NUM_SCAPS	☐			DEC	22	0
96	LCK_TMOUT	☐			DEC	22	0
97	AGT_UCP_S	☐			DEC	22	0
98	AGT_UPT_MS	☐			DEC	22	0
99	AGT_SCT_S	☐			DEC	22	0
100	AGT_SPT_MS	☐			DEC	22	0
101	INT_RW_INS	☐			DEC	22	0
102	RW_READ	☐			DEC	22	0
103	RW_WRITTEN	☐			DEC	22	0
104	DIRCT_RDS	☐			DEC	22	0
105	DIRCT_WTS	☐			DEC	22	0
106	DIRCT_RRQS	☐			DEC	22	0
107	DIRCT_WRQS	☐			DEC	22	0
108	DIRCT_RTM	☐			DEC	22	0
109	DIRCT_WTM	☐			DEC	22	0
110	OPN_LC_CR	☐			DEC	22	0
111	OPN_LC_CRB	☐			DEC	22	0
112	PKG_CA_LKU	☐			DEC	22	0
113	PKG_CA_INS	☐			DEC	22	0
114	CATCA_LKU	☐			DEC	22	0
115	CATCA_INS	☐			DEC	22	0
116	CATCA_OF	☐			DEC	22	0
117	CATCA_HPFL	☐			DEC	22	0
118	NUM_AGENTS	☐			DEC	22	0
119	AGT_STOLEN	☐			DEC	22	0
120	ASS_AGT_TP	☐			DEC	22	0
121	AP_PRIO	☐			DEC	22	0
122	AP_PRIO_TY	☐			CHAR	25	0
123	PF_WTTM	☐			DEC	22	0
124	AP_SEC_LKU	☐			DEC	22	0
125	AP_SEC_INS	☐			DEC	22	0
126	LCK_WTING	☐			DEC	22	0
127	OB_CN_ADDR	☐	DB6LONGID		CHAR	32	0	DB6: Long identifier
128	INBND_CNAD	☐	DB6LONGID		CHAR	32	0	DB6: Long identifier
129	OB_CN_PRTC	☐			INT4	10	0
130	TOT_HAJN	☐			DEC	22	0
131	TOT_HALOOP	☐			DEC	22	0
132	HAJN_OF	☐			DEC	22	0
133	HAJN_SM_OF	☐			DEC	22	0
134	UOW_ELA_S	☐			DEC	22	0
135	UOW_ELA_MS	☐			DEC	22	0
136	UNREADPFPG	☐			DEC	22	0
137	PL_TD_LRS	☐			DEC	22	0
138	PL_TD_PRS	☐			DEC	22	0
139	PL_TI_LRS	☐			DEC	22	0
140	PL_TI_PRS	☐			DEC	22	0
141	POOL_XDA_L_READS	☐			DEC	22	0
142	POOL_XDA_P_READS	☐			DEC	22	0
143	POOL_XDA_WRITES	☐			DEC	22	0
144	PL_TEMP_XDA_L_RD	☐			DEC	22	0
145	PL_TEMP_XDA_P_RD	☐			DEC	22	0
146	ELPSD_EXC_TIM_MS	☐			DEC	22	0
147	ELPSD_EXC_TIM_S	☐			DEC	22	0
148	INACT_STMTHISTSZ	☐			DEC	22	0
149	LOCK_TIMEOUT_VAL	☐			DEC	22	0
150	PRV_WS_NUM_OVFL	☐			DEC	22	0
151	PRV_WS_SCT_INSRT	☐			DEC	22	0
152	PRV_WS_SCT_LKUP	☐			DEC	22	0
153	PRV_WS_SIZE_TOP	☐			DEC	22	0
154	SHR_WS_NUM_OVFL	☐			DEC	22	0
155	SHR_WS_SCT_INSRT	☐			DEC	22	0
156	SHR_WS_SCT_LKUP	☐			DEC	22	0
157	SHR_WS_SIZE_TOP	☐			DEC	22	0
158	OLAP_FUNC_OVERFLOWS	☐			DEC	22	0
159	TOTAL_OLAP_FUNCS	☐			DEC	22	0

History

Last changed by/on	SAP	20141013
SAP Release Created in