issue with connecting to db6 database

[Former Member]

Hi Folks i have a strange issue where i am unable to connect to db6 database i get the below error.

4 ETW000  [     dev trc,00000]  *** ERROR in DB6Connect[dbdb6.c, 1806] CON = 0 (BEGIN)                    47  1.611662

4 ETW000  [     dev trc,00000]  &+     DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30082N  Security processing failed with reason "24" ("USERNAME

4 ETW000                                                                                                  45  1.611707

4 ETW000  [     dev trc,00000]  &+     AND/OR PASSWORD INVALID").  SQLSTATE=08001

4 ETW000                                                                                                  41  1.611748

4 ETW000  [     dev trc,00000]  &+

4 ETW000                                                                                                  40  1.611788

4 ETW000  [     dev trc,00000]  &+

4 ETW000                                                                                                4302  1.616090

4 ETW000  [     dev trc,00000]  &+

4 ETW000                                                                                                  56  1.616146

4 ETW000  [     dev trc,00000]  *** ERROR in DB6Connect[dbdb6.c, 1806] (END)                              30  1.616176

4 ETW000  [    dbdb6.c ,00000]  *** ERROR => DbSlConnect to 'SID' as 'sapr3' failed                    4172  1.620348

2EETW169 no connect possible: "DBMS = DB6                              --- DB2DBDFT = 'SID'"

dscdb6up -create "password with special characters" "password with special characters like ! "

Is this something that has been observed "DB2 v9.7.0.9"

I know that there is no restriction in 10.1 not sure about 9.7 whether exclamatory mark is allowed or not

IBM DB2 10.1 for Linux, UNIX, and Windows

[hugo_amo · Accepted solution]

Hi,

This is what IBM says about this reason code:

24 (USERNAME AND/OR PASSWORD INVALID)

The username specified, password specified, or both, are invalid. Some specific causes are:

1. If you have recently changed permissions on DB2 critical files such as db2ckpw or moved to a new Fixpak, the db2iupdt command which updates the instance might not have been run.
2. The username being used might be in an invalid format. For example, on UNIX and Linux platforms, usernames must be all be lowercase.
3. An error might have been made in specifying the catalog information. For example, the correct authentication type might not have been specified or, if applicable, the remote server might not have been cataloged on the local system. For more information on authentication, search the DB2 Information Center (http://publib.boulder.ibm.com/infocenter/db2luw/v9) using terms such as "authentication".

Also check the entries in table DBCON. You can check this in transaction DBCO, make sure that all the entries are correct.

Regards,

Hugo

[Former Member · Accepted solution]

Hi Hugo,

But the point is that when db2 connect to SID user <id> using <pwd> works then why is that i unable to connect to the host using r3trans.

ALso we have a distributed setup. where the database server resides on a different host.

[Former Member · Accepted solution]

From what i understand DBCON table is not used instead dscdb6.conf

[former_member188883 · Accepted solution]

Hi,

Please check below SAP note .

767448 - DB6: Authentication fails with SQL20082 RC=24

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Deepak,

The issue got fixed when i just gave the user name and not the password together.

Thanks all.