In Report Studio, Query Studio, and Cognos Viewer the results for previous requests to the database are cached for the duration of a session when session caching is enabled. To increase performance, for subsequent queries, IBM Cognos 8 uses cached results for some actions rather than accessing the database. This applies when the same results can be used or when the new results are a subset of the cached results. You can enable session caching at the server level or at the package or report level.
Because performance may be affected, you may want to leave session caching disabled at the server level in the following situations:
users expect up-to-date results directly from the database for every query, for example new records that were added to the database in the interim
you want to limit the number of times the cache is accessed during a session
You may also want to leave session caching disabled for individual reports because of high resource consumption, for example, reports that use bursting.
You can also enable and disable session caching for specific queries in reports in Report Studio (see the Report Studio Professional Authoring User Guide) and for models in Framework Manager (see the Framework Manager User Guide).
Session caching for new models and reports is enabled by default. Existing packages and reports retain existing session caching settings.
Copy the c8_location/configuration/CQEConfig.xml.sample file to c8_location/bin and rename it CQEConfig.xml.
Open the c8_location/bin/CQEConfig.xml in an editor.
Ensure that your editor supports saving files in UTF-8 format.
Find the queryReuse parameter and change the value to 0.
Save the CQEConfig.xml file.
Using IBM Cognos Configuration, stop and then restart IBM Cognos 8.
For information about stopping IBM Cognos 8, see the Installation and Configuration Guide.
Copy the c8_location/configuration/CQEConfig.xml.sample file to c8_location/bin and rename it CQEConfig.xml.
Open the c8_location/bin/CQEConfig.xml in an editor.
Ensure that your editor supports saving files in UTF-8 format.
Find the queryReuse parameter and remove it.
Save the CQEConfig.xml file.
Using IBM Cognos Configuration, stop and then restart IBM Cognos 8.
For information about stopping IBM Cognos 8, see the Installation and Configuration Guide.
For information on disabling session caching at the package level, see the Framework Manager User Guide. For information on disabling session caching at the report level, see the Report Studio Professional Authoring User Guide.