469,927 Members | 1,910 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

SQL30082N Attempt to establish connection failed with security reason "24"

It is found that a DB is setup for sometime.

One day, the user suddenly cannot connect to DB.
We found that the case is as follow:

1. User can connect to DB by issuing command

db2 connect to <DB>

2. However, when the user connect to DB by using

db2 connect to <DBuser <user id>
Enter current password for pws01ua1:

and will go following error.

SQL30082N Attempt to establish connection failed with
security reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

We have checked that the password is not expired and the account is not
locked by the system. So, we are not sure about the solution.

Our system information is as follow:

Platform: AIX 5.3
DB Version: 8.2 FP 3

Thanks

Jul 14 '06 #1
1 22482
This is known problem when using DB2 8.2 and AIX5.3
(don't know if already fixed in newer fix packs)
If you use this db2set setting and restart the instance the problem is
"solved":
db2set DB2_NUM_CKPW_DAEMONS=0

Knokmans
<ed**********@gmail.comwrote in message
news:11**********************@s13g2000cwa.googlegr oups.com...
It is found that a DB is setup for sometime.

One day, the user suddenly cannot connect to DB.
We found that the case is as follow:

1. User can connect to DB by issuing command

db2 connect to <DB>

2. However, when the user connect to DB by using

db2 connect to <DBuser <user id>
Enter current password for pws01ua1:

and will go following error.

SQL30082N Attempt to establish connection failed with
security reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

We have checked that the password is not expired and the account is not
locked by the system. So, we are not sure about the solution.

Our system information is as follow:

Platform: AIX 5.3
DB Version: 8.2 FP 3

Thanks

Jul 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

43 posts views Thread by steve | last post: by
3 posts views Thread by Praveen_db2 | last post: by
11 posts views Thread by Antony | last post: by
14 posts views Thread by Nader Emami | last post: by
350 posts views Thread by Lloyd Bonafide | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.