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 (AT) yahoo (DOT) com> wrote:



--
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 (AT) yahoo (DOT) com> wrote:

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 (AT) krediidiinfo (DOT) ee

My package utils_ak contains dbping.ec which can do what you want it to do.
Currently it just reports the actual name of the server it connected to and
the time it took to connect, but you can fetch the server status easily
enough. You will find the query:

EXEC SQL SELECT cf_effective, dbinfo( 'dbhostname' )
INTO :connected_name, :hostname
FROM sysmaster:sysconfig WHERE cf_name = 'DBSERVERNAME';

Change it to:

EXEC SQL SELECT cf_effective, dbinfo( 'dbhostname' ), sh_mode
INTO :connected_name, :hostname, :Server_Mode
FROM sysmaster:sysconfig, sysmaster:sysshmvals WHERE cf_name =
'DBSERVERNAME';

Add the host variable Server_Mode as an integer to the BEGIN DECLARE SECTION
at the top of main(), and, finally, print out the value of sh_mode. The
mode value for full online mode for a standalone server is '5', the server
mode values are documented in the Administrator's Guide.

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 Wed, Mar 30, 2011 at 7:06 AM, Kamenik, Aleksander <
aleksander.kamenik (AT) krediidiinfo (DOT) ee> wrote:

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... (AT) yahoo (DOT) com> wrote:
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 (AT) verizon (DOT) net> wrote:



--
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:
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