event_set 
Use
You specify that the database system is to trigger an event as soon as a defined situation occurs. You can execute this DBM command in any operating state of the database instance and the event is active immediately.
For an overview of
events that can be activated or deactivated, see Concepts of the Database
System, 
Overview of Database
Event Categories
Using the Event Dispatcher, you can handle the events triggered by the database system and thus, for example, automate periodic administration tasks. To do this, you create an event definition in Event Dispatcher in which you specify that the triggered event is to be handled by the database system and how this is to be done.
See also:
Using Events of the Database Instance
Database Administration Tutorial, Saving the Log
Automatically After the Event LOGABOVELIMIT
Utilities, Event Dispatcher
Prerequisites
You have the DBInfoRead server authorization.
Syntax
event_set <event_category> <priority> <value>
<priority> :: = LOW | MEDIUM | HIGH
Options
Option |
Description |
<event_category> |
Event category possible values are: DBFILLINGABOVELIMIT | DBFILLINGBELOWLIMIT | LOGABOVELIMIT
DBFILLINGABOVELIMIT: The system sends this event when the fill level of the data area exceeds the predefined value. Default system values are events with fill levels 90%, 95%, 96%, 97%, 98%, 99% (HIGH priority), fill levels 80%, 85% (MEDIUM priority) and fill level 70% (LOW priority) DBFILLINGBELOWLIMIT: The system sends this event when the fill level of the data area goes below the predefined value. Default system values are events with fill levels 70%, 80%, 85%, 90%, 95% (LOW priority) LOGABOVELIMIT: The system triggers event of this category when the fill level of the data area exceeds the predefined values. Default system values are events with fill levels 96%, 97%, 99%, 99% (HIGH priority), with fill levels 90%, 95% (MEDIUM priority) and fill levels 50%, 75% (LOW priority) |
<priority> |
Priority of an event Possible values: LOW | MEDIUM | HIGH With events that belong to a category that is changeable, you can override the default values in the database system. |
<value> |
Numerical value the meaning of which depends on the event DBFILLINGABOVELIMIT: Each time a fill level is exceeded by between 0% and 99%, you can define a separate event with a certain priority (value range 0 ≤ n ≤ 99). DBFILLINGBELOWLIMIT: Each time a fill level is fallen short of by between 1% and 100%, you can define a separate event with a certain priority (value range 1 ≤ n ≤ 100). LOGABOVELIMIT Each time a fill level is exceeded by between 0% and 100%, you can define a separate event with its own priority (value range 0 ≤ n ≤ 100). |
Reply
OK
In the event of errors, see Reply Format.
Example
Call the Database Manager CLI, log on as operator OLEG with password MONDAY, connect to the database instance DEMODB, activate the event DBFILLINGABOVELIMIT with priority LOW and value 50:
>dbmcli -u OLEG,MONDAY -d DEMODB event_set DBFILLINGABOVELIMIT LOW 50
OK