D_MUF_SMP_STATS (MFW)

AutoCollect DELTA Database › Delta Tables › D_MUF_SMP_STATS (MFW)

D_MUF_SMP_STATS (MFW)

ID	SQL NAME	SQL TYPE	CL	TY	SI	LE	NU	RE	RD	DI

I	D_MUF_ENABLE	SQL-STMP	S	B	N	10	N	1	N	0
IS	D_MUF_START_DATETIME	SQL-STMP	S	B	N	10	N	1	N	10
I	D_MUF_END_DATETIME	SQL-STMP	S	B	N	10	N	1	N	20
I	D_MUF_TYPE	CHAR	S	C	N	10	N	1	N	30
I	D_MUF_TOTALROW	CHAR	S	C	N	1	N	1	N	40
D	D_MUF_DURATION	DECIMAL	S	D	Y	6	N	1	N	41
L	MUF_NAME	CHAR	S	C	N	8	N	1	N	47
D	IXX_BUFFER	DECIMAL	S	D	Y	8	N	1	N	55
D	IXX_LRU	DECIMAL	S	D	Y	8	N	1	N	63
D	IXX_HASH	DECIMAL	S	D	Y	8	N	1	N	71
D	DXX_BUFFER	DECIMAL	S	D	Y	8	N	1	N	79
D	DXX_LRU	DECIMAL	S	D	Y	8	N	1	N	87
D	DXX_HASH	DECIMAL	S	D	Y	8	N	1	N	95
D	DXX_WRITE_PEND	DECIMAL	S	D	Y	8	N	1	N	103
D	DATA_BUFFER	DECIMAL	S	D	Y	8	N	1	N	111
D	DATA_LRU	DECIMAL	S	D	Y	8	N	1	N	119
D	DATA_HASH	DECIMAL	S	D	Y	8	N	1	N	127
D	DATA_WRITE_PEND	DECIMAL	S	D	Y	8	N	1	N	135
D	LOG_BUFFER	DECIMAL	S	D	Y	8	N	1	N	143
D	LOG_LRU	DECIMAL	S	D	Y	8	N	1	N	151
D	DATA_SPACE_BUFFER	DECIMAL	S	D	Y	8	N	1	N	159
D	DATA_SPACE_MGMT	DECIMAL	S	D	Y	8	N	1	N	167
D	POSTED_0	DECIMAL	S	D	Y	8	N	1	N	175
D	POSTED_1_5	DECIMAL	S	D	Y	8	N	1	N	183
D	POSTED_6_10	DECIMAL	S	D	Y	8	N	1	N	191
D	POSTED_11_23	DECIMAL	S	D	Y	8	N	1	N	199
D	POSTED_24_999	DECIMAL	S	D	Y	8	N	1	N	207
D	EXPAND_BUFFER	DECIMAL	S	D	Y	8	N	1	N	215
D	TSN	DECIMAL	S	D	Y	8	N	1	N	223
D	ADD_DELETE_FLEX	DECIMAL	S	D	Y	8	N	1	N	231
D	LOCK_LIST	DECIMAL	S	D	Y	8	N	1	N	239
D	ACCOUNTING_STATUS	DECIMAL	S	D	Y	8	N	1	N	247
D	ACCOUNTING_TABLE	DECIMAL	S	D	Y	8	N	1	N	255
D	SECURITY_CHECK	DECIMAL	S	D	Y	8	N	1	N	263
D	SQL_MISC	DECIMAL	S	D	Y	8	N	1	N	271
D	SQL_TTM	DECIMAL	S	D	Y	8	N	1	N	279
D	SQL_ATTACH	DECIMAL	S	D	Y	8	N	1	N	287
D	SQL_URT	DECIMAL	S	D	Y	8	N	1	N	295
D	SQL_PLAN	DECIMAL	S	D	Y	8	N	1	N	303
D	SQL_GLOBAL	DECIMAL	S	D	Y	8	N	1	N	311
D	SQL_STATUS	DECIMAL	S	D	Y	8	N	1	N	319
D	CBS_BUFFER	DECIMAL	S	D	Y	8	N	1	N	327
D	OPEN_TABLE	DECIMAL	S	D	Y	8	N	1	N	335
D	POSTED_LIST	DECIMAL	S	D	Y	8	N	1	N	343
D	MISCELLANEOUS	DECIMAL	S	D	Y	8	N	1	N	351
D	INDEX_QUEUE	DECIMAL	S	D	Y	8	N	1	N	359
D	TASK_AREA	DECIMAL	S	D	Y	8	N	1	N	367
D	STAR	DECIMAL	S	D	Y	8	N	1	N	375
D	WAIT_LIST	DECIMAL	S	D	Y	8	N	1	N	383
D	MEMORY_MANAGER	DECIMAL	S	D	Y	8	N	1	N	391
D	PXX_CONSOLE	DECIMAL	S	D	Y	8	N	1	N	399
D	USER_COMPRESSION	DECIMAL	S	D	Y	8	N	1	N	407
D	COVEREDVIRTUAL	DECIMAL	S	D	Y	8	N	1	N	415
D	CHECK_INTERLOCK	DECIMAL	S	D	Y	8	N	1	N	423
D	STAR_TASK	DECIMAL	S	D	Y	8	N	1	N	431
D	DSF_IN_MUF	DECIMAL	S	D	Y	8	N	1	N	439
D	WAIT_MUF_MUFPLEX	DECIMAL	S	D	Y	8	N	1	N	447
D	WAIT_COUPLER	DECIMAL	S	D	Y	8	N	1	N	455
D	PLEX_TSN_RETRY	DECIMAL	S	D	Y	8	N	1	N	463
D	PLEX_TSN_READ	DECIMAL	S	D	Y	8	N	1	N	471
D	WAIT_XCF	DECIMAL	S	D	Y	8	N	1	N	479
D	PLEX_LOG_RCD	DECIMAL	S	D	Y	8	N	1	N	487
D	PLEX_CLOSE_STAT	DECIMAL	S	D	Y	8	N	1	N	495
D	XES_MSG_REPLY	DECIMAL	S	D	Y	8	N	1	N	503
D	WAIT_PLEX_BASE	DECIMAL	S	D	Y	8	N	1	N	511
D	WAIT_PLEX_AREA	DECIMAL	S	D	Y	8	N	1	N	519
D	WAIT_PLEX_TABLE	DECIMAL	S	D	Y	8	N	1	N	527
D	PLEX_LOCK_DBYU	DECIMAL	S	D	Y	8	N	1	N	535
D	PLEX_LOCK_TSN	DECIMAL	S	D	Y	8	N	1	N	543
D	PLEX_LOCK_LOG_C	DECIMAL	S	D	Y	8	N	1	N	551
D	PLEX_LOCK_LOG_U	DECIMAL	S	D	Y	8	N	1	N	559
D	PLEX_LOCK_RUNUNIT	DECIMAL	S	D	Y	8	N	1	N	567
D	PLEX_LOCK_BUFFER	DECIMAL	S	D	Y	8	N	1	N	575
D	SQL_PROCEDURE	DECIMAL	S	D	Y	8	N	1	N	583
D	PLEX_REBUILD	DECIMAL	S	D	Y	8	N	1	N	591
D	LOGGING_CHAINS	DECIMAL	S	D	Y	8	N	1	N	599
D	LOGGING_FORCE	DECIMAL	S	D	Y	8	N	1	N	607
D	ACCOUNTING_SMP	DECIMAL	S	D	Y	8	N	1	N	615
D	SQL_MEM_MGR	DECIMAL	S	D	Y	8	N	1	N	623
D	OPEN_USER_EXIT	DECIMAL	S	D	Y	8	N	1	N	631
D	ACCESS_AREA	DECIMAL	S	D	Y	8	N	1	N	639
U	D_MUF_USERTAG	CHAR	S	C	N	16	N	1	N	647

Primary KEY columns are as follows:

MUF_NAME
D_MUF_ENABLE
D_MUF_END_DATETIME
D_MUF_TYPE
D_MUF_USERTAG
D_MUF_START_DATETIME

Secondary KEY columns are as follows:

MUF_NAME
D_MUF_ENABLE
D_MUF_END_DATETIME
D_MUF_TYPE
D_MUF_USERTAG
D_MUF_START_DATETIME
D_MUF_DURATION

Copyright © 2014 CA. All rights reserved.