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