Monitor and administer databases

IBM® Planning Analytics Administration includes the ability to monitor and administer your databases from the Administration page. You must be an administrator to access and use the Administration page.

Note: Local only To use Planning Analytics Administration on Planning Analytics Workspace Local, you must install and configure the Planning Analytics Administration agent wherever you have installed the Planning Analytics database. For more information, see Install and configure the Planning Analytics Administration agent (local only).

To open the Administration page, click the Administration tile on the Home page.

Monitor and administer databases in Planning Analytics Workspace

The Databases tile on the Administration page shows the total number of databases in your environment, along with a status summary for all databases.

Databases tile

Databases are identified as being in one of these four states:

  • Stopped icon Stopped - The database is nor running.
  • Critical icon Critical - When any single database resource reaches the critical threshold, the entire database is in a critical state.
  • Warning icon Concern - When any single database resource reaches the warning threshold, and there are no resources have reached the critical threshold, the entire database is in a warning state.
  • Healthy icon Healthy - When all database resources are below the critical and warning thresholds, the entire database is in a healthy state.

Click the Databases tile to open the Databases page. This page shows a list of all the databases in your environment. For each database, you can see if it is running or stopped, the database name, and the database health.

Stopped databases are identified by the Stopped databasa icon icon, while running databases are identified by the Stopped database icon icon.

You can sort databases by running/stopped status, name, or health.

You can click any database name on the Databases list to view details for the database. The Start time reported for the database reflects the most recent database start or stop initiated directly through the Planning Analytics Workspace Administration page. If a database is started or stopped in any other way, such as through IBM Cognos Configuration or an API call, those times are not reported.

Database page

In Planning Analytics Workspace Local, the Details page also indicates the agent on which the database is running.

Monitor and administer databases in Planning Analytics Workspace Classic

On the Administration page. click Databases to see the dashboard.

Planning Analytics Monitoring dashboard

The dashboard shows the databases that are available on your system, along with performance metrics. Each database appears as an individual tile on the dashboard.

The Start time and Stop time reported for each database reflects the most recent database start or stop initiated directly through the Planning Analytics Monitoring dashboard. If a database is started or stopped in any other way, such as through IBM Cognos Configuration or an API call, those times are not reported.

For each database, you can view a combination of performance metrics. These metrics help you determine the efficiency and status of your databases. You can define the Safe, Concern, and Critical thresholds for all performance metrics. A quick glance at the dashboard gives you a visual indication of the health of your databases.

  • When any metric meets or exceeds the Critical threshold value, the metric is identified with a red x icon Critical icon. If any single metric is critical, the entire TM1® database is considered to be in a critical state, as indicated by a red bar at the top of the database tile.
  • When any metric falls within the Concern threshold range, the metric is identified with a yellow ! icon Concern icon. If there are no metrics in a critical state, but at least one metric is in a concern state, the entire TM1 database is considered to be in a state of concern, as indicated by a yellow bar at the top of the database tile.
  • When any metric is at or below the Safe threshold value, the metric is identified with a green check mark icon Safe icon. When all metrics are safe, the entire TM1 database is considered to be in a safe state, as indicated by a green bar at the top of the database tile.
  • Any database that is stopped appears with a gray bar at the top of the database tile.
  • For each database that is running, the most recent start time is displayed. For each stopped database, the most recent stop time is displayed.

You can sort databases by status or name. When you sort by status, databases in a critical state appear first, followed by those in a concern state, followed by safe databases, with stopped databases appearing last. Sorting by name shows all databases in alphabetical order regardless of status.

You can click the database name on the tile of any running database to view a detailed report of the current database state.

In addition to showing the status for individual databases, the dashboard also shows the status of the total system resources on the computer where the databases are running. Memory, CPU, and Disk usage are displayed, showing the percentage of available resources currently used on the system. Each metric is accompanied by a color-coded square, indicating if resource usage is at the safe, concern, or critical level.

As with individual databases, you can define the Safe, Concern, and Critical thresholds for the system resources. When a system resource is in a safe state, the square for the resource is green. When in a concern state, the square is yellow. When in a critical state, the square is red.

Local onlyFor Planning Analytics Administration on Planning Analytics Workspace Local, databases are grouped by agent IP address. Click the arrow next to the agent address to reveal or hide the databases for that agent and to view the system resource status.

Database tiles grouped by agent IP address