Importatnt Consideration:Changing the access password should be done in two tiers and clear cache after it
App server and Process Scheduler are down.
Do while all users are logged off.
Recommended method in chronological order
Change the Access ID Password at database level first.
You can either run the SQL statement in your SQL tool
update PSACCESSPRFL set ACCESSID = 'what your Access ID is' , ACCESSPSWD = 'your New Access Password' , ENCRYPTED = 0 where SYMBOLICID = 'whatever the SYMBOLICID is';
Then run the following command in DataMover
ENCRYPT_PASSWORD *;
App server and Process Scheduler are down.
Do while all users are logged off.
Recommended method in chronological order
METHOD # 1
METHOD # 2 ( I always use this)- Log into DataMover as the Access ID (Bootstrap mode).
- CHANGE_ACCESS_PASSWORD sa1 (This is your symbolic ID) yournewpassword (This is the new password for the Access ID) ;
Change the Access ID Password at database level first.
You can either run the SQL statement in your SQL tool
update PSACCESSPRFL set ACCESSID = 'what your Access ID is' , ACCESSPSWD = 'your New Access Password' , ENCRYPTED = 0 where SYMBOLICID = 'whatever the SYMBOLICID is';
Then run the following command in DataMover
ENCRYPT_PASSWORD *;
METHOD # 3 ( Dont Do it)
- Log into Application Designer and navigate to Tools > Miscellaneous Objects> Access Profiles.
- Highlight the Symbolic ID and push the Edit button, enter the old password, new password, and confirm new password.
