====== Sybase backups ====== ===== Purpose ===== This monitor will look for the last cumulative, database and transaction dumps and send an alarm if some are too old. It will also detect and report dump errors. ===== Configuration hints ===== **Surveillance table:** * This is a table of rules that you can use to configure and customize the configuration. * Each line of the table will define a rule of monitoring. * You can combine multiple rules to cover different cases. * Within a rule, you can configure a maximum age of a dump from a given type, and if you want to detect dump errors as well. **Dump age threshold:** * Use the multi-threshold syntax to set multiple threshold/severity associations: G2W:20 W2M:40 M2C:60 (Green To Warning, Warning To Major, etc...). * An alarm of the corresponding severity will be sent if the latest dump is older than threshold. * Set 0 in the field if unused **Dump errors:** * This monitor will look for dump errors that happened since the last check. * This check is active when the Backup error severity not DISABLED. In that case, an alarm of the corresponding severity will be sent. * If it is scheduled to run every 15 minutes, then it will look for errors 15 minutes in the past. * It will cope with system restart, up to a 2 hours delay. **Dump type and DB names:** * Each rule can be set for one type of dump only: * CUMULATIVE * DATABASE * TRANSACTION * You can then set a filter on the DB name if you need to set a specific rule for it. **Rules order:** * Rules are processed following their order in the table. * One given dump can only be processed once, it will be ignored by subsequent rules. * Therefore you **MUST** define specific rules (for a give DB) **before** general ones (for all). ===== Surveillance table ===== ^Parameter^Description^ ^Active|If checked, the rule is enabled and will be processed| ^DB name|A filter to match only a specific DB name, can use RegExp, white or black list| ^Type|The type of dump to look for| ^backup max age (min)|The maximum age of the dump in minutes, associated to a severity (G2W:50 W2C:80). Set to 0 if not used.| ^Backup age severity|The default severity used for backup age alarm if multi threshold syntax is not used| ^Backup error sev.|The severity of the alert generated if a backup has an error state. Set to DISABLED if not used.| ^Auto clear|If set, the generated alarms will be automatically cleared from the console if the alarm condition is not fulfilled 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|Defines if the alerting is active for this rule.| ^Metric|Defines if the metric generation is active for this rule.| ^Report|If checked, this rule will be used for showing threshold and severity in the daily report| ===== Examples ===== ^Active^DB name^Type^backup max age (min)^Backup age severity^Backup error sev.^Auto clear^Alarm tag^Alarm^Metric^Report^ |true|*|TRANSACTION|G2W:10 G2M:20|MAJOR|CRITICAL|true| |true|true|true| **Effect** : A WARNING alarm will be sent if the last TRANSACTION dump is older than 10 minutes (MAJOR if older than 20 min). A CRITICAL alert will be sent if a TRANSACTION dump error is detected since the last check. ===== Generated metrics ===== ^metricId^metricUnit^metricTarget^metricDescription^ |DATABASE_BACKUP_AGE|Minutes|[TYPE][DB]|This metrics contains the number of minutes elapsed since the last dump of a given type, for a given DB|