Analyzing cache usage

You can analyze cache usage by producing a time-stamped XML file showing the state of specified cube caches (number of cache hits and cache misses for different levels of a cube).

This is useful to find out which cubes are in the cache at any point in time. The file includes a list of the data source name, catalog name and cube name for cubes that are currently cached. This can help you decide when to clear the cache.

The report is stored in the c8_location/logs directory. The filename has the format SALDump_prefix_datasource name_category name_cube name_timestamp.xml.

You can also schedule the cache state writing to run automatically. For more information, see Creating and scheduling query service administration tasks.

Procedure

  1. In IBM Cognos Administration, on the Configuration tab, click Query Service Caching.
  2. Select the server groups for cache clearing.
  3. Click Write cache state.

    The status of the Write cache state command is displayed.

  4. Click Close.
Parent topic: Query Service Caching Administration