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 see the Administration tile on the Planning Analytics Workspace home page and to 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).

There are some variations in the capabilities and procedures when monitoring and administering databases on Planning Analytics Administration. For more information, see Manage databases on Planning Analytics as a Service.

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 timeor Stop 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.