Multiple onconfig profiles for different workloads

Posted in 2010

FRANK — Mon, 05 Apr 2010 00:33:13 — source: IIUG Forums & Mailing Lists

Can I define specific sets of parameters for onconfig, store them in seperate profiles and make a particular profile effective depending on the date, weekday, time of day, without using cron to execute them? Examples: Mondays at 0900: profile1 {low mode} Mondays at 1100: profile2 {peak mode} Mondays at 1700: profile3 {business day closing mode} Mondays at 1900: profile4 {single user admin mode} 2010-04-30 at 2200: profile5 {end of month mode}

↪ replying to FRANK

Art Kagel — Wed, 07 Apr 2010 00:59:24 — source: IIUG Forums & Mailing Lists

You can always shutdown the engine, rename the correct ONCONFIG file, then restart the engine from a cron. so yes. Odd, but doable. You can also, if you license the MACH11 code, set up a shared disk secondary server with different parameters to share the database on disk and server users with a different set of queries. So, one server for OLTP and another for DSS queries. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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 Sun, Apr 4, 2010 at 8:33 PM, FRANK COMPUTER <frank@frankcomputer.com>wrote: > Can I define specific sets of parameters for onconfig, store them in > seperate > profiles and make a particular profile effective depending on the date, > weekday, time of day, without using cron to execute them? Examples: > > Mondays at 0900: profile1 {low mode} > Mondays at 1100: profile2 {peak mode} > Mondays at 1700: profile3 {business day closing mode} > Mondays at 1900: profile4 {single user admin mode} > > 2010-04-30 at 2200: profile5 {end of month mode} > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016368e296206849a04839b121e

↪ replying to Art Kagel

FRANK@ — Wed, 07 Apr 2010 01:06:02 — source: IIUG Forums & Mailing Lists

Can't changes be made without bringing down the engine, say like with onmode? The reason is for optimizing the server depending on the workload involved during different dayes, days and time, like the examples I gave in initial question.

↪ replying to FRANK@

Art Kagel — Wed, 07 Apr 2010 01:46:05 — source: IIUG Forums & Mailing Lists

Some parameters can be changed on the fly, not most. See the documentation of the onmode utility in the Adminstrator's Reference manual. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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 Tue, Apr 6, 2010 at 9:06 PM, FRANK@ FRANKCOMPUTER.COM < frank@frankcomputer.com> wrote: > Can't changes be made without bringing down the engine, say like with > onmode? > The reason is for optimizing the server depending on the workload involved > during different dayes, days and time, like the examples I gave in initial > question. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5c1a8760d5a04839bb989

↪ replying to FRANK@

Madison — Wed, 07 Apr 2010 03:00:41 — source: IIUG Forums & Mailing Lists

some things can be changed via onmode and those things can be scheduled= via dbcron. = From: "FRANK@ FRANKCOMPUTER.COM" <frank@frankcomputer.com> = = To: ids@iiug.org = = Date: 04/06/2010 08:06 PM = = Subject: Re: Multiple onconfig profiles for different workl [1951= 4] = Sent by: ids-bounces@iiug.org = = Can't changes be made without bringing down the engine, say like with onmode? The reason is for optimizing the server depending on the workload invol= ved during different dayes, days and time, like the examples I gave in init= ial question. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Glossary

onconfig