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 VECTORWISE( 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 VECTORWISE(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.