Re: disk space trending into table....

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Mon, 24 Jul 2006 20:35:06 GMT
Message-ID: <J2xD6s.DwB@igsrsparc2.er.usgs.gov>

Mladen Gogala wrote:
> On Sun, 23 Jul 2006 16:57:08 +0000, Brian Peasland wrote:
>

>> sql = "INSERT INTO infoctr.df_temp VALUES (?)";

>
> I'm not a Java programmer, but am I correct in interpreting your code in
> such a way that the whole output of "df -k" is inserted into the database,
> line by line? Your insert has only a single value. If my interpretation
> of your code is correct, how useful is that for trending?
>

Yes, it inserts the output from "df -k" into a table one line at a time. My code gets you started on that. You'll have to parse the lines into something more meaningful. I just got you started....writing a parser is a piece of cake, which I'm sure you can write to extend what I have already provided!!! ;) In fact, I have written a parser to do that myself, but my parser (which I did not include) is site specific for my installation. I'm not sure it would work well for anyone else, so I did not include it.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Mon Jul 24 2006 - 15:35:06 CDT