AUTOSYS DATABASE PASSWORD REINITIALIZATION

Products

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

Issue/Introduction

The "autosys" user's password (autosys_secure) and the database password are out of sync. Is there a way to get them back in sync?

Environment

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component:

Resolution

The recommended solution for changing the "autosys" user's password is to use "autosys_secure".

If for whatever reason the password has been changed directly in the database or is no longer in sync with the database password, you can use the following steps to synchronize them

1. In your database, change the password for "autosys" user to "autosys".
   
   
2. Login to the database as the "autosys" user and run the following sql query:
   
   

   update ujo_alamode set str_val='aDc?C)D~FDFbH{h>' where type='password';

   
   
   
3. You should now be able to use autosys_secure to change the password to another string using "autosys" as the current password.