Contains one row for each configuration change event. ch_events is located in the sysmgmtdb database.
The columns for ch_events are:
Name | Datatype | Description |
---|---|---|
area | varchar(10)not null | Area in which the event occurs. One of:
|
type | varchar(30)not null | Type of auditable event. One of:
|
target | varchar(30) null | Name of the objects to which the change applies. |
element | varchar(255) null | Configuration parameter or other option name. |
oldvalue | varchar(255) null | Value of event prior to change. |
newvalue | varchar(255) null | Value of event after change. |
mode | varchar(10) null | Status for configuration parameters: static or dynamic. |
timestamp | datetime not null | Date and time the event takes place. For changes to the configuration file and abrupt shutdowns, timestamp indicates the time the event was detected, not when the event took place. |
username | varchar(30) null | Name of the user who made the change. Set to null for:
|
instanceid | tinyint null | (Cluster Edition only) ID of the instance. |