Re: Online log monitor

To Clay Irvings question Naomi Walker responds: >> >> > >> > I've often thought (that may be part of the problem!) that a nice utility >> > program (shellscript) would be something that reads the OnLine logs and >> > sends the db administrator email if anything other than "checkpoint >> > complete" and the usual hits the log. Has anyone written anything like >> > this? If not, what do you do? -- Look at your logs on a regular basis? >> > >> Actually yes. We use something called DBAmon which monitors the status of >> all online engines (currently over a dozen). It is not the most perfect >> thing in the world by any means (I wrote it) - but it does send you >> notifications or problems generally before they occur. > >We also wrote a Online error log grepper, that is fired off by cron each >night, and mails all exceptions to a "informix-guru" alias list. In >addition, we had cron jobs that update statistics, and run tbcheck -pT's >to check extents, and sends back a report on those that are over X number >of extents. We are setting up to automate everything possible, since we >expect to be responsible for a boatload of systems running informix in the >near future. >I would be interested in any tools, or ideas for tools that anyone can >dream up. Talking about extents, has anybody writen a program that takes a look at my existing tables and can recommend and extent size? _/ _/ _/_/_/ _/ _/ _/ _/ _/ _/_/_/ _/ _/ _/ _/ _/ _/ _/_/_/ _/_/_/ _/ _/ |-------------------------------| Jon Alder | WORK - jon@columbia.rain.com | Columbia Sportswear | HOME - jon@columbiasd.win.net | Portland, Oregon | Where ever you go... | 1-503-286-3676 x172 |-------------------------------|