propertiesGroupId property

Specifies a runtime group ID in a repository that is created in a database. pureQuery Runtime uses the runtime group ID and the connection information that specifies the repository to retrieve pureQuery runtime configuration and pureQueryXML file information. Java applications enabled with pureQuery client optimization can also store SQL data captured the specified location.

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.

DB2 CLI and IBM Data Server Driver usage notes

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.

IBM CLI keyword syntax: propertiesGroupId = 'GroupID'
IBM Data Server Driver configuration syntax: <parameter name="propertiesGroupId" value="GroupID" />
Equivalent IBM Data Server Provider for .NET connection string keyword: propertiesGroupId=GroupID

CLI and .NET usage notes

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.

Feedback