473,387 Members | 1,535 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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 22710
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

43
by: steve | last post by:
I am quite frustrated with php’s include, as I have spent a ton of time on it already... anyone can tell me why it was designed like this (or something I don’t get)? The path in include is...
3
by: Praveen_db2 | last post by:
Hi All db2 version 8.2.2 Windows I have installed the database and created Sample db. Now when I am giving db2stop ,it says C:\Documents and Settings\buntyaru>db2stop 11/10/2005 00:13:14 ...
11
by: Antony | last post by:
I know this sounds stupid but I am going to carry on anyway. I want to create an interface that implements all methods of a form, plus another one or two. But I need to know if there is an...
3
by: Dave | last post by:
I've run across a strange error when creating a simple ADO.Net connection in VB.Net 2003 To replicate an error: Create an Access database (2002) with table named "Student" and fields SID...
1
by: laredotornado | last post by:
Hi, I'm using PHP 4.4.4 on Apache 2 on Fedora Core 5. PHP was installed using Apache's apxs and the php library was installed to /usr/local/php. However, when I set my "error_reporting"...
14
by: Nader Emami | last post by:
I have installed "TurboGears" and I would install 'pysqlite' also. I am a user on a Linux machine. If I try to install the 'pysqlite' with 'easy_install' tool I get the next error message. The...
350
by: Lloyd Bonafide | last post by:
I followed a link to James Kanze's web site in another thread and was surprised to read this comment by a link to a GC: "I can't imagine writing C++ without it" How many of you c.l.c++'ers use...
2
by: lai.love.chen | last post by:
I encounted this error when i restored database. but the usename and password is right.
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.