SQL Guide : System events
  
System events
This section describes the solidDB® system events. These events are provided with solidDB® to allow programs to be notified when certain actions occur. You can use these events to monitor the progress of activities such as synchronization between master and replica databases.
The system events follow most of the same rules as user-defined events.
Because these events are pre-defined, you do not create them. Furthermore, you cannot post system events; you can only wait on system events.
Most system events have the same five parameters:
Parameter
Description
ename
The event name.
postsrvtime
The time that the server posted the event.
uid
The user ID (if applicable).
numdatainfo
Miscellaneous numeric data — the exact meaning depends upon the event. For example, the event SYS_EVENT_BACKUP is posted both when a backup is started and when a backup is completed. The value in the numdatainfo parameter indicates which case applies — that is, whether the backup has just started or has just completed. This parameter may be NULL if there is no numeric data.
textdata
Miscellaneous text data — the exact meaning depends upon the event. This parameter may be NULL if there is no numeric data.
Note:
For a description of events related to HotStandby, see solidDB® High Availability User Guide.
For a description of events related to advanced replication, see solidDB® Advanced Replication User Guide.
See also
Miscellaneous events
Conditions or warnings that cause SYS_EVENT_ERROR
Conditions or warnings that cause SYS_EVENT_MESSAGES