The following rules apply for storing captured SQL when the captureMode property is set to ON and the finalRepositoryProperties property specifies a repository:
If the outputPureQueryXml property is not set, the following property setting determines where captured SQL is stored:
- If the outputXmlRepository property is not set, then the captured SQL is stored in the repository and the runtime group that are specified by the finalRepositoryProperties and propertiesGroupId properties.
- If the outputXmlRepository property is set, then the captured SQL is stored in the repository in the runtime group that are specified by the finalRepositoryProperties and propertiesGroupId properties.
It seems to me there is some kind of mistake here, since both possibilities looke the same, and I guess they should'nt. I'm interested on selectively enabling the SQL capture in the production environment, so the posibility of using a DB2-based repository to handle the captured data is important.