Hi all,

I am getting a weird problem,

I am trying to connect to local database. when I give the command
db2 connect to sample its able to connect but when i give the command with user id and password it fails to connect. I know the password is correct as I use it to login to my PC.
the output of db2set -all :
[e] DB2PATH=C:\Program Files\IBM\SQLLIB
[i] DB2_GRP_LOOKUP=DOMAIN
[i] DB2INSTPROF=C:\PROGRA~1\IBM\SQLLIB
[i] DB2COMM=TCPIP
[g] DB2_EXTSECURITY=YES
[g] DB2_DOCPORT=51000
[g] DB2_DOCHOST=localhost
[g] DB2SYSTEM=AZS0309A
[g] DB2PATH=C:\Program Files\IBM\SQLLIB
[g] DB2INSTDEF=DB2
[g] DB2ADMINSERVER=DB2DAS00


db2 connect to sample

Database Connection Information

Database server = DB2/NT 9.1.0
SQL authorization ID = AZS0309
Local database alias = SAMPLE


db2 connect to sample user azs0309 using singh123ajay

SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR
PASSWORD INVALID"). SQLSTATE=08001

just a guess
try using ..
db2 connect to sample user "azs0309" using "singh123ajay"

See if this discussion helps

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

Check if there are multiple entries for the userid azs0309 in /etc/security/passwd file. If there is only one entry you may wanna try bouncing the DBM