SQL Operations Guide

fc_set_sysconfig()

Dynamically enables a limited set of system configuration options as defined by the SetSystemConfigurationOption() API call.

Parameters (2)

option VARCHAR(64)

value VARCHAR(64)

option is one of the following:

'checkpoint_monitor'

'ctstatus_mask'

'diagnostics'

'dynamic_dump_defer'

'function_monitor'

'memory_monitor'

'request_time_monitor'

'vss_writer'

Examples

fc_set_sysconfig('vss_writer', 'YES');

fc_set_sysconfig('diagnostics', 'LOWL_FILE_IO');

fc_set_sysconfig('diagnostics', 'REPLICATE');

fc_set_sysconfig('ctstatus_mast', '~DYNAMIC_DUMP_FILES');

Requires DBA privilege.