Set database thresholds and alerts

You can configure settings that define database status by multiple metrics. You can also configure alerts to send notification to yourself and other users when any of the metrics reaches a critical state.

About this task

When you set threshold limits, you define the parameters for the safe, concern, and critical states of these metrics for an individual database:

  • Memory usage
  • CPU usage
  • Maximum thread wait time
  • Duration of thread in run state
  • Database unresponsive

Set database thresholds and alerts in Planning Analytics Workspace

Procedure

  1. Click the Administration tile on the Planning Analytics Workspace Home page.
  2. Click Databases.
  3. On the Databases tab, click the database for which you want to set thresholds and alerts.
  4. Click Alerts.
    Alerts tab
  5. For the following database metrics, set the Warning threshold and Critical threshold.

    When the metric value falls below the Warning threshold, the database is in a healthy state. When the metric is at or above the Warning threshold, but below the Critical threshold, the database is in a concern state. When the metric is at or above the Critical threshold, the database is in a critical state.

    Memory usage
    Measures database memory usage in GBs.
    CPU usage
    Measures database CPU usage as a percentage of total CPU capacity on the system.
  6. For the following database metrics, set the Critical threshold.

    When the metric value is at or above the Critical threshold, the database is in a critical state. Otherwise, the database is in a safe state.

    Max thread wait time
    Measures the amount of time a threads waits to run, expressed in seconds
    Thread in run state
    Measures the duration of a thread in a run state, expressed in minutes
    Database unresponsive
    Measures the duration of a database in an unresponsive state, expressed in seconds.
  7. If you want to be alerted by email when a database metric reaches a critical state or when the database is shut down:
    1. Select the Alert at critical condition option for the metric or for database shutdown.
    2. Enter the email addresses of the users to receive notification in the Notify email ID(s) box. When typing, you can separate addresses with a comma, space, tab, or enter. You can also paste a comma-delimited list of email addresses in this box.

      For Planning Analytics Administration on Cloud, notification emails are sent from administration@planning-analytics.ibmcloud.com.

      Local onlyFor Planning Analytics Administration Local, notification emails are sent from the mail address specified by the PAA_EMAIL_ADDRESS property in the bootstrap.properties file for a given agent. The default value for this property is administration@planning-analytics.ibmcloud.com, but you can modify it to use an email address that is more relevant for your environment. See Install and configure the Planning Analytics Administration agent (local only) for details on the bootstrap.properties file.

    3. Click Apply.
  8. You can click Restore to original values at any time to restore the default threshold and alert settings. Note that Restore also removes any email addresses from the Notify email ID(s) box.

Set database thresholds and alerts in Planning Analytics Workspace Classic

Procedure

  1. Click Configuration icon on the database thread report.
  2. Click Thresholds and alerts.
  3. For the following database metrics, set the Warning threshold and Critical threshold.

    When the metric value falls below the Warning threshold, the database is in a safe state. When the metric is at or above the Warning threshold, but below the Critical threshold, the database is in a warning state. When the metric is at or above the Critical threshold, the database is in a critical state. The database state is reflected in the color bar on each database tile on the Databases page.

    Memory usage
    Measures database memory usage in GBs.
    CPU usage
    Measures database CPU usage as a percentage of total CPU capacity on the system.
  4. For the following database metrics, set the Critical threshold.

    When the metric value is at or above the Critical threshold, the database is in a critical state. Otherwise, the database is in a safe state.

    Max thread wait time
    Measures the amount of time a threads waits to run, expressed in seconds
    Thread in run state
    Measures the duration of a thread in a run state, expressed in minutes
    Database unresponsive
    Measures the duration of a database in an unresponsive state, expressed in seconds.
  5. If you want to be alerted by email when a database metric reaches a critical state or when the database is shut down:
    1. Select the Alert at critical condition option for the metric or for database shutdown.
    2. Enter the email addresses of the users to receive notification in the Notify email ID(s) box. When typing, you can separate addresses with a comma, space, tab, or enter. You can also paste a comma-delimited list of email addresses in this box.

      For Planning Analytics Administration on Cloud, notification emails are sent from administration@planning-analytics.ibmcloud.com.

      Local onlyFor Planning Analytics Administration Local, notification emails are sent from the mail address specified by the PAA_EMAIL_ADDRESS property in the bootstrap.properties file for a given agent. The default value for this property is administration@planning-analytics.ibmcloud.com, but you can modify it to use an email address that is more relevant for your environment. See Install and configure the Planning Analytics Administration agent (local only) for details on the bootstrap.properties file.

    3. Click Apply.
  6. You can click Restore at any time to restore the default threshold and alert settings. Note that Restore also removes any email addresses from the Notify email ID(s) box.