Sun Management Center v 3.x Database Question

Hi Alex,

> Is this database open.

Yes, and no.

Yes, in that Sun lets you export data from it using their tools (i.e. csv and tsv data dumps) and there is other info you can dump to XML...

...and no because you aren't legally allowed direct SQL access because of ther terms you agree to during the Server install (or anybody could download SunMC as a way to get a free commercial database to use)

> Also where can I find out about the database that

> SUNMC utilises.

It's designed to be "black box". Even routine maintenace like purging old data so the db doesn't get too large has been automated. When you install it (or look at it's process list, or file listing) you'll see it's an Oracle 8.1.7 database. It wasn't always Oracle (and I guess it could change in the future since Sun's shipping Postgres with Solaris now)... in fact in the 2.x series it used a different database called Raima.

> I have read through the installation

> / configuration guide, but it does speak about the

> actual database. Is it based on Oracle or something

> else. ?

For data export the best place to start would be the SunMC docs on docs.sun.com, specifically take a look at the data export options in PRM (Performance Reporting Manager) or accessible from the command line ("es-cli").

I'm not sure what you're trying to do (I'm guessing get at the stored performance metrics to draw your own graphs)... but if all you're trying to do is integrate SunMC alarms with another tool check out EventAction, and probably the Framework Adapter:

http://www.halcyoninc.com/products/EventAction/index.php

http://www.halcyoninc.com/products/Frameworks/index.php

http://www.halcyoninc.com/products/a-z.php

Regards,

Mike.Kirk@HalcyonInc.com

http://www.HalcyonInc.com

Aronek at 2007-7-6 20:19:04 >