The WLM_GET_CONN_ENV table function returns for a particular connection the values of settings that control collection of activity data and section actuals.
You can use this table function to check the current values of the settings applied by the WLM_SET_CONN_ENV stored procedure.
None
Column name | Data type | Description |
---|---|---|
APPLICATION_HANDLE | BIGINT | application_handle - Application handle |
DETAILS | BLOB(8M) | XML document that contains connection environment details. See Table 2 for a description of the elements in this document. |
Element name | Data type | Description or corresponding monitor element |
---|---|---|
collectactdata | xs:string(255) | Specifies what kind of activity data is being
collected, if any. Possible values are:
See information about the WLM_SET_CONN_ENV procedure for details about these options. |
collectactpartition | xs:string(255) | Specifies where activity data is being collected.
Possible values are:
See information about the WLM_SET_CONN_ENV procedure for details about these options. |
collectsectionactuals | xs:string(255) | Specifies whether section actuals are being
collected. Possible values include:
See information about the WLM_SET_CONN_ENV procedure for details about these options. |
The WLM_GET_CONN_ENV table function provides maximum flexibility for formatting output because it returns WLM environment information for a connection as an XML document. The output can be parsed directly by an XML parser, or it can be converted to relational format by the XMLTABLE function.
The schema for the XML document that is returned in the DETAILS column is available in the file sqllib/misc/DB2MonRoutines.xsd. Further details can be found in the file sqllib/misc/DB2MonCommon.xsd.
SELECT application_handle,
xmlparse(document details preserve whitespace)
FROM TABLE (
WLM_GET_CONN_ENV(
cast(NULL as bigint))
) connenv
APPLICATION_HANDLE DETAILS
-------------------- ------------------------------------------------------
7 <wlm_conn_env
xmlns=http://www.ibm.com/xmlns/prod/db2/mon
release="9070100">
<collectactdata>NONE</collectactdata>
<collectactpartition>COORDINATOR</collectactpartition>
<collectsectionactuals>NONE</collectsectionactuals>
</wlm_conn_env>