The WLM_SET_CONN_ENV procedure enables for a particular connection the collection of activity data and measurement of section actuals (runtime statistics measured during section execution).
Once applied, the settings made by the WLM_SET_CONN_ENV procedure continue to apply until explicitly overwritten by another call to the WLM_SET_CONN_ENV procedure, or until the connection is closed. After the connection is closed, any new connection that reuses the same application handle does not inherit the settings of the previous connection to use that application handle.
The schema is SYSPROC.
EXECUTE privilege on the WLM_SET_CONN_ENV procedure.
<setting name tag>value</setting name tag>
Each setting can be specified a maximum of one time. Setting names are case sensitive. A change to a setting takes effect on the next statement executed; it has no effect on statements already in progress.
Value | Description |
---|---|
NONE | Activity data should not be collected |
WITHOUT DETAILS | Data about each activity is sent to any active activities event monitor when the activity completes execution. Details about statement, compilation environment, and section environment data are not sent. |
WITH DETAILS | Statement and compilation environment data is sent to any active activities event monitor, for those activities that have them. Section environment data is not sent. |
WITH DETAILS, SECTION | Statement, compilation environment, section environment data, and section actuals are sent to any active activities event monitor, for those activities that have them. For section actuals to be collected, either collectsectionactuals must be set to BASE or the section_actuals database configuration parameter must be set to BASE. Section actuals are collected on any partition where the activity data is collected. |
WITH DETAILS, SECTION AND VALUES | Statement, compilation environment, section environment data, section actuals, and input data values are sent to any active activities event monitor, for those activities that have them. For section actuals to be collected, either collectsectionactuals must be set to BASE or the section_actuals database configuration parameter must be set to BASE. Section actuals are collected on any partition where the activity data is collected. |
WITH DETAILS AND VALUES | Statement, compilation environment, and input data values are sent to any active activities event monitor, for those activities that have them. Section environment data is not sent. |
Specifies where activity data is collected, either just at the coordinator partition or at all partitions. If collectactpartition is not specified, the connection maintains its previous value for collectactpartition which by default is COORDINATOR.
Section actuals are collected if collectsectionactuals is set to BASE.
CALL WLM_SET_CONN_ENV(NULL,'<collectactdata>WITHOUT DETAILS</collectactdata>')
CALL WLM_SET_CONN_ENV(NULL,'<collectactdata>WITHOUT
DETAILS</collectactdata><collectactpartition>COORDINATOR
</collectactpartition>')
CALL WLM_SET_CONN_ENV(NULL, '<collectactdata>WITH DETAILS, SECTION
</collectactdata><collectactpartition>ALL</collectactpartition>')
CALL WLM_SET_CONN_ENV(NULL, '<collectactdata>NONE</collectactdata>')
If a setting is not specified in the input of the WLM_SET_CONN_ENV procedure, it is not altered in the connection environment.
The effective setting for the collection of section actuals is the combination of the collectsectionactuals setting and the section_actuals database configuration parameter. For example, if collectsectionactuals is set to BASE and the section_actuals database configuration parameter value is NONE, the effective setting for the collection of section actuals is BASE (and vice versa). Do not use automatic statistics profiling (enabled using the auto_stats_prof database configuration parameter) if collectsectionactuals is set to BASE (otherwise, the warning SQLSTATE 01HN2 is returned).
Automatic client rerouting cannot be performed for a connection when activity data and section actuals are being collected (when collectactdata is set to any value other than NONE).