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 <user-c8222abeff59@xymon.invalid> 20/11/2005 11:01
Antwoord a.u.b. aan
user-ae9b8668bcde@xymon.invalid
Aan
user-ae9b8668bcde@xymon.invalid
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, user-3dbda8012344@xymon.invalid 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