How to Connect WAAE to New Existing DB?

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

How can I point AutoSys to connect to a new/different DB?

Environment

Release: All Supported Versions
Component: Workload Automation AE (AutoSys Edition):

Resolution

1)  Stop ALL autosys services. 
       Note: If you are running HA, stop on Shadow as well.
2)  Unregister AutoSys from EEM.
3)  Revert AutoSys to use native security within autosys_secure.
4)  Navigate to the $AUTOUSER (Linux/Unix) or %AUTOUSER% (Windows)
5)  Create a backup of the config.$AUTOSERV (Linux/Unix) or config.%AUTOSERV% (Windows) file.
      Note: $AUTOSERV|%AUTOSERV is your 3 character AutoSys instance
6)  Open the config.$AUTOSERV (Linux/Unix) for editing.
7)  Locate the Event_Server_1 and Event_Server_2 (if applicable) parameters.
      Note: EventServer_2 will only exist if you are using dual database configuration. See the notes in the config file for further details, or review the EventServer_1 and EventServer_2 documentation.
        EventServer_1=ORACLE_SVR1,DBPORT,DBHOST 
        EventServer_2=ORACLE_SVR2,DBPORT,DBHOST 
8)  Update the Event_Server_1 and Event_Server_2 (if applicable) parameters to reflect your new DB details.
9)  Save the file
10) Repeat Steps 4 - 9 on Shadow if applicable.
      Note: You do not need to repeat for Tie-Breaker
11) On Primary, run the RefreshAEDB.pl script. This will point AutoSys to new DB.
      Note: This only needs to be performed once on the Primary scheduler machine. Do not repeat on Shadow! 
12) Launch autosys_secure again and switch from native-security back to EEM security.