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
- INFORMIXCONRETRY
- INFORMIXCONTIME
- 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.