RE: onstat(1) options, which one?

Medi THe answer is "It all depends upon what is important for your application" Over tha last couple of years for some of our clients I have regularly developed useful information for DBA purposes. One of the things *I* dont want is too much information to look through, as well as useful information. I have a database to record this information and a job that runs weekly to gather it from the SMI interface. I look at the output of onstat -d and onstat -t (eliminating small tables). I also email the last 500 or 1000lines of the messages log. Murray Wood -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Medi Montaseri Sent: Tuesday, January 18, 2000 1:00 PM To: informix-list@iiug.org Subject: onstat(1) options, which one? This is a multi-part message in MIME format. --------------E8410433CDF1B48F8B6485FB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I want to provide some general status information about an Informix engine. The result would be presented via HTML What options of onstat(1) should I use to give me the 80% coverage of all parameters. I also wanted to capture some of this data for trend analysis. Which parameters are more meaningful for trend analysis. Thanks -- --------------------------------------------------------- Medi Montaseri, Course Developer, 408-756-3154 --------------------------------------------------------- --------------E8410433CDF1B48F8B6485FB Content-Type: text/x-vcard; charset=us-ascii; name="medi.montaseri.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Medi Montaseri Content-Disposition: attachment; filename="medi.montaseri.vcf" begin:vcard n:Montaseri;Medi x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:medi.montaseri@lmco.com title:Course Developer x-mozilla-cpt:;0 fn:Medi Montaseri end:vcard --------------E8410433CDF1B48F8B6485FB--

Thanks....you understood my question well...how about Buffers, locks, and transactions? Murray Wood wrote: > Medi > > THe answer is "It all depends upon what is important for your application" > > Over tha last couple of years for some of our clients I have regularly > developed useful information for DBA purposes. One of the things *I* dont > want is too much information to look through, as well as useful information. > I have a database to record this information and a job that runs weekly to > gather it from the SMI interface. I look at the output of onstat -d and > onstat -t (eliminating small tables). I also email the last 500 or 1000> lines of the messages log. > > Murray Wood > > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Medi Montaseri > Sent: Tuesday, January 18, 2000 1:00 PM > To: informix-list@iiug.org > Subject: onstat(1) options, which one? > > This is a multi-part message in MIME format. > --------------E8410433CDF1B48F8B6485FB > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Hi, > > I want to provide some general status information about an Informix engine. > The result would be presented via HTML > What options of onstat(1) should I use to give me the 80% coverage of all > parameters. > > I also wanted to capture some of this data for trend analysis. Which > parameters > are more meaningful for trend analysis. > > Thanks > > -- > --------------------------------------------------------- > Medi Montaseri, Course Developer, 408-756-3154 > --------------------------------------------------------- > > --------------E8410433CDF1B48F8B6485FB > Content-Type: text/x-vcard; charset=us-ascii; > name="medi.montaseri.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for Medi Montaseri > Content-Disposition: attachment; > filename="medi.montaseri.vcf" > > begin:vcard > n:Montaseri;Medi > x-mozilla-html:FALSE > adr:;;;;;; > version:2.1 > email;internet:medi.montaseri@lmco.com > title:Course Developer > x-mozilla-cpt:;0 > fn:Medi Montaseri > end:vcard > > --------------E8410433CDF1B48F8B6485FB-- -- --------------------------------------------------------- Medi Montaseri, Course Developer, 408-756-3154 ---------------------------------------------------------