Help with graphing

Vernon Everett v.everett at afgonline.com.au
Fri May 6 08:45:29 CEST 2005


Hi all

Any help appreciated here.

I was trying to create a custom graph of database tablespace
utilization.
I was getting some input from the clients, which my external script was
eventually reducing to this.
---snip---
DS:siebprod.XDB:GAUGE:600:0:100
DS:siebprod.WHS_INDEX:GAUGE:600:0:100
DS:siebprod.WHS_DATA:GAUGE:600:0:100
DS:siebprod.USERS:GAUGE:600:0:100
DS:siebprod.UNDOTBS1:GAUGE:600:0:100
DS:siebprod.TOOLS:GAUGE:600:0:100
DS:siebprod.SYSTEM:GAUGE:600:0:100
DS:siebprod.SIEB_INDEX:GAUGE:600:0:100
DS:siebprod.SIEB_DATA:GAUGE:600:0:100
DS:siebprod.LOADER_DATA:GAUGE:600:0:100
tablespace.rrd
0:71:78:1:26:66:69:81:84:0 
---snip---

No worries so far, except no .rrd file was created.
I checked the logs, and found 
---snip---
2005-05-06 11:36:30 RRD error creating
/var/lib/hobbit/rrd/aufin2/tablespace.rrd: can't parse argument
'DS:siebprod.XDB:GAUGE:600:0:100'
---snip---
It was getting stuck on the first row.

On a hunch, I changed the output from database.tablename to
database_tablename, so my output looked like this.
---snip---
DS:siebprod_XDB:GAUGE:600:0:100
DS:siebprod_WHS_INDEX:GAUGE:600:0:100
DS:siebprod_WHS_DATA:GAUGE:600:0:100
DS:siebprod_USERS:GAUGE:600:0:100
DS:siebprod_UNDOTBS1:GAUGE:600:0:100
DS:siebprod_TOOLS:GAUGE:600:0:100
DS:siebprod_SYSTEM:GAUGE:600:0:100
DS:siebprod_SIEB_INDEX:GAUGE:600:0:100
DS:siebprod_SIEB_DATA:GAUGE:600:0:100
DS:siebprod_LOADER_DATA:GAUGE:600:0:100
tablespace.rrd
0:71:78:1:26:66:69:81:84:0 
---snip---

Still nothing in the .rrd file, but the logs now showed this.

---snip---
2005-05-06 12:01:30 RRD error creating
/var/lib/hobbit/rrd/aufin2/tablespace.rrd: can't parse argument
'DS:siebprod_LOADER_DATA:GAUGE:600:0:100'
---snip---

The last line!
I thought stuff-it, I can do without the last line, and took it out with
a grep -v
All of a sudden, I had my tablespace.rrd Woohoo!

I left it for an hour, and came back from lunch hoping to find a lovely
graph.
No dice. 

All I get is a link to a graph, and the link gives me 4 (empty) links to
the history graphs. No graphs appeared.

My hobbitgraph.cfg entry for this looks like this.

---snip---
[ora9-sga]
        FNPATTERN tablespace(.*).rrd
        TITLE TableSpace Utilization
        YAXIS % Full
        DEF:p at RRDIDX@=@RRDFN@:pct:AVERAGE
        LINE2:p at RRDIDX@#@COLOR@:@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

---snip---

and the hobbitserver.cfg looks like this

---snip---
LARRDS="cpu=la,disk,inode,qtree,memory,ora9-sga,vmio,$PINGCOLUMN=tcp,htt
p=tcp,dns=tcp,dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperature,apa
che,bind,sendmail,nmailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy
,hobbitd"

GRAPHS="la,disk,inode,qtree,memory,users,vmstat,iostat,tcp.http,tcp,nets
tat,mrtg::1,temperature,ntpstat,apache,bind,sendmail,nmailq,socks,bea,ii
shealth,citrix,bbgen,bbtest,bbproxy,hobbitd,ora9-sga,vmio"
---snip---

What am I missing?

Right now I will settle for any advice that will get the graphs to
display.
However I am curious about the "couldn't parse" logs.
Any ideas?

Cheers
    Vernon
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

NOTICE: This message and any attachments are confidential and may contain copyright material 
of Australian Finance Group Limited or a third party. It is intended solely for the purpose of the 
addressee and any other named recipient. If you are not the intended recipient, any use, 
distribution, disclosure or copying of this message is strictly prohibited. The confidentiality attached 
to this message is not waived or lost by reason of the mistaken transmission or delivery to any 
unintended party. If you have received this message in error, please notify the author immediately 
or contact Australian Finance Group on +61 8 9420 7888.




More information about the Xymon mailing list