Separate WCC Shema from Autosys Schema

Products

• Autosys Workload Automation

Issue/Introduction

You would like to separate your current AutoSys DB schema from the WCC schema and use each separately.

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

You are looking for guidance or documentation you can send to implement this separate WCC schema.

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
   
   Export Configurations
   
   wcc_monitor.sh -u <WCC Uid> -p <Password> -x output_file_monitor
   
   Propagate View and Alert Policy Definitions to Other Servers
   
   
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:
   Specify a Different Database
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

Import Configurations
   
   wcc_monitor.sh -u <WCC Uid> -p <Password> -i output_file_monitor
   
   Administer the Monitoring Batch Interface
   
   Note: Step 4 can also be done by copying data from WCC tables in the original schema to the new schema.