propertiesRefreshInterval property

Specifies the duration, in minutes, to wait before pureQuery client optimization checks the location of stored pureQuery data for changes to pureQuery properties or pureQueryXML data. When updates have been detected, pureQuery client optimization retrieves the updated pureQuery runtime properties and pureQueryXML data and uses the updated information.

The value of the property can be a positive non-zero integer. A value of 0 disables checking for updates, the default. If this property is not specified, no checking is performed.

pureQuery client optimization checks the location specified by the finalRepositoryProperties property. If the location is a repository, pureQuery client optimization checks the active runtime group version for the runtime group specified by the propertiesGroupId property.

Usage notes

The propertiesRefreshInterval property is ignored when using pureQuery enabled applications with the inline methods or annotated methods.

When all the following conditions are satisfied, the outputPureQueryXml property must be specified and cannot specify the same file as the pureQueryXml property. If the pureQueryXml property is specified:
  • The propertiesRefreshInterval property is specified and captured SQL data are being generated.
  • The finalRepositoryProperties property specifies a path to a directory on a file system.

Existing SQL statements from the application server statement cache are modified when it is safe to do so. Typically, modification can occur at the start of a transaction when the cached statement is in the same state as the state of a newly created statement.

The propertiesRefreshInterval property requires the creation of a timer thread, in some environments a thread cannot be created and this property is ignored. The following environments prohibit timer thread creation:
  • DB2® z/OS® Java Stored procedure
  • CICS®

Checking for updates to pureQuery runtime properties or pureQueryXML data is disabled when the cmx.controllerDiscoveryInterval property is set to -2. Setting the property to -2 disables automatic discovery for Performance Expert Extended Insight.


Feedback