Clear everything in the cache

To avoid using outdated data that might be stored in the cache, you can clear the cache.

You might want to clear the cache manually if your data source metadata changes infrequently or if you want to clear the cache in between automatically scheduled cache clearing. When you clear the cache using the following steps, it clears everything in the cache.

If you want to clear the cache for a specific data source, catalog, or cube, create a query service administration task. You might also want to create a query service administration task if your data source metadata changes regularly. For example, you might want to set a schedule to clear the cache hourly, daily, or weekly. 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 Clear cache.

    The status of the Clear cache command is displayed.

    If a cache is being used by one or more pending reports or queries, it is internally flagged as "stale" by this command and is automatically cleared as soon as this usage completes.

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