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

Note: If you're using TM1 Database 12, you can set alerts and thresholds for Memory usage and CPU usage metrics only.

Set database thresholds and alerts in Planning Analytics Workspace

Procedure

Click the Administration tile on the Planning Analytics Workspace Home page.
Click Databases.
On the Databases tab, click the database for which you want to set thresholds and alerts.
Click Alerts.
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.
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.
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.
  
  For 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.
You can click Restore to original values at any time to restore the default threshold and alert settings. Restore also removes any email addresses from the Notify email ID(s) box.