Hi,

I am using db2 8.1 fixpak 4 on AIX 5.1. We had a problem with the db2 instance user because of too many unsuccessful logins. The user was locked. Now when i had the password reset on AIX. I am able to login to the box with db2 user, but i am getting the error when i try to connect to the existing database.
SQL30082N Attempt to establish connection failed with security reason "1"
Can anyone suggest any remedy on this.

The message reference for reason code 1 says:

1 (PASSWORD EXPIRED)
The password specified in the request has expired.

Please let me know ASAP.

Cheers,
Prashant

1. Please get the password for user db2inst1 reset again.

2. Then log on the AIX machine (the shell) - not! DB2

3. Change your password (you will be prompted to do this)

4. Exit the shell.

5. Log on to db2 (application or otherwise)

The shell usually demands a immediate change of password
after a reset. DB2 inherits password authentication from the
shell. I'm guessing it's a clash of these two processes that's
causing you trouble. Try the above and let me know if you're
in the clear.

BOW

That was great!! Thank's a lot!!!
It works.

cheers!!