{"id":3422,"date":"2023-04-12T15:33:06","date_gmt":"2023-04-12T15:33:06","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/more-monitoring-planning-analytics-databases\/"},"modified":"2026-01-16T16:44:01","modified_gmt":"2026-01-16T16:44:01","slug":"more-monitoring-planning-analytics-databases","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/more-monitoring-planning-analytics-databases\/","title":{"rendered":"How Do I Monitor IBM Planning Analytics Databases to Track Performance and Usage?"},"content":{"rendered":"

In an earlier post<\/a>, we mentioned how IBM Planning Analytics Administration includes the ability to monitor and administer your databases, as well as your host environment, from the Planning Analytics Monitoring<\/strong> dashboard <\/strong>(as long as you have administrator access to use the dashboard).<\/p>\n

Note: This particular functionality is available in both local\/on premise installations as well those in the IBM Cloud.<\/p>\n

As a reminder, you access the dashboard by navigating to your Planning Analytics home page, logging in \u00a0and then clicking on Administration<\/strong> and then Databases<\/strong>:<\/p>\n

\"\"<\/p>\n

The Analytics Monitoring<\/strong> dashboard <\/strong>lists the databases available on your \u201csystem\u201d, along with important performance metrics for each database<\/em>. Each database will appear in the dashboard as an individual \u201ctile\u201d. In the below sample we see there are four databases residing on this host:<\/p>\n

\"\"<\/p>\n

You can organize the database tiles by status or database name (by selecting from the drop-down selector next to \u201csort\u201d).<\/p>\n

When you sort by status<\/em>, databases in a critical state appear first, followed by those in a \u201cconcern\u201d state, followed by safe databases, with \u201cstopped\u201d (not available) databases appearing last. Sorting by name shows all databases in alphabetical order regardless of status.<\/p>\n

Notice on each database, there is a Start time<\/strong> or Stop time. <\/strong>This is the most recent database start or stop initiated directly through the <\/em>Planning Analytics Monitoring<\/em> dashboard<\/em>. It is important to note that if a database is started or stopped in any other way (for example through IBM Cognos Configuration) those times are not<\/em> reported.<\/p>\n

You should make a habit of using the dashboard to start, stop and restart your databases. To do this, simply:<\/p>\n