SQL Reference Guide > SQL Reference Guide > SQL Statements > CALL X100 (X100 Only) > SETCONF Command
Was this helpful?
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 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 [cbm] bufferpool_size parameter will not change the actual bufferpool size.
Last modified date: 01/30/2023