Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read


End of Support Dates

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: new features about dynamic parameter added in

Posted By: Fernando Nunes
Date: Friday, 11 December 2015, at 6:03 a.m.

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

There may be a better approach, but if not you can do something like:

11.7:

onmode -wf 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
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 persistent-only
id name type maxlen units rsvd tunable
172 SDS_PAGING STRUCT 513 persistent-only
id name type maxlen units rsvd tunable
173 SDS_TIMEOUT INT4 12 Seconds *
id name type maxlen units rsvd tunable
174 HA_ALIAS CHAR 129 *
id name type maxlen units rsvd tunable
175 HA_FOC_ORDER CHAR 129 *
id name type maxlen units rsvd tunable
178 DELAY_APPLY CHAR 20 *
id name type maxlen units rsvd tunable
179 STOP_APPLY CHAR 513 *
id name type maxlen units rsvd tunable
180 LOG_STAGING_DIR CHAR 257 *
id name type maxlen units rsvd tunable
181 FAILOVER_TX_TIMEOUT INT4 12 Seconds *
id name type maxlen units rsvd tunable
182 ENABLE_SNAPSHOT_COPY BOOL 2 *
id name type maxlen units rsvd tunable
183 RSS_FLOW_CONTROL STRUCT 513 *
id name type maxlen units rsvd tunable
184 SDS_FLOW_CONTROL STRUCT 513 *
id name type maxlen units rsvd tunable
186 GRIDCOPY_DIR CHAR 513 *
id name type maxlen units rsvd tunable
188 SMX_PING_INTERVAL INT4 12 *
id name type maxlen units rsvd tunable
189 SMX_PING_RETRY INT4 12 *
id name type maxlen units rsvd tunable
190 CLUSTER_TXN_SCOPE CHAR 129 *
id name type maxlen units rsvd tunable
194 PC_POOLSIZE INT4 12 *
id name type maxlen units rsvd tunable
196 DS_POOLSIZE INT4 12 *
id name type maxlen units rsvd tunable
197 DS_MAX_QUERIES INT4 12 * *
id name type maxlen units rsvd tunable
198 DS_TOTAL_MEMORY BIGINT 21 * *
id name type maxlen units rsvd tunable
199 DS_MAX_SCANS INT4 12 * *
id name type maxlen units rsvd tunable
200 OPTCOMPIND INT4 2 * *
id name type maxlen units rsvd tunable
201 MAX_PDQPRIORITY INT4 12 * *
id name type maxlen units rsvd tunable
202 DIRECTIVES BOOL 2 * *
id name type maxlen units rsvd tunable
205 STMT_CACHE INT4 2 *
id name type maxlen units rsvd tunable
207 STMT_CACHE_NOLIMIT BOOL 2 *
id name type maxlen units rsvd tunable
209 STMT_CACHE_HITS INT4 12 *
id name type maxlen units rsvd tunable
214 IFX_EXTEND_ROLE BOOL 2 *
id name type maxlen units rsvd tunable
215 DS_NONPDQ_QUERY_MEM INT4 12 KB *
id name type maxlen units rsvd tunable
217 ONLIDX_MAXMEM INT4 12 KB *
id name type maxlen units rsvd tunable
218 IFX_FOLDVIEW BOOL 2 *
id name type maxlen units rsvd tunable
220 EXPLAIN_STAT BOOL 2 *
id name type maxlen units rsvd tunable
224 PLCY_POOLSIZE INT4 12 *
id name type maxlen units rsvd tunable
226 USRC_POOLSIZE INT4 12 *
id name type maxlen units rsvd tunable
227 TEMPTAB_NOLOG BOOL 2 *
id name type maxlen units rsvd tunable
228 AUTO_REPREPARE BOOL 2 * *
id name type maxlen units rsvd tunable
230 SQL_LOGICAL_CHAR CHAR 4 *
id name type maxlen units rsvd tunable
236 AUTO_STAT_MODE BOOL 2 *
id name type maxlen units rsvd tunable
237 STATCHANGE INT4 12 % *
id name type maxlen units rsvd tunable
239 AUTOLOCATE INT4 12 *
id name type maxlen units rsvd tunable
249 USTLOW_SAMPLE BOOL 2 *
id name type maxlen units rsvd tunable
269 LISTEN_TIMEOUT INT4 12 Seconds *
id name type maxlen units rsvd tunable
270 MAX_INCOMPLETE_CONNECTIONS INT4 12 *
id name type maxlen units rsvd tunable
275 ADMIN_MODE_USERS CHAR 128 *
id name type maxlen units rsvd tunable
278 NS_CACHE STRUCT 100 *
id name type maxlen units rsvd tunable
279 SMX_COMPRESS INT4 12 *
id name type maxlen units rsvd tunable
280 NET_IO_TIMEOUT_ALARM STRUCT 513 *
id name type maxlen units rsvd tunable
283 INFORMIXCONTIME INT4 12 Seconds *
id name type maxlen units rsvd tunable
284 INFORMIXCONRETRY INT4 12 *
id name type maxlen units rsvd tunable
290 BAR_ACT_LOG CHAR 257 persistent-only
id name type maxlen units rsvd tunable
291 BAR_DEBUG_LOG CHAR 257 persistent-only
id name type maxlen units rsvd tunable
292 BAR_MAX_BACKUP INT4 12 persistent-only
id name type maxlen units rsvd tunable
293 BAR_RETRY INT4 12 persistent-only
id name type maxlen units rsvd tunable
294 BAR_NB_XPORT_COUNT INT4 12 persistent-only
id name type maxlen units rsvd tunable
295 BAR_XFER_BUF_SIZE INT4 12 persistent-only
id name type maxlen units rsvd tunable
296 BAR_DEBUG INT4 2 persistent-only
id name type maxlen units rsvd tunable
297 BAR_BSALIB_PATH CHAR 257 persistent-only
id name type maxlen units rsvd tunable
298 BAR_PROGRESS_FREQ INT4 12 Minutes persistent-only
id name type maxlen units rsvd tunable
299 BAR_HISTORY BOOL 2 persistent-only
id name type maxlen units rsvd tunable
300 BAR_SIZE_FACTOR INT4 12 persistent-only
id name type maxlen units rsvd tunable
301 BAR_IXBAR_PATH CHAR 257 persistent-only
id name type maxlen units rsvd tunable
302 BAR_PERFORMANCE INT4 2 persistent-only
id name type maxlen units rsvd tunable
303 BAR_CKPTSEC_TIMEOUT INT4 12 Seconds *
id name type maxlen units rsvd tunable
306 PSM_ACT_LOG CHAR 257 persistent-only
id name type maxlen units rsvd tunable
307 PSM_DEBUG_LOG CHAR 257 persistent-only
id name type maxlen units rsvd tunable
308 PSM_DEBUG INT4 2 persistent-only
id name type maxlen units rsvd tunable
309 PSM_CATALOG_PATH CHAR 257 persistent-only
id name type maxlen units rsvd tunable
310 PSM_DBS_POOL CHAR 129 persistent-only
id name type maxlen units rsvd tunable
311 PSM_LOG_POOL CHAR 129 persistent-only
id name type maxlen units rsvd tunable
315 USERMAPPING CHAR 6 *
id name type maxlen units rsvd tunable
317 REMOTE_SERVER_CFG CHAR 80 *
id name type maxlen units rsvd tunable
318 REMOTE_USERS_CFG CHAR 80 *
id name type maxlen units rsvd tunable
319 S6_USE_REMOTE_SERVER_CFG BOOL 2 *
id name type maxlen units rsvd tunable
332 CDR_AUTO_DISCOVER BOOL 2 *
id name type maxlen units rsvd tunable
333 IFXGUARD STRUCT 100 *
castelo@primary:informix->

and compare...
Not pretty but it should work.
There may be some dynamic parameter that doesn't show up in 11.7 listing
depending on the version...

Regards

On Fri, Dec 11, 2015 at 10:01 AM, 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.
>
>

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

--001a1140bfd8b2924d05269d446e

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.