How to reset dSeries schedmaster users password

Document ID : KB000093297
Last Modified Date : 28/04/2018
Show Technical Document Details
Issue:
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.
 
Environment:
WA DE 12.0 SP2 on Linux + Oracle database
Resolution:
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
 
./stopServer
 
./startServer
 
Now you can connect to Desktop Client as "SCHEDMASTER" user with the default password.