0

Has anybody encountered this problem with a db2 server? I'm running a development database and connecting to the database gives me a password expired error. Trying to reset it will give me an invalid username/password error.

$ db2 connect to mydb user devuser using mypassword
SQL30082N  Security processing failed with reason "1" ("PASSWORD EXPIRED").  
SQLSTATE=08001
$ db2 connect to mydb user devuser using mypassword new newpasswd confirm newpasswd
SQL30083N  Attempt to change password for user id "devuser" failed with 
security reason "24" ("USERNAME AND/OR PASSWORD INVALID").  SQLSTATE=08001

Everything I've read says that I should reset the password but I can't due to the invalid username/password error.

I don't get this error when connecting using the db2 admin user.

2

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.5.0/com.ibm.db2.luw.admin.sec.doc/doc/c0021804.html

User authentication is completed by a security facility outside the Db2 database system, through an authentication security plug-in module. A default authentication security plug-in module that relies on operating-system-based authentication is included when you install the Db2 database system

If the reset password feature of the CLP is not working for you, you should reset the password directly on the operating-system at the server (or on the security system (e.g. LDAP) that Db2 has been configured to use)

|improve this answer|||||
  • Resetting the user's password at OS level worked. Thanks! I didn't realize that at first because I am able to log in to OS using the current password. But I guess I still had to reset it. This is a freshly installed DB2 by the way but the OS user already exists prior to DB2 installation. – donjay619 Oct 22 '19 at 0:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.