==== Database size ====

=== Purpose ===
This monitor is dedicated to the monitoring of SAP database size.
=== Configuration hints ===

The probe will watch for data and log used space as well as current log mode. For Oracle and DB2 databases, it will also monitor the tablespaces used space. A first surveillance table will be dedicated to the configuration of global database used space monitoring. A second one will be for the tablespaces Use the surveillances table to adjust the monitoring settings: Thresholds, severity, filters, etc... Unused thresholds have to be set to 0.
=== Surveillance table ===

Database size
^Parameter^Description^
^Active|Use this field to activate or deactivate a line of configuration.|
^Max TOTAL used space (%) - DB2 ONLY|The threshold for the used space of the total maximum available. Only available for DB2, it will have no effect on other DB.|
^Max DATA used space (%)|The threshold for the used space of the total available space for DATA.|
^Max LOG used space (%)|The threshold for the used space of the total available space for LOG|
^Expected LOG mode|Define the LOG mode that is expected.|
^Severity|The level of severity of the alarm generated by this line of surveillance.|
^Auto clear|If checked, the alarm will be cleared as soon as the alarm condition is not met anymore.|
^Alarm tag|This field allows to add custom text within the alarm message. %MSG% variable will contain the actual generated message and can be used such as: "my_prefix %MSG% my_suffix". By default, tag will be used as prefix.|
^Alarm|If checked, this line of surveillance will be used for alarm generation.|
^Metric|If checked, this line of surveillance will be used for metric generation.|
^Report|If checked, this line of surveillance will used for showing threshold and severity in the daily report|
=== Examples ===
 
^Active^Max TOTAL used space (%) - DB2 ONLY^Max DATA used space (%)^Max LOG used space (%)^Expected LOG mode^Max used space delta (Mb/%)^Delta time^Severity^Auto clear^Alarm tag^Alarm^
|true|0|80|80|FULL|MAJOR|true| |true|false|false|

**Effect** : Sends a MAJOR alarm if DATA or LOG used space is 80% or more. Sends an alarm if the LOG mode is not FULL.
Tablespaces  
^Parameter^Description^
^Active|Use this field to activate or deactivate a line of configuration.|
^Tablespace|The tablespace name to look for. You can use * to match any tablespace or regular expressions.|
^Max used space (%)|The threshold for the tablespace used space.|
^Severity|The level of severity of the alarm generated by this line of surveillance.|
^Auto clear|If checked, the alarm will be cleared as soon as the alarm condition is not met anymore.|
^Alarm tag|This field allows to add custom text within the alarm message. %MSG% variable will contain the actual generated message and can be used such as: "my_prefix %MSG% my_suffix". By default, tag will be used as prefix.|
^Alarm|If checked, this line of surveillance will be used for alarm generation.|
^Metric|If checked, this line of surveillance will be used for metric generation.|
^Report|If checked, this line of surveillance will used for showing threshold and severity in the daily report.|
=== Examples ===
 
^Active^Tablespace^Max used space (%)^Severity^Auto clear^Alarm tag^Alarm^Metric^Report^
|true|*|80|MAJOR|true| |true|false|false|

**Effect** : Sends a MAJOR alarm if any tablespace uses 80% of space or more.
=== Generated metrics ===
 
^metricId^metricUnit^metricTarget^metricDescription^
|DATABASE_DATA_PERCENTAGE_USED_SPACE|Percent|SID|Sends the usage ratio of DATA|
|DATABASE_LOG_PERCENTAGE_USED_SPACE|Percent|SID|Sends the usage ratio of LOG|
|DATABASE_TOTAL_PERCENTAGE_USED_SPACE|Percent|SID|Sends the ratio of total used space|
|DATABASE_TABLESPACE_PERCENTAGE_USED_SPACE|Percent|TABLESPACE|Sends the usage ratio of a given tablespace|
|DATABASE_TABLESPACE_USED_SPACE|Megabytes|TABLESPACE|Sends the disk usage of a given tablespace|
|DATABASE_TABLESPACE_TOTAL_SPACE|Megabytes|TABLESPACE|Sends the available disk space for a given tablespace|
|DATABASE_LOG_TOTAL_SPACE|Megabytes|SID|Sends the total available disk space for LOG|
|DATABASE_LOG_USED_SPACE|Megabytes|SID|Sends the disk usage for LOG|
|DATABASE_TOTAL_DATA_SPACE|Gigabytes|SID|Sends the total database used space|
|DATABASE_DATA_USED_SPACE|Gigabytes|SID|Sends the database used space of DATA|
|DATABASE_MAX_SPACE|Gigabytes|SID|Sends the max used space of the database|