Unanswered: Connection authorization failure occurred. Reason: User ID revoked. ERRORCODE=-4214
Need help with a DB2 password reset problem on Windows 2012 R2.
When running changePassword from command line to change password for dirinst1 but this was unsuccessful. We then tried the steps below
click Start -> Administrative Tools -> Computer Management
Select Local Users and Groups -> Users
Right-click the DB2 user name and select Set Password and enter the new password information. Click OK.
Next, change the password information for DB2 services, as follows:
click Start -> Administrative Tools -> Computer Management --> Services
Right click and stop each DB2 application, or stop all DB2 applications by running the following command from a DB2 command line:
db2 force applications all
For each of the DB2 applications;
Right-click and select Properties then select the LogOn tab.
Enter the new password information and click OK.
Test this from db2 command line run the following commands
Then we restarted the sever and get the following error message and the account was showing as locked. Checked the logs and we have this error message now.
Connection authorization failure occurred. Reason: User ID revoked. ERRORCODE=-4214, SQLSTATE=28000
Are there any known recovery commands to run that will resolve this ?