By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

DB2 error using the command with USERID/PASSWORD

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.