Previous Topic: Delta TablesNext Topic: D_MUF_AREA_STATS (MFA)


D_MUF_ACCOUNTING (MFY)

ID

SQL NAME

SQL TYPE

CL

TY

SI

LN

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

L

DBID

SMALLINT

S

B

Y

2

N

1

N

55

L

TABLE_NAME

CHAR

S

C

N

3

N

1

N

57

L

BUFFER_SIZE

INTEGER

S

B

Y

4

N

1

N

60

L

TABLE_STATUS

CHAR

S

C

N

1

N

1

N

64

L

THRESHOLD

INTEGER

S

B

Y

4

N

1

N

65

L

SPILLING

CHAR

S

C

N

1

N

1

N

69

D

TOTAL_REQUESTS

DECIMAL

S

D

Y

8

N

1

N

70

D

PHYSICAL_READWRITE

DECIMAL

S

D

Y

8

N

1

N

78

D

LOCATES

DECIMAL

S

D

Y

8

N

1

N

86

D

TOTAL_ADDS

DECIMAL

S

D

Y

8

N

1

N

94

D

TOTAL_UPDATES

DECIMAL

S

D

Y

8

N

1

N

102

D

UNAVAILABLE

DECIMAL

S

D

Y

8

N

1

N

110

D

CONFLICTS

DECIMAL

S

D

Y

8

N

1

N

118

D

SKIPPED

DECIMAL

S

D

Y

8

N

1

N

126

D

ENTRIES

DECIMAL

S

D

Y

8

N

1

N

134

D

RECLAIMED

DECIMAL

S

D

Y

8

N

1

N

142

D

LOCATES_STARTED

DECIMAL

S

D

Y

8

N

1

N

150

D

SPILLS_THRESHOLD

DECIMAL

S

D

Y

8

N

1

N

158

D

SPILLS_INTERNAL

DECIMAL

S

D

Y

8

N

1

N

166

U

D_MUF_USERTAG

CHAR

S

C

N

16

N

1

N

174

Primary KEY columns are as follows:

Secondary KEY columns are as follows: