This monitor is dedicated to the monitoring of SAP 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 |
| 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.
| 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. |
| 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.
| 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 |