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
- In the c10_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 c10_location/configuration directory.
In this situation, use the existing CQEConfig.xml file
to perform the remaining steps.
- Open the c10_location/configuration/CQEConfig.xml file
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.
