Monitoring Informixservers
A user asked whether any tool can monitor dozens of Informix instances on one screen, roughly one or two lines per instance. No single product was identified that does exactly that. Suggestions included AGS Server Studio/Sentinel (powerful but pricey, no site licence and no one-line summary view), OAT, older Tivoli TEC agents, and generic monitoring frameworks like Nagios or Big Brother — one poster reported scripting Big Brother checks (onstat -, a test connect, log/dbspace fullness, memory growth) to get exactly the one-line-per-server dashboard. Others discussed using sysadmin/task scheduling to replicate collected data and alarms to a central repository viewed via OAT, with the caveat that this won't reveal a downed instance. No definitive resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Is there a tool that enables me to monitor several -- or scores -- of informixservers, perhaps on a single screen? e.g., a single scrolling display with one or two lines per instance?
Hmmmm... I suppose Sentinel can do that. Maybe OAT and others. Could you ellaborate on what do you mean by "monitor"... Specifically what would you want to see in that line(s)? Regards On Tue, Mar 29, 2011 at 11:49 PM, red_valsen <red_valsen@yahoo.com> wrote: > Is there a tool that enables me to monitor several -- or scores -- of > informixservers, perhaps on a single screen? e.g., a single scrolling > display with one or two lines per instance? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...
AGS Server Studio and Sentinel will let you monitor as many servers as you want. You won't get a two line display for each though. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 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, Mar 29, 2011 at 6:49 PM, red_valsen <red_valsen@yahoo.com> wrote: > Is there a tool that enables me to monitor several -- or scores -- of > informixservers, perhaps on a single screen? e.g., a single scrolling > display with one or two lines per instance? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >
>> "red_valsen" <red_valsen@yahoo.com> wrote in message >> news:56b3701d-9aaa-4900-8791-0f74a3dca494@x18g2000yqe.googlegroups.com... > Is there a tool that enables me to monitor several -- or scores -- of > informixservers, perhaps on a single screen? e.g., a single scrolling > display with one or two lines per instance? You'd probably have to script something. I don't know of anything commercially available. The Informix Online Admin Tool (OAT) has come on leaps and bounds and is an attractive, functional GUI view of what's going on on a particualr instance. In my view Sentinel, a 3rd-party product, still has the edge in terms of functionality, but I don't think it provides a status summary on a single screen. Also it has IMHO a very rigid pricing structure, with no concept of Site licence, so to deploy it to manage scores of instances you're going to need very deep pockets.
On 29/03/2011 23:49, red_valsen wrote: > Is there a tool that enables me to monitor several -- or scores -- of > informixservers, perhaps on a single screen? e.g., a single scrolling > display with one or two lines per instance? You could probably script something with Nagios or BB4 -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish.
> > Is there a tool that enables me to monitor several -- or scores -- of > > informixservers, perhaps on a single screen? e.g., a single scrolling > > display with one or two lines per instance? > > You'd probably have to script something. I don't know of anything > commercially available. > > The Informix Online Admin Tool (OAT) has come on leaps and bounds and > is an > attractive, functional GUI view of what's going on on a particualr > instance. > > In my view Sentinel, a 3rd-party product, still has the edge in terms > of > functionality, but I don't think it provides a status summary on a > single > screen. Also it has IMHO a very rigid pricing structure, with no > concept of > Site licence, so to deploy it to manage scores of instances you're > going to > need very deep pockets. What about something really simple to see that the server is still in Online mode. Connect to TCP port, get server status (Online, Single-User, etc) and disconnect. Could something like this be done with a simple C script or must one use the connection libraries (informix or drda)? I'd would use it with monit (http://mmonit.com/monit/). Simply connecting to the TCP port does not give me a status and results in spam in the online.log. Regards, Aleksander Kamenik System Administrator Krediidiinfo AS an Experian Company Phone: +372 665 9649 Email: aleksander@krediidiinfo.ee
We use Big Brother to monitor all servers like this. We have a single
line for each server that shows a single dot (green, yellow, red) for
each of cpu, disk, msgs, etc. And it's been very easy to add the
scripting lines for Informix online (onstat -), able to connect (quick
select of a single row), logs not full, dbspaces not full, and
informix memory not grown beyond what we expect.
It's actually pretty nice to have this all monitored with all the
other systems.
On Mar 29, 5:49 pm, red_valsen <red_val...@yahoo.com> wrote: > Is there a tool that enables me to monitor several -- or scores -- of > informixservers, perhaps on a single screen? e.g., a single scrolling > display with one or two lines per instance? Gee - wouldn't it be nice to have a global sysmaster that could span nodes...
11.70.xC3?! :P Seriously, sysadmin and tasks present a robust layer to build on. It's pretty simple to generate local collection data and replicate that to a central repository. OAT can be used to connect to that central instance and present the information in a friendly format. This is a requirement for customer with some instances. On a customer site I've started to do this. Currently only alarms are centralized and there is a plugin to present them in a unified view (showing the usual information plus instance/host) Regards On Fri, Apr 1, 2011 at 2:42 AM, mpruet <mpruet1@verizon.net> wrote: > On Mar 29, 5:49 pm, red_valsen <red_val...@yahoo.com> wrote: > > Is there a tool that enables me to monitor several -- or scores -- of > > informixservers, perhaps on a single screen? e.g., a single scrolling > > display with one or two lines per instance? > > Gee - wouldn't it be nice to have a global sysmaster that could span > nodes... > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...
Am 30.03.2011 00:49, schrieb red_valsen: > Is there a tool that enables me to monitor several -- or scores -- of > informixservers, perhaps on a single screen? e.g., a single scrolling > display with one or two lines per instance? some yrs ago, Tivoli's TEC had agents & presentation to do what you want Have done some digging in the cellar & found this (dated 2002): http://www.iiug.org/library/ids/technical/sg246613.pdf But Tivoli never was a cheap bargain, so be warned that it is only for the wealthy ;) dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe
On Apr 1, 6:10 am, Fernando Nunes <domusonl...@gmail.com> wrote: > 11.70.xC3?! :P > > Seriously, sysadmin and tasks present a robust layer to build on. > It's pretty simple to generate local collection data and replicate that to a > central repository. OAT can be used to connect to that central instance and > present the information in a friendly format. > This is a requirement for customer with some instances. Which is OK if you want a history of the systems, but does not reflect the current state of the systems. (i.e. what if a server is down, or the replications is not working...) M.P. > > On a customer site I've started to do this. Currently only alarms are > centralized and there is a plugin to present them in a unified view (showing > the usual information plus instance/host) > > Regards > > On Fri, Apr 1, 2011 at 2:42 AM, mpruet <mpru...@verizon.net> wrote: > > On Mar 29, 5:49 pm, red_valsen <red_val...@yahoo.com> wrote: > > > Is there a tool that enables me to monitor several -- or scores -- of > > > informixservers, perhaps on a single screen? e.g., a single scrolling > > > display with one or two lines per instance? > > > Gee - wouldn't it be nice to have a global sysmaster that could span > > nodes... > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently...
I see your point, but since the alarms are centralized, you can see it... Of course some situations must be handled differently (ALARMPROGRAM)... If the instance is down, you will not see an alert in the "central console"... But if your bakups are too old, or your dbspaces are too full, or the logical log backup is not running etc. you'll see it. Regards. On Fri, Apr 1, 2011 at 2:09 PM, mpruet <mpruet1@verizon.net> wrote: > On Apr 1, 6:10 am, Fernando Nunes <domusonl...@gmail.com> wrote: > > 11.70.xC3?! :P > > > > Seriously, sysadmin and tasks present a robust layer to build on. > > It's pretty simple to generate local collection data and replicate that > to a > > central repository. OAT can be used to connect to that central instance > and > > present the information in a friendly format. > > This is a requirement for customer with some instances. > > Which is OK if you want a history of the systems, but does not reflect > the current state of the systems. > (i.e. what if a server is down, or the replications is not working...) > > > M.P. > > > > > On a customer site I've started to do this. Currently only alarms are > > centralized and there is a plugin to present them in a unified view > (showing > > the usual information plus instance/host) > > > > Regards > > > > On Fri, Apr 1, 2011 at 2:42 AM, mpruet <mpru...@verizon.net> wrote: > > > On Mar 29, 5:49 pm, red_valsen <red_val...@yahoo.com> wrote: > > > > Is there a tool that enables me to monitor several -- or scores -- of > > > > informixservers, perhaps on a single screen? e.g., a single scrolling > > > > display with one or two lines per instance? > > > > > Gee - wouldn't it be nice to have a global sysmaster that could span > > > nodes... > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-l...@iiug.org > > >http://www.iiug.org/mailman/listinfo/informix-list > > > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently... > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...