HOW to feed any relation database querys to cacti

[hq5535]

Hi everyone,

I am new to here.
I am not sure if the question has been asked before:
We have some statics data save in database(DB2).
As simple as possible, the data are saved in 2 columns(dimensions), one is time, one is value.

ANyone know how to feed that query into cacti.
example, the table are for transaction counts per hour, so column A is time, column B is transaction counts,
"select columnA,columnB from table1"
Any suggestions?

Thanks a Lot!

[rony]

You have to write a script to get the data.