Skip to Content
avatar image
Former Member

Sybase Control Center and SAP

Now that SAP is exerting control over the policies and procedures within Sybase, will Sybase Control Center be redesigned to be usable? I mean, it appears to be only partially implemented, provides no historical information, limited performance metrics, no ability to create reports, allows only one 'user' at a time, et cetera. I know in the past, a certain Sybase Partner had a temper tantrum when Sybase demonstrated SCC at TechWave. (I was in the room when one of the reps had the fit), so will SAP be able to push back and design/develop Sybase Control Center into something useful?

I'm asking here because there isn't a forum for SCC. 😔

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 05, 2013 at 11:28 PM

    Hi Jason, Sybase Control Center is now called SAP Control Center. And yes, there is a concerted effort being made in developing and improving this tool and making it a tool of choice for ASE, RS, IQ, HANA among other products.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 12, 2013 at 02:54 AM

    Hi Jason!

    I have deploy SCC in some non productive enviroments in a company a few months ago and the experience was succesful. It´s true that it has lots of rooms of improvements but nowadays its working pretty. In this instalation that I have mentioned you I have three jobs running every 30 minutes against this servers in order to colect performance statistics and alert me in case of a wrong metrics. The alarm system with mails and scalations its quite interesting, it depends the severity and the oldness of the warning you can send another email to another range or skill person.

    I create a few users, you can sincronize with an LDAP or create one locally. The process I didn´t remember but it wasn´t trivial, it was necessary to change one or two xml files.

    The only bad point I remember is that I couldn´t find the way to customize the heat chart, I don´t know if this changes but it was such a pitty.

    Regards Javier!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 14, 2013 at 11:42 AM

    Hi Jason,

    I am testing out SCC-3_2 right now and I have one major issue - the replication server' Monitor keeps shutting down because SQL Anyware Error - 685 Resource governor for 'prepared statements' exceeded'

    Do you know how to correct this? I guess I need to log unto SCC's SQL Anywhere (but how) or is there a config file I need to adjust?

    Your help would be greatly appreciated

    Regards

    Jola

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I've never got the chance to test it but to connect to the SCC's SQLAnywhere DB, I was advised to do the following:

      1) In SCC/SCC-3_2/services/SccSADataserver/service-config.xml it lists the SQL Anywhere port, I believe the default 3638.

      <set-property property="com.sybase.asa.server.port" value="3638" />

      2) Shutdown the SCC server, you will need to do this to change the SQL Anywhere password.

      3) Run "scc.sh --dbpassword" to change the dba password for the SCC repository DB. It will prompt you for the new dbs password and confirm it.

      http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01677.0310/doc/html/bth1254164074667.html

      4) This should start SCC with the new password, with the new password you should be able to access the SQL Anywhere SCC repository DB.

      isql -Udba -Pnew_password -Shostname:3638

      Hope this will help you.

      Vincent