You can use the pureQuery Runtime property finalRepositoryProperties to retrieve runtime properties from a file system or a repository in a database. Retrieving properties from a file system or a repository affects the order of precedence.
Before pureQuery Runtime properties retrieves and sets from the location that is specified by the finalRepositoryProperties property, pureQuery client optimization and existing pureQuery Runtime properties are reset to default values. Any property that is set at the data source level is not saved. Properties that are retrieved and set as global pureQuery properties are not affected.
In a WebSphere environment, you set the pureQuery Runtime properties in different locations to control the level of scope of the properties. The location also affects the order of precedence when a property is set in multiple locations.
Specify the pureQuery Runtime properties in a properties file pdq.properties and include the file in the WebSphere JDBC provider CLASSPATH.
When using the pdq.properties file to set global properties, place the file pdq.properties in the JDBC provider CLASSPATH with the pureQuery JAR files. The properties that are set in the JDBC provider CLASSPATH apply to all the applications that use the driver. Properties that apply to a specific application or data source should not be specified here.
Specify the JDBC Driver custom property pdqProperties on the WebSphere data source.
Users can set the pureQuery Runtime properties for each data source. The data source level is appropriate when the setting for each data source needs to be independent from each other. For example, if the application uses multiple distinct data sources, each data source captures the SQL that is targeted for it in its own pureQueryXML file.
When the properties are set on the data source, they are applied to all the applications that are using that data source. So when applications share a data source, the captured SQL statements are captured in a common file for all applications.
Each time changes are made to the value of the properties, the application server needs to be restarted so that the application server can use the new values.
The DSName is the value of the WebSphere DB2® Universal JDBC Driver custom property dataSourceName that is set on the data source.
The pdq.DSName.properties file specifies the data-source-specific properties for an application. The properties specified in this file will be applied only to the specific data source that the application uses. The DSName is the string value of WebSphere custom property dataSourceName for the data source. This custom property is set using steps similar to the steps used to set the WebSphere custom property pdqProperties.
For applications that use the data source name DSName, the properties specified in pdq.DSName.properties have precedence over those specified by pdq.appwide.properties.
If an application uses application-specific properties files, such as pdq.appwide.properties or pdq.dsName.properties files, to make the new properties take affect when properties are changed, you must purge the WebSphere connection pool and restart the application instead of restarting the application server to make new property values to take effect.
You specify a file system or a repository in a database with the pureQuery Runtime property finalRepositoryProperties. The property can be specified in the global level, data source level, or at the application level.
The value for the propertiesGroupId property is ignored unless it is used with a repository created in a database. When a repository is being used, you cannot change the value of the propertiesGroupId property within the redirected properties.
The pureQuery Runtime repositoryRequired property controls the behavior of pureQuery Runtime when using file system or a repository. You specify the property in a WebSphere location pureQuery to control the pureQuery Runtime behavior. The value of the repositoryRequired property can be overridden by setting the repositoryRequired property as one of the retrieved properties.