solidDB Help : solidDB reference : SQL: System events
  
SQL: 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.
Unless otherwise specified, the system events have the same five parameters as listed in the following table:
 
Parameter
Type
Description
ENAME
WVARCHAR
The event name.
POSTSRVTIME
TIMESTAMP
The time that the server posted the event.
UID
INTEGER
The user ID (if applicable).
NUMDATAINFO
INTEGER
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 can be NULL if there is no numeric data.
TEXTDATA
WVARCHAR
Miscellaneous text data — the exact meaning depends upon the event. This parameter can be NULL if there is no numeric data.
Note For a description of events related to Advanced Replication, see Advanced Replication: Synchronization events.
See
Miscellaneous events
HotStandby system events
Conditions or warnings that cause SYS_EVENT_ERROR
Conditions or warnings that cause SYS_EVENT_MESSAGES