469,927 Members | 1,873 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.

DB2 error using the command with USERID/PASSWORD

NK
Hello,

I am a beginner of DB2 and I am in a trouble that I can't access to
sample database.
Please see below.

ENV : OS AIX-5.2/ DB2 8.1.2

SYMPTOM:
I don't have any DB2 client terminal so far and all the troubles
below are happening on the
AIX 5.2 platform.

When you login to AIX with userid "db2inst1", and try to connect
the sample database
called "sample" which DB2 normally sets up on the system using the
command like,
db2 connect to sample user db2inst1 using xxxxx
I can't access to sample database. The error message is,

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

But instead of the command above, the next one is possible to access
to the sample database,
db2 connect to sample


Why can't I specify the userid and password? What I want to do is
to access the database
using the command with userid/password.

Thanks in advance,
N
Nov 12 '05 #1
3 14191
NK wrote:
Hello,

I am a beginner of DB2 and I am in a trouble that I can't access to
sample database.
Please see below.

ENV : OS AIX-5.2/ DB2 8.1.2

SYMPTOM:
I don't have any DB2 client terminal so far and all the troubles
below are happening on the
AIX 5.2 platform.

When you login to AIX with userid "db2inst1", and try to connect
the sample database
called "sample" which DB2 normally sets up on the system using the
command like,
> db2 connect to sample user db2inst1 using xxxxx
I can't access to sample database. The error message is,

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


Generally speaking, this would be because "xxxxx" isn't actually the
password for the user "db2inst1". (Yes, I realise you're just x-ing
out the password.) On AIX, this could even be because the password is
expired by the operating system. Try using telnet to log in to the AIX
machine as db2inst1 with that password - I would expect that either the
password would fail, or it would immediately ask for a new password
after you log in. Using that new password, retry your connection to
DB2.
But instead of the command above, the next one is possible to access
to the sample database,
> db2 connect to sample


Why can't I specify the userid and password? What I want to do is
to access the database
using the command with userid/password.

Thanks in advance,
N

Nov 12 '05 #2
Try this. This works if password is expired by OS.
connect to sample user db2inst1 using xxxx new xxxxx confirm xxxxxx

Nov 12 '05 #3
Hi,
perhaps you have lost the SUID and GUID bits in ../sqllib/adm.
Create a new instance and compare the module attributes with the previous.

"NK" <nk******@zap.att.ne.jp> schrieb im Newsbeitrag
news:2e*************************@posting.google.co m...
Hello,

I am a beginner of DB2 and I am in a trouble that I can't access to
sample database.
Please see below.

ENV : OS AIX-5.2/ DB2 8.1.2

SYMPTOM:
I don't have any DB2 client terminal so far and all the troubles
below are happening on the
AIX 5.2 platform.

When you login to AIX with userid "db2inst1", and try to connect
the sample database
called "sample" which DB2 normally sets up on the system using the
command like,
> db2 connect to sample user db2inst1 using xxxxx


I can't access to sample database. The error message is,

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

But instead of the command above, the next one is possible to access
to the sample database,
> db2 connect to sample


Why can't I specify the userid and password? What I want to do is
to access the database
using the command with userid/password.

Thanks in advance,
N

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Phil Powell | last post: by
13 posts views Thread by Edward Mitchell | last post: by
3 posts views Thread by Adriano | last post: by
3 posts views Thread by Sangeetha Nagaraj | last post: by
12 posts views Thread by Michael | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.