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
Turns out, I had to change the OS level password inside the Docker container using passwd
command, and not through the DB2 provided mechanism