Previous Topic: S_MUF_SYSTEM_STATS (MFS)Next Topic: S_MUF_TCB_OR_SRB (MTC)


S_MUF_TABLE_STATS (MFT)

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

BEGIN_TIME

SQL-STMP

S

B

N

10

N

1

N

29

CURRENT_DATETIME

SQL-STMP

S

B

N

10

N

1

N

39

DBID

SMALLINT

S

B

Y

2

N

1

N

49

TABLE_NAME

CHAR

S

C

N

3

N

1

N

51

AREA_NAME

CHAR

S

C

N

3

N

1

N

54

TOTAL_REQUESTS

DECIMAL

S

D

Y

8

N

1

N

57

TOTAL_READS

DECIMAL

S

D

Y

8

N

1

N

65

TOTAL_ADDS

DECIMAL

S

D

Y

8

N

1

N

73

TOTAL_DELETES

DECIMAL

S

D

Y

8

N

1

N

81

TOTAL_UPDATES

DECIMAL

S

D

Y

8

N

1

N

89

Primary KEY columns are as follows:

Secondary KEY columns are as follows: