02-28-2013 09:49 PM
Has anyone tried to install a Sybase SQL Anywhere client and query the Ops Center database directly?
I have Ops Center with Analytics so I can run an SQL query from Ops Center, but I'd like to have a better interface for writing the queries. Once they're generating the data I want to see, I can copy the SQL to Ops Center and have it generate the pretty graphs, tables and charts.
I imagine that it's not supported. And that it's dangerous - you can blow things up if you modify the schemas etc.
But is it possible? Is there a better way to do the same thing?
Similarly, has anyone taken the XML files that seem to describe the database and run them through a database visualizer program? If so, which one do you recommend? I'm looking to see if "XML viewer" or "GraphViz" can do it.
Solved! Go to Solution.
03-01-2013 03:33 PM
Also, we apparently have a recent Technote for this:
http://www.symantec.com/docs/TECH141827
03-01-2013 03:30 PM
Yes, Tuxan, you can use Sybase Tools to access the database directly.
Is it offically supported, no, and corrupting your database is a possiblity.
With that being said, if you wish to perform this action, please look for your server.conf file under /opscenter/server/db/conf
You must modify the LocalOnly entry to = NO instead of YES
Then use sybase to open the ODBC connection to the OpsCenter host using server
OPSCENTER_hostname
Also, if you want to create a schema, please look at this Forum post....I have used it, and it has worked in the past. I have not tried 7.5
https://www-secure.symantec.com/connect/forums/opscenter-71-database-schema
--Tom
03-01-2013 03:33 PM
Also, we apparently have a recent Technote for this:
http://www.symantec.com/docs/TECH141827
03-02-2013 05:42 AM
Thank you, Tom. I'm excited to try.
Step One - Verify the OpsCenter box is being backed up correctly. Otherwise - talk about ironic egg on one's face. ;)
03-02-2013 06:29 AM
Tuxan,
Correct, ensure you have daily dbbackup's of the database, as a regular file system backup will not capture the database files.
For information on that, please refer to Backing Up the OpsCenter Database
http://www.symantec.com/docs/HOWTO42869
03-12-2013 01:57 AM
I used SchemaSpy to dump all tables in our Ops Center 7.5 instance into a big multi-tabbed webpage.
The attached file shows the tables, fields (including data types) and inter-table relationships - greatly simplifies writing reports.
Four or five table graphics didn't render nicely (and we have some tables used for migration leftover), but the data is still good.
Also, I saw some posts asking about database size and retention period. We believe that we maintain 730 days history in an environment that runs - 450k jobs in under 10GB of diskspace.