Database health
Deepak Joshi, new to Informix on IDS 7.3, asked how to check database health. Art Kagel recommended the ratios script and his performance tuning conference presentations, and explained that ratios (a Perl version) and his utils2_ak package are in the IIUG Software Repository, with presentations on the members-only pages. Answered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Can anybody help me to understand that how I can make sure and what the check should I perform to check of our Database health? We are running IDS version 7.3 Thx.
Get the ratios.ksh script. It calculates and prints out several metrics that will quickly give you an overview of the server's health. There's lots more to check, but that's a start. Go to the IIUG site or the Oninit web site and download my Performance Tuning presentations from past IIUG Conferences for more things to look at. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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 Thu, Sep 17, 2009 at 10:23 AM, DEEPAK JOSHI <djoshih@hotmail.com> wrote: > Can anybody help me to understand that how I can make sure and what the > check > should I perform to check of our Database health? We are running IDS > version > 7.3 > > Thx. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517478f98ae41000473c7f694
Thx, Recently I have added myself to IIUG. I am new to Informix,Can you please let me know where I can find your notes for DB health check? Secondly where I can find ratios.ksh script? Really appreciate your help on this.
Ah, the ratios.ksh is in the IIUG Software Repository (www.iiug.org/software or click on Software Repository in the menu along he left side of the IIUG Home page) along with many other tools for Informix DBAs and Developers. When you get there click the Repository Index tab at the top of the center frame and select Full Index then select 'R' in the alpha list at the top of the page. You will see ratios near the top at the left. This version is actually a PERL script, but it works (assuming you have Perl installed). If you don't send me an email directly and I'll send you a ksh version. You'll find the Conference Presentation materials on the Members Only pages, so you'll have to log in to see them. While you are in the repository, download my package, utils2_ak, it is one of the most useful in the Repository if I have to say so myself. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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 Thu, Sep 17, 2009 at 12:05 PM, DEEPAK JOSHI <djoshih@hotmail.com> wrote: > Thx, Recently I have added myself to IIUG. I am new to Informix,Can you > please > let me know where I can find your notes for DB > health check? Secondly where I can find ratios.ksh script? > > Really appreciate your help on this. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015173fe6c66324d60473c84c45