Query behavior

By monitoring and adjusting the behavior of queries in your IBM Cognos Framework Manager project, you can improve the performance of your model.

You can do any of the following steps:

Procedure

  1. Set governors to reduce system resource requirements and improve performance by ensuring that the metadata in a package contains the appropriate limits. For example, you can set limits on the amount of data retrieved or the time that a query can take. For more information, see Governors.
  2. Specify whether aggregate rollups are computed locally or in the database. For relational metadata, you can improve performance by selecting the right type of query processing. After initial report execution, by turning the query reuse feature on, you can create reports without querying the database again. For more information, see Specifying where aggregate rollups are processed.
  3. Improve performance by setting the query processing type to determine whether SQL processing is performed by the database server or processed locally. For more information, see Improving performance by setting the query processing type.
  4. Specify the transaction mode for a query subject with a stored procedure so the query subject can be used in all the studios. For more information, see Specify transaction modes.
  5. Improve performance by reusing cached data when running a report. By reusing cached data, you can create a report without querying the database again. For more information, see Improving performance by reusing cached data when running a report.
  6. Select the vendor-specific function sets for the data sources that are defined in the project. For more information, see Selecting function sets.
  7. Indicate the behavior of individual functions that are based on the data sources in the project. For more information, see Quality of service.
  8. Control and optimize how queries are run by modifying the properties of a data source that was created using the Metadata Wizard in IBM Cognos Framework Manager. For more information, see Controlling and optimizing queries.