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
- Copy the c10_location/configuration/CQEConfig.xml.sample
file to c10_location/bin and rename it CQEConfig.xml.
Note: If the CQEConfig.xml was used for other purposes,
for example to disable session caching, it may already exist in the
c10_location/bin
directory. For more information, see
Session Caching. In
this situation, use the existing CQEConfig.xml file to perform the
remaining steps.
- Open the c10_location/bin/CQEConfig.xml in an editor.
Ensure that your editor supports saving files in UTF-8 format.
- Locate and uncomment the lines of code that begin with:
entry name="GenerateCommentInNativeSQL"...
entry
name="GenerateCommentInCognosSQL"...
entry
name="NativeCommentMacro"...
entry name="CognosCommentMacro"...
- 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.
- Save the CQEConfig.xml file.
- Restart the IBM Cognos service.
