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

[Darin McBride]

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

[Thiru]

Try this. This works if password is expired by OS.
connect to sample user db2inst1 using xxxx new xxxxx confirm xxxxxx

[Michael Reinfeld]

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.a tt.ne.jp> schrieb im Newsbeitrag
news:2e******** *************** **@posting.goog le.com...

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