SETCONF Command
The SETCONF command dynamically modifies the setting of the specified configuration parameter to the specified value. The setting remains in effect for the duration of the session.
This command has the following format:
CALL X100( SETCONF 'parameter_section, parameter_name, ''parameter_value''[, GLOBAL]')
When specifying a parameter_value, ensure that it is enclosed in two single quotation marks (for example: ''value'') rather than double quotation marks ("value").
When the GLOBAL parameter is used, the setting remains in effect until server shutdown; when omitted, the setting remains in effect for the duration of the session.
For example, the following command enables profiling for all the queries that will be executed in the current session:
CALL X100(SETCONF 'server, profiling, ''true''')
Note: For some parameters, the modified setting will not be effective. For example, dynamically modifying the value of the [system] max_initial_log_size parameter will not change the actual log condensation trigger.
Note: Previously, it was not possible to modify the [memory] max_memory_size and [cbm] bufferpool_size parameters at runtime. These parameters can now be changed dynamically, which invokes the associated trigger.
Last modified date: 01/27/2026