Home | Previous Page | Next Page   Utility Reference > onutil: Check, Define, and Modify Storage Objects >

SET

The onutil SET command allows you to dynamically change configuration parameters while the server is running.

Syntax

Read syntax diagramSkip visual syntax diagram>>-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.

Usage

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
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]