CAWGJRUV Glossary

CAWGJRUV/RECORD

1

112

H

USER/NAME

1

8

C

USERS NAME

USER/CODE

9

2

C

USERS 2 DIGIT USERCODE

USER/TYPE

11

1

C

1 = DBA, 0 = NON-DBA

OK/EDITOR

12

1

C

PERMISSION TO USE EDITOR

OK/UGEN

13

1

C

PERMISSION TO USE UGEN

OK/UPREP

14

1

C

PERMISSION TO USE UPREP

OK/DATADEF

15

1

C

PERMISSION TO USE DATA DEF

OK/LUW

16

1

C

PERMISSION TO USE LUW

OK/FUNCTIONS

17

1

C

PERMISSION TO USE FUNCTIONS

OK/OVERCPU

18

1

C

PERM N TO OVERRIDE CPU/IO

SP1

19

2

C

LIMIT/CPU

21

4

B

LMT ON CPU SECS BEFORE WARN

LIMIT/IO

25

4

B

LMT OF I/O

USED/CPU

29

4

B

CPU USED SINCE LAST CLEAR

USED/IO/REQ

33

4

B

I/O REQUESTS SINCE LAST CLR

USED/ACTUAL/IO

37

4

B

ACTUAL I/O SINCE LAST CLEAR

CPU/WARNINGS

41

4

B

COUNT CPU WARNINGS GIVEN

IO/WARNINGS

45

4

B

COUNT I/O WARNINGS GIVEN

RESOURCE/WAIT

49

4

B

USR WAITED FOR RESOURCE CNT

DATADEF/CMDS

53

4

B

DATA DEFINITION COMMANDS

DATADICT/UPDATES

57

4

B

DATA DICT UPDATES SINCE CLR

INTERGRITY/VIOL

61

4

B

INTEGRITY VIOLATIONS

USER/ROLLED/LUW

65

4

B

USER ROLLED BACK LUW

USER/DEADLOCK

69

4

B

USER CAUSED A DEADLOCK

FORCED

73

4

B

TIMES FORCED SINCE CLEAR

CPU/SINCE/THOLD

77

4

B

CPU SINCE LAST THRESHOLD

IO/SINCE/THOLD

81

4

B

I/O SINCE LAST THRESHOLD

USERID

85

8

C

USERID OF MACHINE

INTERFACE/FLGS

93

4

B

INTERFACE FLAGS

TIME/CONNECT

97

8

C

TIME USER CONNECTED TO DB

TIME/DISCONNECT

105

8

C

TIME USER DISCONNECTED FR DB