IBM Support

Query Service and Dynamic Cubes become unavailable

Troubleshooting


Problem

Query Service and Dynamic Cubes become unavailable some time after a restart of Query service

Symptom

JVM heapsize  limit for Query service is set to a high value (300 GB in this case)

Resolving The Problem

  1. Set both 'Initial JVM nursery size' and 'JVM nursery size limit' to 1/2 of the value of 'JVM heap size limit for the query service
  2. Set 'JVM garbage collection policy' to Balanced

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 October 2018

UID

ibm10733651