_progress._KeyEvent
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
_KeyEvent-Date
X ?
datetime-tz
99/99/9999 HH:MM:SS.SSS+HH:MM
?
7
_KeyEvent-Event
X ?
character
x(200)
?
V: e sz 70 BY 3 sv MAX-CHARS 200
5
_KeyEvent-MsgId
X ?
integer
->,>>>,>>>,>>9
?
3
_KeyEvent-Procid
X ?
integer
->,>>>,>>>,>>9
?
8
_KeyEvent-Spare1
X ?
integer
->,>>>,>>>,>>9
?
9
_KeyEvent-Spare2
X ?
character
x(32)
?
4
_KeyEvent-ThreadId
X ?
integer
->,>>>,>>>,>>9
?
6
_KeyEvent-Usrnum
X ?
integer
->,>>>,>>>,>>9
?
Order
Field Name
x
Label
Datatype
Format
Initial
Mand
Description
2
_KeyEvent-Date
X ?
datetime-tz
99/99/9999 HH:MM:SS.SSS+HH:MM
?
3
_KeyEvent-Procid
X ?
integer
->,>>>,>>>,>>9
?
4
_KeyEvent-ThreadId
X ?
integer
->,>>>,>>>,>>9
?
5
_KeyEvent-MsgId
X ?
integer
->,>>>,>>>,>>9
?
6
_KeyEvent-Usrnum
X ?
integer
->,>>>,>>>,>>9
?
7
_KeyEvent-Event
X ?
character
x(200)
?
V: e sz 70 BY 3 sv MAX-CHARS 200
8
_KeyEvent-Spare1
X ?
integer
->,>>>,>>>,>>9
?
9
_KeyEvent-Spare2
X ?
character
x(32)
?
Indexes
Index name
Flags
Fields
Datatype
_KeyEvent-Usrnum
P
_KeyEvent-Usrnum (+)
integer
_KeyEvent-Date
U
_KeyEvent-Date (+)
datetime-tz
_KeyEvent-MsgId
_KeyEvent-MsgId (+)
integer
+ = Ascending
- = Descending
P = Primary
U = Unique
I = Inactive
W = Wordindex