Required settings for capturing SQL statements for the first time when your goal is to run them dynamically

When you capture SQL statements for the first time from an application, you must set the following properties with these values.
Table 1. Required settings for capturing SQL statements
Property Setting Effect
captureMode ON Causes pureQuery to capture statements when you run those statements in an application.
For a non-clustered application:
pureQueryXml or outputPureQueryXml
  Causes pureQuery to capture statements, and information related to those statements, in the file that you specify. There is no default value for these properties. You must use one of these properties or the other.
For a clustered application:
outputPureQueryXml
  Causes pureQuery to capture statements, and information related to those statements, from each application instance in the cluster to files specific to each instance. pureQuery generates the names of the files because of the $X, which pureQuery replaces with the ID of the class loader for the instance and with a timestamp. The file-name prefix is optional.

Use the Merge utility to merge these files together.

This table does not show properties that you can leave at their default values or other properties that you might want to use.

Here is a complete list of the properties that you can use when capturing SQL statements:

You can also set logging properties. See Descriptions of properties for logging and tracing.

See How to set properties for capturing and running restricted sets of SQL statements dynamically for information about how and where to set these properties.


Feedback