SYSCS_UTIL.SYSCS_GET_XPLAIN_SCHEMA system function

The SYSCS_UTIL.SYSCS_GET_XPLAIN_SCHEMA function returns the xplain schema for the connection.

The default xplain schema is empty, so if the xplain style hasn't been set, the function returns the empty string. If the xplain schema has been set using SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA, the function returns the xplain schema that was set. If xplain schema is set to a non-empty value, and runtime statistics are being captured, then the runtime statistics will be stored into the SYSXPLAIN_* database tables in that schema for later analysis.

Tuning Java DB contains general information about how to use XPLAIN style and the XPLAIN database tables.

Syntax

SYSCS_UTIL.SYSCS_GET_XPLAIN_SCHEMA () RETURNS VARCHAR

Example

To determine the current value of the XPLAIN schema:

        values syscs_util.syscs_get_xplain_schema();