Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Logged Data : Saving key database events : _KeyEvt table : _KeyEvt schema
 
_KeyEvt schema
The _KeyEvt table stores key events in the database. The table below describes the active fields of the _KeyEvt table.
Table 57. _KeyEvt table schema
Field name
Description
Data type
Format
_KeyEvt-Date
The date and time, in DATETIME-TZ format, when the event occurred
DATETIME-TZ
99/99/9999 HH:MM:SS.SSS+HH:M
_KeyEvt-Procid
The process id of the process that logged the key event message
INTEGER
->,>>>,>>>,>>9
_KeyEvt-ThreadId
The thread of the process that logged the key event message
INTEGER
->,>>>,>>>,>>9
_KeyEvt-MsgId
The message number of the event
INTEGER
->,>>>,>>>,>>9
_KeyEvt-Usrtyp
The type of user that logged the event, for example, BROKER, DBUTIL, KEVTRDR, Usr, etc.
CHARACTER
X(32)
_KeyEvt-Usrnum
The user number of the user that logged the event
INTEGER
->,>>>,>>>,>>9
_KeyEvt-Event
The message text associated with the key event
CHARACTER
X(200)