I'm trying to connect to a local database but keep getting errors that my password is wrong or invalid. I know it is a valid password that conforms to what DB2 expects:
SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
db2 connect to mydb user app1 using my_password
When I try to connect to the database using the above command, I get the SQL30082N error.
When I just enter db2 connect to mydb, it works!
Here are some of the settings of interest
Database manager authentication (AUTHENTICATION) = SERVER
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Trust all clients (TRUST_ALLCLNTS) = YES
The server is AIX.
What am I missing here?
I even tried enclosing the connect command in quotes.