IBM Support

Understanding Planning Analytics as a Service Database Memory Usage

Troubleshooting


Problem

The purpose of this document is to highlight the tools available to help with understanding the memory usage of a Planning Analytics as a Service database

Cause

Common Causes for High Memory Usage:
  • Cube data has increased (regular usage, or erroneous spreading on a consolidation)
  • Model design / overfeeding in cube rules (feeding more cells than required)
  • Large user queries
Additional Considerations:
  • Memory will increase and can be held for the remainder of a user's session
    • Log out of the application when done, don't rely only on idle timeout
    • Ensure any cellsets created by API are deleted and sessions properly closed
  • Memory is also required to perform backups
    • Be mindful of automatic backup schedule

       

Diagnosing The Problem

Database Memory Alerts
  • Utilize database alerts to be notified when memory exceeds a specified threshold
  • Navigate to Planning Analytics Workspace > Administration > Databases
  • Select the database name, and click the Alerts tab
  • Configure an appropriate Warning and Critical threshold
  • Enable the alert and specify your email address
    image-20250515092109-4




Database Detail Page
  • Navigate to Planning Analytics Workspace > Administration > Databases
  • Select the database name, and review the Details tab
  • Memory usage for all Replicas is displayed
    image-20250515090512-1

Database Server Logs
  • Navigate to Planning Analytics Workspace > Workbench
  • Right-click the database name, select Logs > Server log
    image-20250515090820-2
  • Review the server log for the TM1.Server.Memory logger lines
    image-20250515091558-3
  • Ideal for historical usage and mapping to potential actions

Database Object Size Understanding
  • At this time, the ability to understand object usage in memory is not available
  • A backupset of the Planning Analytics Database can be used to identify large objects, in general
    • However this does not tell us how large the object is in memory
  • Navigate to Planning Analytics Workspace > Administration > Databases
  • Click the Backup tab and download the latest backup
    image-20250515100627-5
  • Extract the downloaded backupset archive file, sort by size and review the contents
    image-20250515100933-6

     

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEAI8G","label":"Planning Analytics as a Service"},"ARM Category":[{"code":"a8m3p000000GoaGAAS","label":"Planning Analytics-\u003EPlanning Analytics as a Service Specific"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":""}]

Document Information

Modified date:
15 May 2025

UID

ibm17233607

Page Feedback