search cancel

Separate WCC Shema from Autosys Schema

book

Article ID: 242596

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

Dear Support,

Please we would like to separate our current AutoSys DB schema from the WCC schema and use each separately.

At the moment, we are not doing that, but using the same schema for the WCC too.

Can you kindly guide us or send us documentation to implement this separate WCC schema.

Thanks.

Environment

Release : 12.0

Component : AutoSys Web UI

Resolution

Here is one approach:

1. Export your current WCC configuration and monitoring views/alerts to files:

wcc_config.sh -u <WCC Uid> -p <Password> -x output_file_config

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0-01/administrating/ca-wcc-administration/administer-the-configuration-batch-interface.html#concept.dita_834f26aa195a4f1412af52b2a8559253986a5b4b_ExportConfigurations

wcc_monitor.sh -u <WCC Uid> -p <Password> -x output_file_monitor

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0-01/administrating/ca-wcc-administration/administer-the-monitoring-batch-interface.html#concept.dita_1cf8c51366dab323e92bd8e02e000080a38650a7_PropagateViewandAlertPolicyDefinitionstoOtherServers

2. Use the AutoSys installer and select create schema to create a new schema for WebUI and WebUI Reporting.

3. Run wcc_config.sh to configure WCC to switch the schema:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0-01/administrating/ca-wcc-administration/administer-the-configuration-batch-interface.html#concept.dita_834f26aa195a4f1412af52b2a8559253986a5b4b_SpecifyaDifferentDatabase

4. Restart WCC and then import the configuration and monitoring views that are exported from step 1:

wcc_config.sh -u <WCC Uid> -p <Password> -i output_file_config

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0-01/administrating/ca-wcc-administration/administer-the-configuration-batch-interface.html#concept.dita_834f26aa195a4f1412af52b2a8559253986a5b4b_ImportConfigurations

wcc_monitor.sh -u <WCC Uid> -p <Password> -i output_file_monitor

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0-01/administrating/ca-wcc-administration/administer-the-monitoring-batch-interface.html#concept.dita_1cf8c51366dab323e92bd8e02e000080a38650a7_PropagateVie

Note: Step 4 can also be done by copying data from WCC tables in the original schema to the new schema.