The value of the property is the runtime group ID defined in a repository. There is no default value. This property is supported for both pureQuery-enabled Java™ applications and CLI applications enabled with pureQuery client optimization.
A pureQuery-enabled Java application uses the pureQuery runtime properties and pureQueryXML file data retrieved from the active runtime group version from the runtime group specified by the propertiesGroupId property in the repository specified by the finalRepositoryProperties property.
Java applications can use the propertiesGroupId property only with the finalRepositoryProperties property. The pureQuery Runtime uses the repository that is created in a database specified by the finalRepositoryProperties property to retrieve pureQuery runtime properties and pureQueryXML data from a repository.
A Java application enabled with pureQuery client optimization stores captured SQL data in the runtime group specified by the propertiesGroupId property. pureQuery client optimization captures SQL when the captureMode property is set to ON. By default, the captured SQL is stored in the repository specified by the finalRepositoryProperties property. You can store captured SQL in a different repository by specifying the outputXmlRepository property.
For both Java and CLI applications, when accessing pureQuery configuration and pureQueryXML file information in a repository, pureQuery Runtime can accessing the data only from an active runtime group version. You can active a runtime group version using the ManageRepository utility or the workbench.
When using DB2® Call Level Interface (CLI) or the IBM® Data Server Driver with pureQuery Runtime, you can use the pureQuery Runtime property as a configuration keyword.
For CLI or .NET applications enabled with pureQuery client optimization retrieving pureQueryXML file data from a repository created in a database is supported. The retrieval of pureQuery runtime configuration file information is not supported.
You must specify both the pureQueryXmlRepository and propertiesGroupId keywords to retrieve pureQueryXML file data from a repository.
The propertiesGroupId and pureQueryXmlRepository keywords cannot be used when the value of the Capturemode keyword is set to ON.