Documentation Index

Fetch the complete documentation index at: https://docs.lobstersoftware.com/llms.txt

Use this file to discover all available pages before exploring further.

System monitoring with profiles

Prev Next

The following components can be used to create profiles for automated system monitoring.

See also Concepts to ensure stable operation in general.

Example profiles

Detecting errors in the reorganization run

The reorganization run (to be found in the CronJobService under the name DW_REORGANIZATIONTHREAD) deletes obsolete log entries daily from the table dw_log (by default at 03:00 am) and writes the system-wide permanent value (see get permanent()) LastReorganizationDuration. Format: <start time in ms since 01.01.1970>-<end time in ms since 01.01.1970>. The lifetime of the permanent value is 36 hours.

NOTE:   In a load-balance system the value is only written on the Node Controller.

This value can be read with the get permanent() function.

NOTE:   This information (in another form) can also be read out on the System monitoring (general) (REST API).

When the reorganization run starts, the start time is set, but the end time will be "0". At the end of the reorganization run, the start time and the end time are set. So you can see if the reorganization run was finished, because if not (still running), the end time value is "0".

You can also see if the reorganization run has run within the last 36 hours, because if not, the system-wide permanent value "LastReorganizationDuration" is empty.

Furthermore, the duration (difference in ms) can be determined when the run is finished and an alarm can be triggered if a defined threshold value is exceeded.

In the following profile you will find an exemplary implementation. The profile must be set to active after importing and the e-mail parameters in the response have to be adjusted.