Re: ON-Monitor Parameter?

In article <351A6292.1C7B@ws6391.gud.siemens.co.at>, Bernd Brantner <tt@ws6391.gud.siemens.co.at> wrote: > > Hi everybody > > My environment: > SINIX-Y 5.43 > INFORMIX-OnLine Version 7.24.UC3 > > I am programming a tool that analyzes information gathered by a UNIX > shell-script. > > My problem is to get information about databases using ON-Monitor. > I am wondering if there are command line parameters to write the output > of ON-Monitor into a file so that my shell-script can do the job. > > Can anybody tell me whether this is possible or give me alternatives to > get information about datebases and tables on commandline? > > Greetings, > > Bernd > You can either - use onstat, as another reply mentioned already, and analyse the output(s) - or query the SMI tables We tried both and had every sort of problems of beeing too slow or beeing inconsistent, i.e. our analysis scripts did not find consistent states of information in the SMI tables or we caused simply too much load on the systems by generating shared memory snapshots of > 30 MB using onstat ....... The only thing we did not play around was to run onperf & anlyse it's output We now use Platinum's EPM DBVision for INFORMIX which is pretty a solution. Give me a telephone call, if you like on Monday during business hours or e-mail me directly, I can pass you any sort of scripts & information We are running >100 SNI RM400/600 SINIX V5.43 & INFORMIX DSA 7.12 UC1 Regards Richard Kofler EDVg-debis Systemhaus GmbH & CoKG Vienna richard_kofler@edvg.co.at -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading