>>-SET--parameter_name--value--+---------------------------+--->< +-COSERVER--+-csvr_name---+-+ | '-csvr_number-' | +-PERSISTENT----------------+ '-PROPAGATE-----------------'
Element | Purpose | Restrictions | Syntax |
---|---|---|---|
parameter_name | The configuration parameter to be altered | Must be a configuration parameter that can be altered dynamically. | |
value | The new value of the configuration parameter | Must be a valid value for the configuration parameter. |
By default, configuration changes made using the onutil SET command are global and temporary. They apply to all coservers and are lost when the instance is shut down. You can use the COSERVER clause to apply configuration changes to a specific coserver.
Using the PERSISTENT keyword causes the new value to be recorded in the configuration file. When a parameter is made persistent, the online configuration file is rewritten only on coserver 1. If multiple copies of the configuration are used across nodes, add the PROPAGATE keyword, which will cause each coserver to rewrite its config file with the new parameter value.
Use the onstat -g cfg command to display the current values of all dynamically modifiable configuration parameters on a particular coserver.
Following is a list of configuration parameters that can be altered using the onutil SET command. For more information on these parameters see Configuration Parameters.
ALARMPROGRAM |
BLOCKTIMEOUT |
CKPTINTVL |
DATASKIP |
DBS_USED_THRESHOLD |
DBSPACETEMP |
DEADLOCK_TIMEOUT |
DS_ADM_POLICY |
DS_MAX_QUERIES |
DS_TOTAL_MEMORY |
DS_TOTAL_TMPSPACE |
DUMPCNT |
DUMPCORE |
DUMPDIR |
DUMPGCORE |
DUMPSHMEM |
DYNAMIC_LOGS |
FILLFACTOR |
FRAGS_PER_DBS |
IDX_RA_PAGES |
IDX_RA_THRESHOLD |
LOGSIZE |
LRU_MAX_DIRTY |
LRU_MIN_DIRTY |
LTXEHWM |
LTXHWM |
MAX_PDQPRIORITY |
MIRROR |
MSGDATE |
MSGPATH |
ONDBSPACEDOWN |
OPCOMPIND |
PDQPRIORITY |
RA_PAGES |
RA_THRESHOLD |
RESIDENT |
SHMADD |
SHMTOTAL |
STACKSIZE |
SYSALARMPROGRAM |
TBLSPACE_STATS |
TXTTIMEOUT |
USEOSTIME |
WSTATS |