onmode -wf, -wm: Dynamically change certain configuration parameters

Use the onmode -wf or onmode -wm command to dynamically change specific configuration parameters.

>>-onmode--+- -wf--config_param=value-+------------------------><
           '- -wm--config_param=value-'
Element Purpose Key considerations
-wf Updates the value of the specified configuration parameter in the onconfig file. The DBA user must have write permission for the directory that contains the onconfig file.
-wm Dynamically sets the value of the specified configuration parameter in memory. The specified value is not preserved when the server is restarted.
config_param=value Specifies the configuration parameter and its new value. See Database configuration parameters.

To see a list of configuration parameters that you can tune dynamically with an onmode -wm or -wf command, run the onstat -g cfg tunable command.

You can use onmode -wm or onmode -wf to change the following configuration parameters:
  • ADMIN_MODE_USERS
  • ALARMPROGRAM
  • AUTO_AIOVPS
  • AUTO_CKPTS
  • AUTO_LRU_TUNING
  • AUTO_READAHEAD
  • AUTO_REPREPARE
  • AUTO_STAT_MODE
  • AUTOLOCATE
  • BATCHEDREAD_TABLE
  • BATCHEDREAD_INDEX
  • BLOCKTIMEOUT
  • CDR_DELAY_PURGE_DTC
  • CDR_LOG_LAG_ACTION
  • CDR_LOG_STAGING_MAXSIZE
  • CKPTINTVL
  • DBSPACETEMP
  • DEADLOCK_TIMEOUT
  • DEF_TABLE_LOCKMODE
  • DELAY_APPLY
  • DIRECTIVES
  • DRINTERVAL
  • DRTIMEOUT
  • DS_MAX_QUERIES
  • DS_MAX_SCANS
  • DS_NONPDQ_QUERY_MEM
  • DS_TOTAL_MEMORY
  • DUMPCNT
  • DUMPSHMEM
  • DYNAMIC_LOGS
  • ENABLE_SNAPSHOT
  • EXPLAIN_STAT
  • FILLFACTOR
  • HA_ALIAS
  • IFX_EXTEND_ROLE
  • IFX_FOLDVIEW
  • CONNECT_RETRIES
  • CONNECT_TIMEOUT
  • LIMITNUMSESSIONS
  • LISTEN_TIMEOUT
  • LOG_INDEX_BUILDS
  • LOG_STAGING_DIR
  • LOGSIZE
  • LOW_MEMORY_MGR (onmode -wf only, not onmode -wm)
  • LOW_MEMORY_RESERVE
  • LTAPEBLK
  • LTAPEDEV
  • LTAPESIZE
  • LTXEHWM
  • LTXHWM
  • MAX_INCOMPLETE_CONNECTIONS
  • MAX_PDQPRIORITY
  • MSG_DATE
  • MSGPATH
  • NET_IO_TIMEOUT_ALARM
  • NS_CACHE
  • ONDBSPACEDOWN
  • ONLIDX_MAXMEM
  • OPTCOMPIND
  • REMOTE_SERVER_CFG
  • REMOTE_USERS_CFG
  • RESIDENT
  • RSS_FLOW_CONTROL
  • RTO_SERVER_RESTART
  • S6_USE_REMOTE_SERVER_CFG
  • SBSPACENAME
  • SBSPACETEMP
  • SDS_TIMEOUT
  • SHMADD
  • SMX_COMPRESS
  • SP_AUTOEXPAND
  • SP_THRESHOLD
  • SP_WAITTIME
  • SQL_LOGICAL_CHAR
  • STACKSIZE
  • STATCHANGE
  • STOP_APPLY
  • SYSALARMPROGRAM
  • SYSSBSPACENAME
  • TAPEBLK
  • TAPEDEV
  • TAPESIZE
  • TBLTBLFIRST
  • TBLTBLNEXT
  • TEMPTAB_NOLOG
  • TXTIMEOUT
  • USELASTCOMMITTED
  • USTLOW_SAMPLE
  • VP_MEMORY_CACHE_KB
  • WSTATS

The onmode -wf and onmode -wm commands have equivalent SQL administration API functions.