products:promonitor:6.8:monitorsguide:sybase:sybasebackups

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

ParameterDescription
ActiveIf checked, the rule is enabled and will be processed
DB nameA filter to match only a specific DB name, can use RegExp, white or black list
TypeThe 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 severityThe 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 clearIf set, the generated alarms will be automatically cleared from the console if the alarm condition is not fulfilled anymore
Alarm tagThis 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.
AlarmDefines if the alerting is active for this rule.
MetricDefines if the metric generation is active for this rule.
ReportIf checked, this rule will be used for showing threshold and severity in the daily report

Examples

ActiveDB nameTypebackup max age (min)Backup age severityBackup error sev.Auto clearAlarm tagAlarmMetricReport
true*TRANSACTIONG2W:10 G2M:20MAJORCRITICALtrue truetruetrue

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

metricIdmetricUnitmetricTargetmetricDescription
DATABASE_BACKUP_AGEMinutes[TYPE][DB]This metrics contains the number of minutes elapsed since the last dump of a given type, for a given DB
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.8/monitorsguide/sybase/sybasebackups.txt · Last modified: 2024/05/01 18:35 (external edit)