Unformatted output of on-commands.

Can IBM do something about all these unformatted output of onstat and other "on" commands? It certainly would help for easier readability. I can't believe that in the 21st. century we're still looking at things that look like they came out of the 1960's! IDS also needs to be more autonomic, it reminds me of having to keep track of and tweak a zillion things like an IMS database!

Frank, That's the reason that we have implemented all of the pseudo tables in sysmaster, OAT, and the adminAPI routines. If you want to implement programs to automatically monitor the system, = I'd suggest using sysmaster. For folks that want a good visual representation of their system, I'd suggest using OAT. For folks wanting more autonomics, I'd suggest using the adminAPI routines. = From: "FRANK@ FRANKCOMPUTER.COM" <frank@frankcomputer.com> = = To: ids@iiug.org = = Date: 04/12/2010 09:06 AM = = Subject: Unformatted output of on-commands. [19630] = = Sent by: ids-bounces@iiug.org = = Can IBM do something about all these unformatted output of onstat and o= ther "on" commands? It certainly would help for easier readability. I can't believe that in the 21st. century we're still looking at things that look like = they came out of the 1960's! IDS also needs to be more autonomic, it reminds= me of having to keep track of and tweak a zillion things like an IMS database= ! ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

I'm not just talking about monitoring, I'm talking about "dynamically" adjusting, according to different workloads, events, problems, fault-tolerance, AUTONOMY, with minimal intervention by a DBA.

FRANK@ FRANKCOMPUTER.COM wrote: > I'm not just talking about monitoring, I'm talking about "dynamically" > adjusting, according to different workloads, events, problems, > fault-tolerance, AUTONOMY, with minimal intervention by a DBA. Madison Pruet wrote: > > For folks > wanting more autonomics, I'd suggest using the adminAPI routines. Would you like it in smaller words, or what? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

Frank, A large percentage of that is already available via the built-in monito= ring components of the adminAPI's. By using the sensors which are part of a= dmin in conjunction of the admin() and task() routines, you should be able = to get all of that fairly easily implemented by using basic SQL. = From: "FRANK@ FRANKCOMPUTER.COM" <frank@frankcomputer.com> = = To: ids@iiug.org = = Date: 04/12/2010 09:48 AM = = Subject: Re: Unformatted output of on-commands. [19633] = = Sent by: ids-bounces@iiug.org = = I'm not just talking about monitoring, I'm talking about "dynamically" adjusting, according to different workloads, events, problems, fault-tolerance, AUTONOMY, with minimal intervention by a DBA. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

I don't know what you are talking about, Frank. Onstat output is very neatly formatted, it's just pure text which is good because the Informix user community has been writing scripts to parse that output for over 25 years! If you are complaining about how the onstat outputs look when people post them to the forums, that's a problem with the poster and your browser or email handler. The text is being rendered in your default font because the posters either posted as pure text or in the poster's default font because they posted using their default fonts. To properly show onstat output you have to post using a fixed width font like courier. As for autonomics, the last four releases of IDS have included increasing numbers and scope of the autonomic features included and that will continue in the next release. In addition to that, you can program your own autonomic responses to server events using the EVENTALARM program/script parameter in the ONCONFIG file or using the features in AGS's Server Studio and Sentinel a basic license for which are included in your purchase of IDS. Frank, it is clear that you like the product and are a savvy developer, but your understanding of the product line is several years out-of-date. Welcome back to the active Informix community and give yourself time to come back up to speed. 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 Mon, Apr 12, 2010 at 10:05 AM, FRANK@ FRANKCOMPUTER.COM < frank@frankcomputer.com> wrote: > Can IBM do something about all these unformatted output of onstat and other > "on" commands? It certainly would help for easier readability. I can't > believe > that in the 21st. century we're still looking at things that look like they > came out of the 1960's! IDS also needs to be more autonomic, it reminds me > of > having to keep track of and tweak a zillion things like an IMS database! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e646537a48549104840b6ac1

If you do want a brush up on this functionality I could suggest my IIUG tutorial at this years IIUG conference. The tutorial will talk about the new functionality added in the sysadmin database in version 11 and how DBA and programmers can utilize it. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 04/12/2010 08:01:22 AM: > [image removed] > > Re: Unformatted output of on-commands. [19638] > > Art Kagel > > to: > > ids > > 04/12/2010 08:02 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > I don't know what you are talking about, Frank. Onstat output is very > neatly formatted, it's just pure text which is good because the Informix > user community has been writing scripts to parse that output for over 25 > years! If you are complaining about how the onstat outputs look when people > post them to the forums, that's a problem with the poster and your browser > or email handler. The text is being rendered in your default font because > the posters either posted as pure text or in the poster's default font > because they posted using their default fonts. To properly show onstat > output you have to post using a fixed width font like courier. > > As for autonomics, the last four releases of IDS have included increasing > numbers and scope of the autonomic features included and that will continue > in the next release. In addition to that, you can program your own > autonomic responses to server events using the EVENTALARM program/script > parameter in the ONCONFIG file or using the features in AGS's Server Studio > and Sentinel a basic license for which are included in your purchase of > IDS. Frank, it is clear that you like the product and are a savvy > developer, but your understanding of the product line is several years > out-of-date. Welcome back to the active Informix community and give > yourself time to come back up to speed. > > 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 Mon, Apr 12, 2010 at 10:05 AM, FRANK@ FRANKCOMPUTER.COM < > frank@frankcomputer.com> wrote: > > > Can IBM do something about all these unformatted output of onstat and other > > "on" commands? It certainly would help for easier readability. I can't > > believe > > that in the 21st. century we're still looking at things that look like they > > came out of the 1960's! IDS also needs to be more autonomic, it reminds me > > of > > having to keep track of and tweak a zillion things like an IMS database! > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --0016e646537a48549104840b6ac1 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Hi, As others have already responded, IDS does have the tools you need to do exactly as you wish. What is not available is for IDS to "sense" a workload change and automagically change its configuration or behavior. That would be unwise. You need to decided and declare the policy first, then write the sensors and tasks to implement those policies. The IDS SQL Admin API is straightforward to use, but you do need to understand how the DBMS works in order to use that API. My experience is that deciding the policies is difficult. A simple example concerns when reports should be run. The simple answer is something like "every day after 8 pm." But does that hold every day, including those days a the end of a quarter when transactional work often goes until midnight? You need to be very careful and ensure everyone involved agrees with the policies. Cheers, Dick Snoke Executive IT Specialist IBM Software Group - ChannelWorks Tel: (404) 487-1595 Email: dsnoke@us.ibm.com From: "FRANK@ FRANKCOMPUTER.COM" <frank@frankcomputer.com> To: ids@iiug.org Date: 04/12/10 10:48 AM Subject: Re: Unformatted output of on-commands. [19633] Sent by: ids-bounces@iiug.org I'm not just talking about monitoring, I'm talking about "dynamically" adjusting, according to different workloads, events, problems, fault-tolerance, AUTONOMY, with minimal intervention by a DBA. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.