Search code examples
db2db2-luw

Error while changing password DB2 Community Edition SQL30083N


I had downloaded and installed DB2 community edition on my machine. I had supplied a password while installing DB2 for the instance db2inst1. At this moment, I'm able to connect to this DB2 database using the db2inst1 user and the supplied password, from DBeaver.

Now I am trying to update the password from command line using the command db2 "CONNECT TO HELLO USER db2inst1 USING <literally_that_same_password_used_earlier_in_dbeaver> NEW <new_password> CONFIRM <new_password>".

This unfortunately does not work, throwing me an error: SQL30083N Attempt to change password for user id "db2inst1" failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001.

I am sure that I am providing the same password as in DBeaver, when I try to change the password from terminal. I'm not sure why this is happening though.

I'm using DB2 Developer Community Edition (docker) on Mac


Solution

  • Turns out, I had to change the OS level password inside the Docker container using passwd command, and not through the DB2 provided mechanism