Informix Server Health Check
DBA seeks health check scripts for Informix 11.70 to monitor limits like max rows/pages per fragment. Responses recommend: IIUG conference presentations with sample queries, and OpenAdmin Tool (OAT) Health Advisor which provides built-in checks with customizable thresholds. OAT documentation accessible via context help (?) button.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, I am running a health check on our Informix 11.70 server. We are checking for things like making sure we are not reaching any limits e.g. max row per fragment, max pages per fragment, any integer columns not reaching the limit. Just wondering, are there any health check scripts already out there that will help with this? Thank You, --Dave --047d7bfd0562424ccd04ec2bbacf
Look at the presentations from the IIUG Conferences. There are some queries you can use in some of my presentations and also in Lester Knutsen's as well as from others. Art Art S. Kagel, Principal Consultant 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, Nov 27, 2013 at 12:14 PM, Informix DBA <in4mixdba@gmail.com> wrote: > Hi, > > I am running a health check on our Informix 11.70 server. We are checking > for things like making sure we are not reaching any limits e.g. max row per > fragment, max pages per fragment, any integer columns not reaching the > limit. > > Just wondering, are there any health check scripts already out there that > will help with this? > > Thank You, > > --Dave > > --047d7bfd0562424ccd04ec2bbacf > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0160ba3a438aa304ec2c8d62
The Health Advisor in OpenAdmin Tool (OAT) comes with several checks with the capability to modify some of the thresholds and also add new checks. More details are in this article: http://www.ibm.com/developerworks/data/library/techarticle/dm-1303openadmin/ Regards, Sumanth. On Wed, Nov 27, 2013 at 9:14 AM, Informix DBA <in4mixdba@gmail.com> wrote: > Hi, > > I am running a health check on our Informix 11.70 server. We are checking > for things like making sure we are not reaching any limits e.g. max row per > fragment, max pages per fragment, any integer columns not reaching the > limit. > > Just wondering, are there any health check scripts already out there that > will help with this? > > Thank You, > > --Dave > > --047d7bfd0562424ccd04ec2bbacf > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0116166082224b04ec3004fa
is there any document to understand OAT configuration because cpu usage is showing 489.00%. This is not unusual thing Thank you On Thu, Nov 28, 2013 at 6:21 AM, Sumanth Rajagopal <sumanth.r@gmail.com>wrote: > The Health Advisor in OpenAdmin Tool (OAT) comes with several checks with > the capability to modify some of the thresholds and also add new checks. > > More details are in this article: > > > http://www.ibm.com/developerworks/data/library/techarticle/dm-1303openadmin/ > > Regards, > Sumanth. > > On Wed, Nov 27, 2013 at 9:14 AM, Informix DBA <in4mixdba@gmail.com> wrote: > > > Hi, > > > > I am running a health check on our Informix 11.70 server. We are checking > > for things like making sure we are not reaching any limits e.g. max row > per > > fragment, max pages per fragment, any integer columns not reaching the > > limit. > > > > Just wondering, are there any health check scripts already out there that > > will help with this? > > > > Thank You, > > > > --Dave > > > > --047d7bfd0562424ccd04ec2bbacf > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e0116166082224b04ec3004fa > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c233eceb532e04ed4481f6
Hi, You can find OAT documentation in 'Context Help' - the '?' (question mark) button on the top right of any OAT page. This is context sensitive help for the OAT page you're clicking the '?' button from. There is additional documentation in the Help left navigation menu item. There is often useful information in the hover help (tooltip) of certain data. Regarding the CPU usage, a number greater than 100% would apply to systems with multiple CPUs. Also, in the OAT Group Summary dashboard, clicking on the table cell, gives a pop-up with more information. Regards, Sumanth. On Wed, Dec 11, 2013 at 8:13 AM, medkba <medkba@gmail.com> wrote: > is there any document to understand OAT configuration because cpu usage is > showing 489.00%. This is not unusual thing > > Thank you > > On Thu, Nov 28, 2013 at 6:21 AM, Sumanth Rajagopal <sumanth.r@gmail.com > >wrote: > > > The Health Advisor in OpenAdmin Tool (OAT) comes with several checks with > > the capability to modify some of the thresholds and also add new checks. > > > > More details are in this article: > > > > > > > http://www.ibm.com/developerworks/data/library/techarticle/dm-1303openadmin/ > > > > Regards, > > Sumanth. > > > > On Wed, Nov 27, 2013 at 9:14 AM, Informix DBA <in4mixdba@gmail.com> > wrote: > > > > > Hi, > > > > > > I am running a health check on our Informix 11.70 server. We are > checking > > > for things like making sure we are not reaching any limits e.g. max row > > per > > > fragment, max pages per fragment, any integer columns not reaching the > > > limit. > > > > > > Just wondering, are there any health check scripts already out there > that > > > will help with this? > > > > > > Thank You, > > > > > > --Dave > > > > > > --047d7bfd0562424ccd04ec2bbacf > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --089e0116166082224b04ec3004fa > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11c233eceb532e04ed4481f6 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7bd6adbcd0519a04ed5d1958
La informaci?n y archivos anexos contenidos en este mensaje pueden ser confidenciales y/o contener informaci?n legalmente privilegiada. Si usted no es destinatario del mismo: queda formalmente notificado que (i)cualquier divulgaci?n, distribuci?n, reproducci?n o copiado de esta comunicaci?n est? estrictamente prohibido y (ii) que no deber? tomar ninguna acci?n basada en este correo electr?nico o cualquier otra informaci?n incluida en ?l. Favor de notificar al remitente de inmediato mediante el reenv?o de este correo electr?nico y borrar a continuaci?n el mismo y sus anexos. Si ?ste mensaje est? dirigido a uno de los clientes de CIATEQ, A.C., cualquier opini?n o punto de vista contenidos en este correo electr?nico, est?n sujetos a los t?rminos y condiciones expresados en los correspondientes contratos firmados con CIATEQ, A.C."