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.