new features about dynamic parameter added in 12.1
Someone asked for the list of ONCONFIG parameters that became dynamically changeable in 12.10 but weren't in 11.70, since the docs don't enumerate them. Suggestions: in 11.70 run "onmode -wm dummy=1" to make the engine print the list of tunable parameters (this no longer works in 12.10); in 12.10 use "onstat -g cfg tunable" (and "onstat -g cfg full" for details), as confirmed by IBM's John Miller. An alternative is querying sysmaster:syscfgtab with bitand on cf_flags (0x8000 = dynamic). The original poster then posted the resulting list of newly dynamic 12.10 parameters, so the question was resolved.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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.
Hello, my friend.
Just make an "onmode -wm AAA=A" and the engine should print an output with the
possible parameters.
Best regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Information Management Informix Technical Professional
IBM Certified Developer - Informix Genero
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: luchuan@cn.ibm.com
> Subject: new features about dynamic parameter added in 12.1 [36223]
> Date: Fri, 11 Dec 2015 05:01:12 -0500
>
> 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.
>
There may be a better approach, but if not you can do something like:
11.7:
onmode -wf dummy=1Configuration 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 TAPESIZEDEF_TABLE_LOCKMODE MAX_INCOMPLETE_CONNECTIONS TBLTBLFIRST
DELAY_APPLY MAX_PDQPRIORITY TBLTBLNEXT
DIRECTIVES MSG_DATE TEMPTAB_NOLOG
DRINTERVAL MSGPATH TXTIMEOUTDRTIMEOUT 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
mouraria@primary:informix->
12.10:
castelo@primary:informix-> onstat -g cfg tunable | egrep "^[i0-9]"
id name type maxlen units rsvd tunable
10 MSGPATH CHAR 257 * *
id name type maxlen units rsvd tunable
12 TAPEDEV CHAR 257 * persistent-only
id name type maxlen units rsvd tunable
13 TAPESIZE UBIGINT 21 KB *
persistent-only
id name type maxlen units rsvd tunable
14 TAPEBLK INT4 12 KB * persistent-only
id name type maxlen units rsvd tunable
15 LTAPEDEV CHAR 257 * persistent-only
id name type maxlen units rsvd tunable
16 LTAPESIZE UBIGINT 21 KB *
persistent-only
id name type maxlen units rsvd tunable
17 LTAPEBLK INT4 12 KB * persistent-only
id name type maxlen units rsvd tunable
21 LOGSIZE INT4 12 KB * *
id name type maxlen units rsvd tunable
23 DYNAMIC_LOGS INT4 2 * *
id name type maxlen units rsvd tunable
24 LTXHWM INT4 12 % * *
id name type maxlen units rsvd tunable
25 LTXEHWM INT4 12 % * *
id name type maxlen units rsvd tunable
26 DEADLOCK_TIMEOUT INT4 12 Seconds *
id name type maxlen units rsvd tunable
27 RESIDENT INT4 12 * *
id name type maxlen units rsvd tunable
29 ONDBSPACEDOWN INT4 2 *
id name type maxlen units rsvd tunable
32 CKPTINTVL INT4 12 Seconds * *
id name type maxlen units rsvd tunable
35 TXTIMEOUT INT4 12 Seconds *
id name type maxlen units rsvd tunable
36 RA_PAGES INT4 12 Pages *
id name type maxlen units rsvd tunable
37 FILLFACTOR INT4 12 % *
id name type maxlen units rsvd tunable
39 DBSPACETEMP CHAR 513 * *
id name type maxlen units rsvd tunable
40 OFF_RECVRY_THREADS INT4 12 persistent-only
id name type maxlen units rsvd tunable
45 SYSALARMPROGRAM CHAR 257 *
id name type maxlen units rsvd tunable
48 DEF_TABLE_LOCKMODE CHAR 5 *
id name type maxlen units rsvd tunable
54 TBLTBLNEXT INT4 12 KB *
id name type maxlen units rsvd tunable
60 RTO_SERVER_RESTART INT4 12 Seconds * *
id name type maxlen units rsvd tunable
61 RAS_PLOG_SPEED UINT4 12 * *
id name type maxlen units rsvd tunable
62 RAS_LLOG_SPEED UINT4 12 * *
id name type maxlen units rsvd tunable
63 AUTO_TUNE INT4 12 *
id name type maxlen units rsvd tunable
65 AUTO_LLOG STRUCT 513 * *
id name type maxlen units rsvd tunable
66 AUTO_LRU_TUNING CHAR 513 * *
id name type maxlen units rsvd tunable
67 AUTO_CKPTS BOOL 2 * *
id name type maxlen units rsvd tunable
68 AUTO_AIOVPS BOOL 2 * *
id name type maxlen units rsvd tunable
69 USELASTCOMMITTED CHAR 20 *
id name type maxlen units rsvd tunable
70 LOG_INDEX_BUILDS BOOL 2 *
id name type maxlen units rsvd tunable
71 BATCHEDREAD_INDEX BOOL 2 *
id name type maxlen units rsvd tunable
73 BATCHEDREAD_TABLE BOOL 2 *
id name type maxlen units rsvd tunable
82 SP_AUTOEXPAND BOOL 2 * *
id name type maxlen units rsvd tunable
83 SP_THRESHOLD FLOAT 21 * *
id name type maxlen units rsvd tunable
84 SP_WAITTIME INT4 12 Seconds *
id name type maxlen units rsvd tunable
86 PN_STAGEBLOB_THRESHOLD UINT4 12 *
id name type maxlen units rsvd tunable
88 AUTO_READAHEAD STRUCT 513 * *
id name type maxlen units rsvd tunable
89 SESSION_LIMIT_LOCKS INT4 12 *
id name type maxlen units rsvd tunable
90 SESSION_LIMIT_MEMORY INT4 12 KB *
id name type maxlen units rsvd tunable
91 SESSION_LIMIT_TEMPSPACE INT4 12 KB *
id name type maxlen units rsvd tunable
92 SESSION_LIMIT_LOGSPACE INT4 12 KB *
id name type maxlen units rsvd tunable
93 SESSION_LIMIT_TXN_TIME INT4 12 KB *
id name type maxlen units rsvd tunable
94 TENANT_LIMIT_SPACE INT4 12 KB *
id name type maxlen units rsvd tunable
96 IFX_XA_UNIQUEXID_IN_DATABASE BOOL 2 *
id name type maxlen units rsvd tunable
104 WSTATS BOOL 2 *
id name type maxlen units rsvd tunable
106 STACKSIZE INT4 12 KB * *
id name type maxlen units rsvd tunable
109 DUMPSHMEM INT4 2 *
id name type maxlen units rsvd tunable
110 DUMPGCORE BOOL 2 *
id name type maxlen units rsvd tunable
111 DUMPCORE BOOL 2 *
id name type maxlen units rsvd tunable
112 DUMPCNT INT4 12 *
id name type maxlen units rsvd tunable
116 SHMADD UBIGINT 21 * *
id name type maxlen units rsvd tunable
119 ALARMPROGRAM CHAR 257 * *
id name type maxlen units rsvd tunable
125 BLOCKTIMEOUT INT4 12 Seconds *
id name type maxlen units rsvd tunable
126 VP_MEMORY_CACHE_KB STRUCT 513 * *
id name type maxlen units rsvd tunable
131 MSG_DATE BOOL 2 *
id name type maxlen units rsvd tunable
133 LIMITNUMSESSIONS STRUCT 513 *
id name type maxlen units rsvd tunable
135 LOW_MEMORY_RESERVE CHAR 513 * *
id name type maxlen units rsvd tunable
139 SBSPACENAME CHAR 129 * *
id name type maxlen units rsvd tunable
140 SYSSBSPACENAME CHAR 129 * *
id name type maxlen units rsvd tunable
141 SBSPACETEMP CHAR 513 * *
id name type maxlen units rsvd tunable
153 CDR_DELAY_PURGE_DTC CHAR 513 *
id name type maxlen units rsvd tunable
154 CDR_APPLY STRUCT 513 *
id name type maxlen units rsvd tunable
158 CDR_LOG_LAG_ACTION STRUCT 513 *
id name type maxlen units rsvd tunable
159 CDR_LOG_STAGING_MAXSIZE CHAR 513 *
id name type maxlen units rsvd tunable
160 CDR_MAX_FLUSH_SIZE INT4 12 *
id name type maxlen units rsvd tunable
161 CDR_TSINSTANCEID UINT4 12 *
id name type maxlen units rsvd tunable
162 CDR_MEM UINT4 12 *
id name type maxlen units rsvd tunable
165 DRINTERVAL INT4 12 *
id name type maxlen units rsvd tunable
166 DRTIMEOUT INT4 12 Seconds *
id name type maxlen units rsvd tunable
169 HDR_TXN_SCOPE CHAR 513 *
id name type maxlen units rsvd tunable
170 SDS_ENABLE BOOL 2 *
id name type maxlen units rsvd tunable
171 SDS_TEMPDBS STRUCT 8192 persiste
Alexandre:
Version 11.50 printed out the list if you specified an invalid parameter,
11.70 and 12.10 don't do that any more.
B^(
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Fri, Dec 11, 2015 at 6:02 AM, Alexandre Marini <alexandre@briug.org>
wrote:
> Hello, my friend.
> Just make an "onmode -wm AAA=A" and the engine should print an output with
> the
> possible parameters.
>
> Best regards.
>
> Alexandre Marini
> IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
>
> IBM Information Management Informix Technical Professional
>
> IBM Certified Developer - Informix Genero
> BRIUG website administrator
> Informix independent consultant
>
> > To: ids@iiug.org
> > From: luchuan@cn.ibm.com
> > Subject: new features about dynamic parameter added in 12.1 [36223]
> > Date: Fri, 11 Dec 2015 05:01:12 -0500
> >
> > 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.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113eeaf498f45205269d615f
11.70.FC8 does (at least on Linux). See my previous email.
But I also have the feeling that behavior is not consistent across versions
and that some parameters that are shown are not really dynamix or
vice-versa (some dynamic parameters may not be shown)
Regards
On Fri, Dec 11, 2015 at 11:11 AM, Art Kagel <art.kagel@gmail.com> wrote:
> Alexandre:
>
> Version 11.50 printed out the list if you specified an invalid parameter,
> 11.70 and 12.10 don't do that any more.
>
> B^(
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Fri, Dec 11, 2015 at 6:02 AM, Alexandre Marini <alexandre@briug.org>
> wrote:
>
> > Hello, my friend.
> > Just make an "onmode -wm AAA=A" and the engine should print an output
> with
> > the
> > possible parameters.
> >
> > Best regards.
> >
> > Alexandre Marini
> > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> >
> > IBM Information Management Informix Technical Professional
> >
> > IBM Certified Developer - Informix Genero
> > BRIUG website administrator
> > Informix independent consultant
> >
> > > To: ids@iiug.org
> > > From: luchuan@cn.ibm.com
> > > Subject: new features about dynamic parameter added in 12.1 [36223]
> > > Date: Fri, 11 Dec 2015 05:01:12 -0500
> > >
> > > 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.
> > >
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a113eeaf498f45205269d615f
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--047d7bdc1bd0faafa205269d8896
Cool, anyway, the real point is onmode doesn't do that in v12. Always
forget about onstat -g cfg though, thanks.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Fri, Dec 11, 2015 at 6:22 AM, Fernando Nunes <domusonline@gmail.com>
wrote:
> 11.70.FC8 does (at least on Linux). See my previous email.
> But I also have the feeling that behavior is not consistent across versions
> and that some parameters that are shown are not really dynamix or
> vice-versa (some dynamic parameters may not be shown)
>
> Regards
>
> On Fri, Dec 11, 2015 at 11:11 AM, Art Kagel <art.kagel@gmail.com> wrote:
>
> > Alexandre:
> >
> > Version 11.50 printed out the list if you specified an invalid parameter,
> > 11.70 and 12.10 don't do that any more.
> >
> > B^(
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG, nor any other organization with which I
> am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Fri, Dec 11, 2015 at 6:02 AM, Alexandre Marini <alexandre@briug.org>
> > wrote:
> >
> > > Hello, my friend.
> > > Just make an "onmode -wm AAA=A" and the engine should print an output
> > with
> > > the
> > > possible parameters.
> > >
> > > Best regards.
> > >
> > > Alexandre Marini
> > > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> > >
> > > IBM Information Management Informix Technical Professional
> > >
> > > IBM Certified Developer - Informix Genero
> > > BRIUG website administrator
> > > Informix independent consultant
> > >
> > > > To: ids@iiug.org
> > > > From: luchuan@cn.ibm.com
> > > > Subject: new features about dynamic parameter added in 12.1 [36223]
> > > > Date: Fri, 11 Dec 2015 05:01:12 -0500
> > > >
> > > > 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.
> > > >
> > >
> > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a113eeaf498f45205269d615f
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --
> Fernando Nunes
> Portugal
>
> http://informix-technology.blogspot.com
> My email works... but I don't check it frequently...
>
> --047d7bdc1bd0faafa205269d8896
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--047d7b3a96c251221b05269d99a7
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 TAPESIZEDEF_TABLE_LOCKMODE MAX_INCOMPLETE_CONNECTIONS TBLTBLFIRST
DELAY_APPLY MAX_PDQPRIORITY TBLTBLNEXT
DIRECTIVES MSG_DATE TEMPTAB_NOLOG
DRINTERVAL MSGPATH TXTIMEOUTDRTIMEOUT 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
To show all onconfig parameters which are dynamically tunable run
onstat -g cfg tunable
To see a detailed list and description of all configuration parameters run
onstat -g cfg full
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 12/11/2015 03:22:25 AM:
> From: "Fernando Nunes" <domusonline@gmail.com>
> To: ids@iiug.org
> Date: 12/11/2015 03:23 AM
> Subject: Re: new features about dynamic parameter added.... [36227]
> Sent by: ids-bounces@iiug.org
>
> 11.70.FC8 does (at least on Linux). See my previous email.
> But I also have the feeling that behavior is not consistent across
versions
> and that some parameters that are shown are not really dynamix or
> vice-versa (some dynamic parameters may not be shown)
>
> Regards
>
> On Fri, Dec 11, 2015 at 11:11 AM, Art Kagel <art.kagel@gmail.com> wrote:
>
> > Alexandre:
> >
> > Version 11.50 printed out the list if you specified an invalid
parameter,
> > 11.70 and 12.10 don't do that any more.
> >
> > B^(
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own
opinions
> > and do not reflect on the IIUG, nor any other organization with which I
am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Fri, Dec 11, 2015 at 6:02 AM, Alexandre Marini <alexandre@briug.org>
> > wrote:
> >
> > > Hello, my friend.
> > > Just make an "onmode -wm AAA=3DA" and the engine should print an outp=
ut
> > with
> > > the
> > > possible parameters.
> > >
> > > Best regards.
> > >
> > > Alexandre Marini
> > > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> > >
> > > IBM Information Management Informix Technical Professional
> > >
> > > IBM Certified Developer - Informix Genero
> > > BRIUG website administrator
> > > Informix independent consultant
> > >
> > > > To: ids@iiug.org
> > > > From: luchuan@cn.ibm.com
> > > > Subject: new features about dynamic parameter added in 12.1 [36223]
> > > > Date: Fri, 11 Dec 2015 05:01:12 -0500
> > > >
> > > > 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.
> > > >
> > >
> > >
> > >
> > >
> >
> >
>
***************************************************************************=
****
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a113eeaf498f45205269d615f
> >
> >
> >
> >
>
***************************************************************************=
****
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --
> Fernando Nunes
> Portugal
>
> http://informix-technology.blogspot.com
> My email works... but I don't check it frequently...
>
> --047d7bdc1bd0faafa205269d8896
>
>
>
***************************************************************************=
****
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
with you help, and i found below parameter can be changed dynamicly in version
12.1
AUTOLOCATE
AUTO_LLOG
AUTO_TUNE
BAR_ACT_LOG
BAR_BSALIB_PATH
BAR_DEBUG
BAR_DEBUG_LOG
BAR_HISTORY
BAR_IXBAR_PATH
BAR_MAX_BACKUP
BAR_NB_XPORT_COUNT
BAR_PERFORMANCE
BAR_PROGRESS_FREQ
BAR_RETRY
BAR_SIZE_FACTOR
BAR_XFER_BUF_SIZE
CDR_APPLY
CDR_AUTO_DISCOVER
CDR_MAX_FLUSH_SIZE
CDR_MEMCDR_TSINSTANCEID
CLUSTER_TXN_SCOPE
DS_POOLSIZE
DUMPCORE
DUMPGCOREGRIDCOPY_DIR
HA_FOC_ORDER
HDR_TXN_SCOPEIFXGUARD
IFX_XA_UNIQUEXID_IN_DATABASE
INFORMIXCONRETRY
INFORMIXCONTIME
OFF_RECVRY_THREADS
ONLIDX_MAXMEM
PC_POOLSIZE
PLCY_POOLSIZEPN_STAGEBLOB_THRESHOLD
PSM_ACT_LOG
PSM_CATALOG_PATH
PSM_DBS_POOL
PSM_DEBUG
PSM_DEBUG_LOG
PSM_LOG_POOL
RAS_LLOG_SPEED
RAS_PLOG_SPEED
RSS_FLOW_CONTROL
S6_USE_REMOTE_SERVER_CFG
SDS_ENABLE
SDS_FLOW_CONTROL
SDS_PAGING
SDS_TEMPDBS
SESSION_LIMIT_LOCKSSESSION_LIMIT_LOGSPACE
SESSION_LIMIT_MEMORY
SESSION_LIMIT_TEMPSPACE
SESSION_LIMIT_TXN_TIME
SMX_PING_INTERVAL
SMX_PING_RETRY
STMT_CACHE
STMT_CACHE_HITS
STMT_CACHE_NOLIMIT
TENANT_LIMIT_SPACE
USRC_POOLSIZE
USTLOW_SAMPLE
WSTATS