health of a server

Hi how to know a ids server health ? what are onstat commands to use ? and what are the results exprected to say that a server is healthy or not ? Thank you in advance

Well... you may be amazed, but you think about htis carefully there's no simple answer... not for Informix or any other database server: 1- It must be running.... a simple "onstat -" will tell you that. But... 2- You must be able to connect to it... and if you can't it may mean the network has an issue... 3- But "what network"? As you may have listeners spread across different networks 4- But even if you're able o connect... can you do queries? SELECT/INSERT/UPDATE/DELETE? You may be able to run a SELECT and can't do an INSERT (if it's blocked in a checkpoint, or due to a long transaction) 5- And even if you do a query, did it run fast enough? etc... Regards On Mon, Jan 4, 2016 at 4:27 PM, SMITH JOHN <daylight@webmails.com> wrote: > Hi > > how to know a ids server health ? > what are onstat commands to use ? and what are the results exprected to say > that a server is healthy or not ? > > Thank you in advance > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --047d7bdc07e2c50760052884cad1

That's a HUGE subject. Too big for a single forum post. Suggestions: - Search the forum for entries that include the keywords "tuning", "performance", and similar. - Go to the IIUG member pages and the IIUG Conference materials and download any presentations about performance tuning, monitoring, sysmaster, onstat, etc. There should be many be several be several community members including me. Study these. - Download my ratios.shr_ak package from the IIUG Software Repository, install the ratios.sql stored procedure in your sysmaster database and run the newratios.sh script periodically to see several metrics that will give you a quick overview of your server's health. - Contact a reputable Informix consultancy to perform a health check on your server and perhaps set up 24x7 remote monitoring for you. Some good choices are my own consultancy (www.askdbmgt.com), Advanced DataTools ( www.advancedatatools.com), Oninit (www.oninit.com), Oninit UK ( www.oninitgroup.com), Ardenta in the UK (www.ardenta.com), and there are others. - Attend the 2016 IIUG Conference in Florida in the spring: (iiug2016.org). The greatest source of Informix knowledge in one place and time. - Take the Advanced DataTools Advanced Performance Tuning course that Lester Knutsen and I present jointly. The next session is in July: http://www.advancedatatools.com/Training/InformixPerformanceTuningCourse.html Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 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, Jan 4, 2016 at 11:27 AM, SMITH JOHN <daylight@webmails.com> wrote: > Hi > > how to know a ids server health ? > what are onstat commands to use ? and what are the results exprected to say > that a server is healthy or not ? > > Thank you in advance > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1141c1e081f1b8052884cf15

Hi. A good starting point if you are not familiar with Informix, is to install OAT (Open Admin Tool), a free web interface for your connection, and start a "health check". It should give you some pretty good stuff about your server. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Certified Developer - Informix Genero BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: daylight@webmails.com > Subject: health of a server [36331] > Date: Mon, 4 Jan 2016 11:27:50 -0500 > > Hi > > how to know a ids server health ? > what are onstat commands to use ? and what are the results exprected to say > that a server is healthy or not ? > > Thank you in advance > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

As others have said, this is a huge topic... I did a presentation at the IIUG 2015 conference on "Monitoring the Health of your Database". It doesn't concentrate much on the individual onstats, but was intended to highlight just a few of the things that you can check. http://iiug2015.org/files/IIUG2015Mike_WalkerB01_-_Monitoring_the_Health_of_ your_Database.pdf Outside of the IIUG resources that Art mentioned, you may want to check out some of the webcasts here: http://advancedatatools.com/Informix/Webcasts.html There's a couple on using the sysmaster database which may be helpful. As Art already said, there are training courses available which will cover this topic and companies (such as Advanced DataTools...) that can perform detailed healthchecks of your system. Regards, Mike -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SMITH JOHN Sent: Monday, January 04, 2016 9:28 AM To: ids@iiug.org Subject: health of a server [36331] Hi how to know a ids server health ? what are onstat commands to use ? and what are the results exprected to say that a server is healthy or not ? Thank you in advance **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks a lot to all :)