Workload Automation1

Expand all | Collapse all

Workload Automation WCC Database Migration

Jump to Best Answer
  • 1.  Workload Automation WCC Database Migration

    Posted 06-25-2018 01:41 PM

    We currently have the WCC database for r11.3 on a legacy Windows server and looked for documentation on how to migrate the WCC database but haven't found anything helpful.

     

    We located in Workload Control Center\data\config\application\config\resources the connection.properties file that references the wcc.database.host=<legacy sever name>\\WA.

     

    At the top of the file it shows 

    # NOTE:
    # NOTE: Changes to this file does not take affect until imported into
    # NOTE: WCC Configuration.
    # NOTE:

    But this file has a lot of encrypted strings so just changing the server name to the new server and instance seems like issues would occur when importing into the WCC Configuration.

     

    Is there documentation on this process that I am just unable to locate?

     

    Thanks,

    Calip



  • 2.  Re: Workload Automation WCC Database Migration

    Posted 06-25-2018 08:50 PM

    Hi Calip,

     

    You'd need to make use of the WCC Configuration Batch Interface to make the switch:

    https://docops.ca.com/ca-workload-automation-ae/11-4-2/en/administrating/ca-wcc-administration/administer-the-configurat… 

     

    Thanks & Regards,

    Chandru



  • 3.  Re: Workload Automation WCC Database Migration

    Posted 06-26-2018 02:58 AM

    Hi Calip

     

    If the question is about moving the internal WCC database (Derby) to SQL:

    How to move from Derby to MS-SQL database for CA W - CA Knowledge 

     

    Steps for Oracle including usage of wcc_monitor and wcc_config utilities

    How To Convert a WCC 11.3.x DB to Oracle - CA Knowledge 

     

    Regards

    Jean Paul



  • 4.  Re: Workload Automation WCC Database Migration

     
    Posted 06-27-2018 10:28 AM

    Hello,

     

    WCC can be upgraded in place only if the one in place is 11.3.5 or higher.
    So one could go from 11.3.5 to 11.3.6 or 11.4 sp1. But if you are at WCC 11.3 ,

    then unfortunately there is no upgrade in place option available.

    For more detail please take a look at:

    https://docops.ca.com/ca-workload-automation-ae/11-4-2/en/upgrading/ca-wcc-upgrade

     

    You will need to uninstall the current version of WCC before installing the newest version.

    Prior to uninstalling r11.3, it is recommended to:

    Export your monitoring objects (includes views, filters and alerts)

    Migrate Job Monitoring Objects

    Migrate Job status Console Objects

    Migrate Monitoring Views

     

    Export your configurations (includes AE instance definition and application preferences)

     

    You can get some information from the following TecDoc

     

    https://comm.support.ca.com/kb/how-to-rebuild-the-derby-database-for-workload-control-center-r113-sp1/kb000010250

     

    I hope these information suits your need,

     

    Thanks and warm regards,

     

    Faouzia



  • 5.  Re: Workload Automation WCC Database Migration

    Posted 06-27-2018 10:49 AM

    Hi Faouzia, we are not looking to "upgrade" as this is a legacy automation tool for us and no new jobs are being added.

     

    Chandru.Venkataraman in your response you have the link for 11.4.2 documentation. I see the wcc_config.bat file to use on our WCC server. Should the commands on the specific link below also work in 11.3?

     

    https://docops.ca.com/ca-workload-automation-ae/11-4-2/en/administrating/ca-wcc-administration/administer-the-configuration-batch-interface#AdministertheConfigurationBatchInterface-SpecifyaDifferentDatabase

     

    Thanks for the relies!



  • 6.  Re: Workload Automation WCC Database Migration

    Posted 07-01-2018 02:52 AM

    WCC 11.3 batch config utility did not provide the ability to change database details. I am jogging my memory how we updated database passwords back then. I'll get back with details next week.



  • 7.  Re: Workload Automation WCC Database Migration
    Best Answer

    Posted 07-05-2018 01:15 AM

    Hi Calip,

    Unfortunately WCC 11.3 does not provide an option to change database details after installation.

    Thanks,

    Chandru