iAnywhere.com - Choosing a system event

Choosing a system event

Adaptive Server Anywhere tracks several system events. Each system event provides a hook on which you can hang a set of actions. The database server tracks the events for you, and executes the actions (as defined in the event handler) when needed.

The available system events include the following:

Backup You can use the BackupEnd event type to take action at the end of a backup.
DatabaseStart You can use the DatabaseStart event type to take action when a database is started.
Connection events When a connection is made (Connect) or when a connection attempt fails (ConnectFailed). You may want to use these events for security purposes.
Disconnect You can use the Disconnect event to take action when a user or application disconnects.
Free disk space Tracks the available disk space on the device holding the database file (DBDiskSpace), the log file (LogDiskSpace), or temporary file (TempDiskSpace). This system event is not available on the following operating systems:
- Windows 95 before OSR2
- Windows CE
You may want to use disk space events to alert administrators in case of a disk space shortage.
File size The file reaches a specified size. This can be used for the database file (GrowDB), the transaction log (GrowLog), or the temporary file (GrowTemp).
You may want to use file size events to track unusual actions on the database, or monitor bulk operations.
GlobalAutoIncrement When the number of remaining values for a GLOBAL AUTOINCREMENT is less than a percentage of its range, the GlobalAutoIncrement event fires. This can be used to request a new value for the GLOBAL_DATABASE_ID option based on the table and number of remaining values that are supplied as parameters to this event. You can use the event_condition function with RemainingValues as an argument for this event type.
SQL errors When an error is triggered, you can use the RAISERROR event type to take actions.
Idle time The database server has been idle for a specified time (ServerIdle). You may want to use this event type to carry out routine maintenance operations at quiet times.