_progress._KeyEvt
The purpose of this table is to store key events in the database. Key events are events such as database startup parameters, certain error messages, structural changes to the database, utilities run on the database, etc. that provide a history that can be reviewed by tech support. Such a history is useful when diagnosing customer issues especially when the database log file is missing or has been truncated.
Fields
Order
Field Name
x
Label
Datatype
Format
Initial
Mand
Description
2
_KeyEvt-Date
X Key Event TimeStamp
datetime-tz
99/99/9999 HH:MM:SS.SSS+HH:MM
?
8
_KeyEvt-Event
X Key Event Description
character
x(200)
?
V: e sz 70 BY 3 sv MAX-CHARS 70
5
_KeyEvt-MsgId
X Key Event Message ID
integer
->,>>>,>>>,>>9
?
3
_KeyEvt-Procid
X Key Event Process ID
integer
->,>>>,>>>,>>9
?
9
_KeyEvt-Spare1
X Key Event Spare Int
integer
->,>>>,>>>,>>9
?
10
_KeyEvt-Spare2
X Key Event Spare Char
character
x(32)
?
4
_KeyEvt-ThreadId
X Key Event Thread ID
integer
->,>>>,>>>,>>9
?
7
_KeyEvt-Usrnum
X Key Event User Number
integer
->,>>>,>>>,>>9
?
6
_KeyEvt-Usrtyp
X Key Event User Type
character
x(16)
?
Order
Field Name
x
Label
Datatype
Format
Initial
Mand
Description
2
_KeyEvt-Date
X Key Event TimeStamp
datetime-tz
99/99/9999 HH:MM:SS.SSS+HH:MM
?
3
_KeyEvt-Procid
X Key Event Process ID
integer
->,>>>,>>>,>>9
?
4
_KeyEvt-ThreadId
X Key Event Thread ID
integer
->,>>>,>>>,>>9
?
5
_KeyEvt-MsgId
X Key Event Message ID
integer
->,>>>,>>>,>>9
?
6
_KeyEvt-Usrtyp
X Key Event User Type
character
x(16)
?
7
_KeyEvt-Usrnum
X Key Event User Number
integer
->,>>>,>>>,>>9
?
8
_KeyEvt-Event
X Key Event Description
character
x(200)
?
V: e sz 70 BY 3 sv MAX-CHARS 70
9
_KeyEvt-Spare1
X Key Event Spare Int
integer
->,>>>,>>>,>>9
?
10
_KeyEvt-Spare2
X Key Event Spare Char
character
x(32)
?
Indexes
Index name
Flags
Fields
Datatype
_KeyEvt-Date
P
_KeyEvt-Date (+)
datetime-tz
_KeyEvt-MsgId
_KeyEvt-MsgId (+)
integer
_KeyEvt-Usrnum
_KeyEvt-Usrnum (+)
integer
+ = Ascending
- = Descending
P = Primary
U = Unique
I = Inactive
W = Wordindex