Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Sybase SQL Anywhere client

Created: 28 Feb 2013 • Updated: 02 Mar 2013 | 5 comments
This issue has been solved. See solution.

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. 

Operating Systems:

Comments 5 CommentsJump to latest comment

tom_sprouse's picture

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

OpsCenter 7.1 - database schema

https://www-secure.symantec.com/connect/forums/opscenter-71-database-schema

--Tom

Note: If this post provides you with a solution don't forget to mark the discussion as solved...

tom_sprouse's picture

Also, we apparently have a recent Technote for this:

How to setup a remote ODBC connection to the OpsCenter Analytics database

 

http://www.symantec.com/docs/TECH141827

Note: If this post provides you with a solution don't forget to mark the discussion as solved...

SOLUTION
TuxanForLife's picture

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.  ;)

tom_sprouse's picture

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

Note: If this post provides you with a solution don't forget to mark the discussion as solved...

TuxanForLife's picture

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.

AttachmentSize
SchemaSpy - vxpmdb_DBA - All Relationships.zip 1.68 MB