Thanks for the help with that Asif :-)

It did inform me that I should use GAUGE insted of DERIVE in plain simple english, unlike RRDtool's website imho.

I've tested it succesfully and I've changed my scripts to create a line on the informix graph for each possible DB Space. So now informix.rootdbs.rrd and informix.datadbs.rrd and lots of others are created and all have the dataset "percdbs" which represents data DB Space usage in a percentage.

I've adapted my informix section in hobbitgraph.cfg to the following: [informix] FNPATTERN informix.(.*).rrd TITLE Informix YAXIS Percentage in use DEF:p at RRDIDX@=@RRDFN@:percdbs:AVERAGE LINE2:p at RRDIDX#@COLOR@:Percentage in use @RRDPARAM@ -u 100 -l 0 GPRINT:p at RRDIDX@:LAST: \: %5.1lf (cur) GPRINT:p at RRDIDX@:MAX: \: %5.1lf (max) GPRINT:p at RRDIDX@:MIN: \: %5.1lf (min) GPRINT:p at RRDIDX@:AVERAGE: \: %5.1lf (avg)\n

But somehow the graph won't draw anything at all now.

rrdtool dump: <!-- Round Robin Database Dump --> <rrd> <version> 0001 </version> <step> 300 </step> <!-- Seconds --> <lastupdate> 1132571497 </lastupdate> <!-- 2005-11-21 12:11:37 CET -->

    <ds>
            <name> percdbs </name>
            <type> GAUGE </type>
            <minimal_heartbeat> 600 </minimal_heartbeat>
            <min> 0.0000000000e+00 </min>
            <max> NaN </max>

            <!-- PDP Status -->
            <last_ds> UNKN </last_ds>
            <value> 6.6000000000e+02 </value>
            <unknown_sec> 87 </unknown_sec>
    </ds>

<!-- Round Robin Archives --> <rra> <cf> AVERAGE </cf> <pdp_per_row> 1 </pdp_per_row> <!-- 300 seconds --> <xff> 5.0000000000e-01 </xff>

            <cdp_prep>
                    <ds><value> NaN </value>  <unknown_datapoints> 0 

</unknown_datapoints></ds> </cdp_prep> <database> <!-- 2005-11-19 12:15:00 CET / 1132398900 --> <row><v> NaN </v></row> ...

Asif Iqbal <iqbala-hobbit at qwestip.net> 20/11/2005 11:01 Antwoord a.u.b. aan hobbit at hswn.dk

Aan hobbit at hswn.dk Cc

Onderwerp Re: [hobbit] graph remains at zero rrd problem

Check this awesome 'howtograph' that Henrik just posted on his website

http://www.hswn.dk/~henrik/howtograph.txt

That might explain lot of your rrd issues.

On Fri, Nov 18, 2005 at 03:30:57PM, Tijl.VanDenBroeck at vlafo.be wrote:

Hello,

I've been adjusting the BB informix script to send informix info to hobbit, that works flawlessly. Next part is creating a graph with the usage of the DB Spaces to monitor evolution. In a first instance I want to avoid having trouble with a dynamic number of DB Spaces and I tried to create a graph that's pretty static and limited to two DB Spaces. Creating the RRD and so all seems to go fine but when I look at the graph, in the

legend it stays constantly at zero, it simply does not display the DBS usage number and it draws a line on the bottom of the X-axis.

version: hobbit-4.0.2 (yes I know, I still need to upgrade, maybe this is the issue itself?)

informix.sh creates the following output: DS:dbsusage1:DERIVE:600:0:100 DS:dbsusage2:DERIVE:600:0:100 informix.rrd 44:66

rrdtool info informix.rrd: filename = "informix.rrd" rrd_version = "0001" step = 300 last_update = 1132323804 ds[dbsusage1].type = "DERIVE" ds[dbsusage1].minimal_heartbeat = 600 ds[dbsusage1].min = 0.0000000000e+00 ds[dbsusage1].max = 1.0000000000e+02 ds[dbsusage1].last_ds = "44" ds[dbsusage1].value = 0.0000000000e+00 ds[dbsusage1].unknown_sec = 0 ds[dbsusage2].type = "DERIVE" ds[dbsusage2].minimal_heartbeat = 600 ds[dbsusage2].min = 0.0000000000e+00 ds[dbsusage2].max = 1.0000000000e+02 ds[dbsusage2].last_ds = "66" ds[dbsusage2].value = 0.0000000000e+00 ds[dbsusage2].unknown_sec = 0 rra[0].cf = "AVERAGE" rra[0].rows = 576 rra[0].pdp_per_row = 1 rra[0].xff = 5.0000000000e-01 rra[0].cdp_prep[0].value = NaN rra[0].cdp_prep[0].unknown_datapoints = 0 rra[0].cdp_prep[1].value = NaN rra[0].cdp_prep[1].unknown_datapoints = 0 rra[1].cf = "AVERAGE" rra[1].rows = 576 rra[1].pdp_per_row = 6 rra[1].xff = 5.0000000000e-01 rra[1].cdp_prep[0].value = 0.0000000000e+00 rra[1].cdp_prep[0].unknown_datapoints = 0 rra[1].cdp_prep[1].value = 0.0000000000e+00 rra[1].cdp_prep[1].unknown_datapoints = 0 rra[2].cf = "AVERAGE" rra[2].rows = 576 rra[2].pdp_per_row = 24 rra[2].xff = 5.0000000000e-01 rra[2].cdp_prep[0].value = 0.0000000000e+00 rra[2].cdp_prep[0].unknown_datapoints = 0 rra[2].cdp_prep[1].value = 0.0000000000e+00 rra[2].cdp_prep[1].unknown_datapoints = 0 rra[3].cf = "AVERAGE" rra[3].rows = 576 rra[3].pdp_per_row = 288 rra[3].xff = 5.0000000000e-01 rra[3].cdp_prep[0].value = 0.0000000000e+00 rra[3].cdp_prep[0].unknown_datapoints = 168 rra[3].cdp_prep[1].value = 0.0000000000e+00 rra[3].cdp_prep[1].unknown_datapoints = 168

hobbitgraph.cfg: [informix] TITLE Informix YAXIS Percentage in use DEF:dbspace1=informix.rrd:dbsusage1:AVERAGE DEF:dbspace2=informix.rrd:dbsusage2:AVERAGE LINE2:dbspace1#A0CC00:dbsusage1 LINE2:dbspace2#000CCC:dbsusage2 GPRINT:dbspace1:LAST: \: %5.1lf (cur) GPRINT:dbspace1:MAX: \: %5.1lf (max) GPRINT:dbspace1:MIN: \: %5.1lf (min) GPRINT:dbspace1:AVERAGE: \: %5.1lf (avg)\n GPRINT:dbspace2:LAST: \: %5.1lf (cur) GPRINT:dbspace2:MAX: \: %5.1lf (max) GPRINT:dbspace2:MIN: \: %5.1lf (min) GPRINT:dbspace2:AVERAGE: \: %5.1lf (avg)\n

I don't really see any error in the RRD file, nor in the output of my script or hobbitgraph.cfg. Ofcourse informix is added to hobbitlaunch.cfg in the extra tests and extra script parameters. Logs don't display anything weird neither.

Perhaps someone can help me with finding my error. Thanks in advance.

Tijl

-- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu "..there are two kinds of people: those who work and those who take the credit...try to be in the first group;...less competition there." - Indira Gandhi

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk