IDS Forum

Re: new features about dynamic parameter added in

Posted By: Ricardo Henriques
Date: Friday, 11 December 2015, at 6:56 a.m.

In Response To: new features about dynamic parameter added in 12.1 (CHUAN LU)

Attention, this is not documented.

For Informix 12.10, another way you can get the list is to use the cf_flags
column on syscfgtab to determine which onconfig parameters are dynamic:
SELECT cf_name
FROM sysmaster:syscfgtab
WHERE bitand(cf_flags,'0x1') = 0 --removes Unsupported parameters

AND bitand(cf_flags,'0x1000') = 0 --removes Undocumented
parameters

AND bitand(cf_flags,'0x4000') = 0 --removes discontinued
parameters

AND bitval(cf_flags,'0x8000') = 1 --shows only dynamic parameters
ORDER BY 1;

I believe you can also use the 0x10000 to get if it's persistent only.
http://dba-snippets.blogspot.pt/2015/03/informix-configuration-parameter.html

This, however, does not work on previous version but for the version 11.70
has already mentioned you can use the:
[infx1170@tardis etc]$ onmode -wm dummy=1
Configuration Parameter to be changed is not valid or not supported with
this
option.

The following documented configuration parameters and environment variables
can be modified on the fly with onmode -w[mf]:

ADMIN_MODE_USERS DUMPSHMEM REMOTE_SERVER_CFG
AFCRASH DYNAMIC_LOGS REMOTE_USERS_CFG
AFFAIL ENABLE_SNAPSHOT_COPY RESIDENT
AFWARN EXPLAIN_STAT RTO_SERVER_RESTART
ALARMPROGRAM FAILOVER_TX_TIMEOUT SBSPACENAME
AUTO_AIOVPS FILLFACTOR SBSPACETEMP
AUTO_CKPTS HA_ALIAS SDS_TIMEOUT
AUTO_LRU_TUNING IFX_EXTEND_ROLE SHMADD
AUTO_READAHEAD IFX_FOLDVIEW SMX_COMPRESS
AUTO_REPREPARE LIMITNUMSESSIONS SP_AUTOEXPAND
AUTO_STAT_MODE LISTEN_TIMEOUT SP_THRESHOLD
BAR_CKPTSEC_TIMEOUT LOG_INDEX_BUILDS SP_WAITTIME
BATCHEDREAD_INDEX LOGSIZE SQL_LOGICAL_CHAR
BATCHEDREAD_TABLE LOG_STAGING_DIR STACKSIZE
BLOCKTIMEOUT LOW_MEMORY_MGR STATCHANGE
CDR_DELAY_PURGE_DTC LOW_MEMORY_RESERVE STOP_APPLY
CDR_LOG_LAG_ACTION LTAPEBLK SYSALARMPROGRAM
CDR_LOG_STAGING_MAXSIZE LTAPEDEV SYSSBSPACENAME
CKPTINTVL LTAPESIZE TAPEBLK
DBSPACETEMP LTXEHWM TAPEDEV
DEADLOCK_TIMEOUT LTXHWM TAPESIZE
DEF_TABLE_LOCKMODE MAX_INCOMPLETE_CONNECTIONS TBLTBLFIRST
DELAY_APPLY MAX_PDQPRIORITY TBLTBLNEXT
DIRECTIVES MSG_DATE TEMPTAB_NOLOG
DRINTERVAL MSGPATH TXTIMEOUT
DRTIMEOUT NET_IO_TIMEOUT_ALARM USELASTCOMMITTED
DS_MAX_QUERIES NS_CACHE USERMAPPING
DS_MAX_SCANS ONDBSPACEDOWN VP_MEMORY_CACHE_KB
DS_NONPDQ_QUERY_MEM ONLIDX_MAXMEM WSTATS
DS_TOTAL_MEMORY OPTCOMPIND
DUMPCNT RA_PAGES
[infx1170@tardis etc]$

On Fri, 11 Dec 2015 at 10:01 CHUAN LU <luchuan@cn.ibm.com> wrote:

> HI,
>
> I checked new feature of V 12.1 in the information center , and kown added
> some parameter that can be changed dynamicly, but information center don't
> list those parameters , could anyone provide those parameter list can be
> changed dynamicly in v 12.1? but can't changed dynamicly in V 11.7.
> thanks for your time.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--001a11c36b2a44176905269e03cc

Messages In This Thread

• new features about dynamic parameter added in 12.1
  CHUAN LU -- Friday, 11 December 2015, at 5:01 a.m.
  • RE: new features about dynamic parameter added in
    Alexandre Marini -- Friday, 11 December 2015, at 6:02 a.m.
    • Re: new features about dynamic parameter added....
      Art Kagel -- Friday, 11 December 2015, at 6:11 a.m.
      • Re: new features about dynamic parameter added....
        Fernando Nunes -- Friday, 11 December 2015, at 6:22 a.m.
        • Re: new features about dynamic parameter added....
          Art Kagel -- Friday, 11 December 2015, at 6:26 a.m.
        • Re: new features about dynamic parameter added....
          John Miller iii -- Monday, 14 December 2015, at 12:56 p.m.
  • Re: new features about dynamic parameter added in
    Fernando Nunes -- Friday, 11 December 2015, at 6:03 a.m.
  • Re: new features about dynamic parameter added in
    Ricardo Henriques -- Friday, 11 December 2015, at 6:56 a.m.
  • Re: new features about dynamic parameter added in
    CHUAN LU -- Wednesday, 16 December 2015, at 10:41 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.