Overview of Database Events (SAP Library

Overview of Database Events

Use

The following types of events exist:

· Events that are always active and cannot be changed

· Events that you can activate/deactivate and change

Every event belongs to an event category.

Events that Are Always Active (Cannot Be Changed or Deactivated)

Event Category	PRIORITY	VALUE1	VALUE2	TEXT	Description
ADMIN	LOW	Internal value	Internal value	-	The database instance was transferred to the ADMIN operational state.
AUTOSAVE	LOW	0: started 1: stopped 2: on 3: off	Internal value	If an automatic log backup has started, the file name of the backup medium is displayed as the TEXT.	Information about the automatic log backup
BACKUPRESULT	LOW	Internal value	Internal value	Return value	Information about a backup
CHECKDATA	LOW	Internal value	Internal value	Return value	Result of the CHECK DATA command
DATABASEFULL	LOW	Internal value	Internal value	-	The data area of the database instance is completely full. A data volume must be added to continue operation. Note that this event is not triggered in the OFFLINE or ADMIN operational states.
ERROR	HIGH	Return value	Internal value	Error text	The database system has entered an error in the knldiag kernel log.
EVENT	LOW	Internal value	Internal value	-	The event configuration has been changed.
LOGFULL	LOW	Internal value	Internal value	-	The log area of the database instance is completely full. A log volume must be added to continue operation.
LOGSEGMENTFULL	LOW	Internal value	Internal value	-	The database system has completely filled a log segment. The log segment can now be backed up.
ONLINE	LOW	Internal value	Internal value	-	The database instance has been transferred to the ONLINE operational state.
OUTOFSESSIONS	MEDIUM	Internal value	Internal value	Out of Sessions	All available user tasks are in use; no further users can log on to the database instance.
SYSTEMERROR	HIGH	Internal value	Internal value	Return value	A grave system error has occurred (message numbers -9000 to -9999).
UPDSTATWANTED	LOW	Internal value	Internal value	UPDATE STATISTICS WANTED	The SQL Optimizer statistics for at least one table must be updated.

Events that Can Be Activated/Deactivated and Changed

Event Category	PRIORITY	Value Range	VALUE1	VALUE2	TEXT	Description
DBFILLINGABOVELIMIT	HIGH \| MEDIUM \| LOW	0 < n < 100	Number of pages in the data area	Percent	-	The defined database fill level (in percent) has been exceeded. The system displays a corresponding message.
DBFILLINGBELOWLIMIT	HIGH \| MEDIUM \| LOW	0 < n < 100	Number of pages in the data area	Percent	-	The defined database fill level (in percent) has not been reached.
LOGABOVELIMIT	HIGH \| MEDIUM \| LOW	0 < n < 100	Number of pages in the log area	Percent	-	The defined log fill level (in percent) has been exceeded.

Activities

Database Manager CLI,

· Structure link Displaying the List of Events and Their Statuses

· Structure link Displaying the List of Event Categories

See also:

Automating Administration Tasks

Database Manager CLI, Structure link Using Events of the Database Instance

Structure link Event Dispatcher documentation