Re: Monitoring Informixservers

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@krediidiinfo.ee> 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'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 > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >