How to reset dSeries schedmaster users password

Document ID : KB000093297
Last Modified Date : 28/04/2018
Show Technical Document Details
We are using the CA Workload Automation DE Desktop Client 12.0.02 version with Oracle database. We have lost the password for SCHEDMASTER user and we need to reset the password.
WA DE 12.0 SP2 on Linux + Oracle database
The solution is to run the following query by "sqlplus" to reset the password in the dseries database:

UPDATE ESP_USER set set PASSWORD='0XD8640B7B8CA7054760A21384795165A7' where DISPLAY_ID='SCHEDMASTER' ;

You will need to restart the DE Server for the modification to be taken into account by:

cd /ap01/CAWA/WorkloadAutomation_R12/bin
Now you can connect to Desktop Client as "SCHEDMASTER" user with the default password.