Add Application Context to Dynamic SQL

Database server administrators can configure the CQEConfig.xml.sample file to log and analyze the dynamic SQL workload generated by IBM® Cognos® software. For Dynamic Query Mode, administrators configure the xqe.config.xml file.

Procedure

  1. In the install_location/configuration directory, make a copy of the CQEConfig.xml.sample file and rename it to CQEConfig.xml.
    Tip: If the CQEConfig.xml file was used for other purposes, for example to disable session caching, it might already exist in the install_location/configuration directory. In this situation, use the existing CQEConfig.xml file to perform the remaining steps.
  2. Open the install_location/configuration/CQEConfig.xml file in an editor.

    Ensure that your editor supports saving files in UTF-8 format.

  3. Locate and uncomment the lines of code that begin with:

    entry name="GenerateCommentInNativeSQL"...

    entry name="GenerateCommentInCognosSQL"...

    entry name="NativeCommentMacro"...

    entry name="CognosCommentMacro"...

  4. If you want, you can modify NativeCommentMacro and CognosCommentMacro by specifying the required parameter values and deleting the parameters that you do not need.

    If you leave a parameter value empty, the parameter will not appear in the generated comment.

  5. Save the CQEConfig.xml file.
  6. Restart the IBM Cognos service.