Previous Topic: D_MUF_AREA_STATS (MFA)Next Topic: D_MUF_CONFIG (MCF)


D_MUF_CBS (MCB)

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

CJAR

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

BUF_CUR_PERC_FULL

SMALLINT

S

B

N

2

N

1

N

55

L

BUT_MAX_PERC_FULL

SMALLINT

S

B

N

2

N

1

N

57

L

CUR_USED_SET_MEM

INTEGER

S

B

N

4

N

1

N

59

L

MAX_USED_SET_MEM

INTEGER

S

B

N

4

N

1

N

63

L

SETS_DEL_MAX_AGE

DECIMAL

S

D

Y

8

N

1

N

67

D

SETS_FETCHED

DECIMAL

S

D

Y

8

N

1

N

75

D

SETS_PROCESSED

DECIMAL

S

D

Y

8

N

1

N

83

D

SETS_SPILLED

DECIMAL

S

D

7

8

N

1

N

91

D

SETS_TEMP_INDEX

DECIMAL

S

D

Y

8

N

1

N

99

D

TEMP_INDEX_ENTRIES

DECIMAL

S

D

Y

8

N

1

N

107

L

SPILLED_JOB_NAME

CHAR

S

C

N

8

Y

1

N

116

L

SPILLED_UIB

CHAR

S

C

N

32

Y

1

N

125

L

DURATION_AT_SPILL

CHAR

S

C

N

6

Y

1

N

158

U

D_MUF_USERTAG

CHAR

S

C

N

16

N

1

N

164

Primary KEY columns are as follows:

Secondary KEY columns are as follows: