Separate WCC Shema from Autosys Schema
search cancel

Separate WCC Shema from Autosys Schema

book

Article ID: 242596

calendar_today

Updated On:

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.