AutoSys Workload Automation

Tech Tip: Updating/Modifying the Database Passwords for CA Workload Automation AE

  • 1.  Tech Tip: Updating/Modifying the Database Passwords for CA Workload Automation AE

    Broadcom Employee
    Posted 11-03-2015 09:20 AM

    Below are the steps to update the database user passwords for Embedded Entitlements Manager (EEM), Workload Automation AE (Autosys), and Workload Control Center (WCC).

     

    NOTE: The steps provided are under the assumption that users 'aedbadmin' and 'autosys' are being used strictly with Autosys and are in no way associated with WCC.

     

    ------------------------------------------------

    Changing the password for the EEM Database User

    ------------------------------------------------

    Because EEM governs its own database internally, there is nothing you need to do with this application.

     

    ------------------------------------------------

    Changing the password for 'aedbadmin'

    ------------------------------------------------

    After your DBA has updated the password for 'aedbadmin', there is nothing else you need to do with this user.

     

    ------------------------------------------------

    Changing the password for 'autosys' - SINGLE SERVER MODE

    ------------------------------------------------

    1. Stop the scheduler

    2. From a command prompt, run this command: autosys_secure

    3. Select [3] Change database password.

      A. Enter the current password

      B. Enter the new password

      C. Confirm the new password

    4. Start the scheduler

    5. Using the chk_auto_up command, confirm you can connect to the database

    NOTE: The DBAccess parameter (DBAccess=autosys/ABCDEF0123456789) in your config.$AUTOSERV file (or config.%AUTOSERV% file) will be automatically updated with the new encrypted password.

     

    ------------------------------------------------

    Changing the password for 'autosys' - DUAL SERVER MODE

    ------------------------------------------------

    1. Stop the primary and shadow schedulers

    2. From a command prompt on the primary scheduler, run this command: autosys_secure

    3. Select [3] Change database password.

      A. Enter the current password

      B. Enter the new password

      C. Confirm the new password

    4. Start the primary scheduler - using the chk_auto_up command, confirm you can connect to the database

    5. Start the shadow scheduler

    NOTE: The DBAccess parameter (DBAccess=autosys/ABCDEF0123456789) in your config.$AUTOSERV file (or config.%AUTOSERV% file) will be automatically updated with the new encrypted password.


    ------------------------------------------------

    Changing the password for the WCC Database User

    ------------------------------------------------

    1. From a command prompt, navigate to your $CA_WCC_INSTALL_LOCATION/bin directory (or %CA_WCC_INSTALL_LOCATION%\bin directory)

    2. (Linux) Run this command: ./wcc_config.sh -u user_name -p password --dbuser db_user --dbpassword db_password

        (Windows) Run this command: wcc_config -u user_name -p password --dbuser db_user --dbpassword db_password

     

    user_name: a user who can log into WCC

    password: the password for the user who can log into WCC

    db_user: the name of the WCC DB user

    db_password: the password for the WCC DB user

     

    3. (Linux) Run this command: ./wcc_config.sh -u user_name -p password --dbuser db_user --dbpassword db_password --dbapp REPORTING

        (Windows) Run this command: wcc_config -u user_name -p password --dbuser db_user --dbpassword db_password --dbapp REPORTING


    NOTE: You must run this command twice: once without the --dbapp parameter and again with the --dbapp parameter.