Previous Topic: Snapshot TablesNext Topic: S_MUF_AREA_STATS (MFA)


S_MUF_ACCOUNTING (MFY)

SQL NAME

SQL TYPE

CLS

TYP

SGN

LNG

NUL

REP

RDF

DSP

 

 

 

 

 

 

 

 

 

 

S_MUF_ENABLE

SQL-STMP

S

B

N

10

N

1

N

0

S_MUF_DATETIME

SQL-STMP

S

B

N

10

N

1

N

10

S_MUF_TOTALROW

CHAR

S

C

N

1

N

1

N

20

MUF_NAME

CHAR

S

C

N

8

N

1

N

21

DBID

SMALLINT

S

B

Y

2

N

1

N

29

TABLE_NAME

CHAR

S

C

N

3

N

1

N

31

BUFFER_SIZE

INTEGER

S

B

Y

4

N

1

N

34

TABLE_STATUS

CHAR

S

C

N

1

N

1

N

38

THRESHOLD

INTEGER

S

B

Y

4

N

1

N

39

SPILLING

CHAR

S

C

N

1

N

1

N

43

TOTAL_REQUESTS

DECIMAL

S

D

Y

8

N

1

N

44

PHYSICAL_READWRITE

DECIMAL

S

D

Y

8

N

1

N

52

LOCATES

DECIMAL

S

D

Y

8

N

1

N

60

TOTAL_ADDS

DECIMAL

S

D

Y

8

N

1

N

68

TOTAL_UPDATES

DECIMAL

S

D

Y

8

N

1

N

76

UNAVAILABLE

DECIMAL

S

D

Y

8

N

1

N

84

CONFLICTS

DECIMAL

S

D

Y

8

N

1

N

92

SKIPPED

DECIMAL

S

D

Y

8

N

1

N

100

ENTRIES

DECIMAL

S

D

Y

8

N

1

N

108

RECLAIMED

DECIMAL

S

D

Y

8

N

1

N

116

LOCATES_STARTED

DECIMAL

S

D

Y

8

N

1

N

124

SPILLS_THRESHOLD

DECIMAL

S

D

Y

8

N

1

N

132

SPILLS_INTERNAL

DECIMAL

S

D

Y

8

N

1

N

140

Primary KEY columns are as follows:

Secondary KEY columns are as follows: