Symptom
- The command: db2 connect to <dbname> user sap<sid> using <password>
failed with following error although the password is correct.
SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR
PASSWORD INVALID"). SQLSTATE=08001 - The following Warning can be found in the db2diag.log
2022-09-14-16.37.39.459968+120 I652426E463 LEVEL: Warning
PID : 6954 TID : 140103338944256 PROC : db2sysc 0
INSTANCE: db2xxx NODE : 000 DB : XXX
APPHDL : 0-315
HOSTNAME: xxxxxxxx
EDUID : 162 EDUNAME: db2agent (XXX) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 65 bytes
Password validation for user xxxxxx failed with rc = -2146500507 - You take the trace as following:
- db2trc on -t -f trace.dmp
- db2 connect to <dbname> user sap<sid> using <password>
- db2trc off
- db2trc fmt trace.dmp trace.fmt
- db2trc flw -t trace.dmp trace.flw
- db2trc fmt -c trace.dmp trace.fmtc
and find the following entries in the trace.fmt:
40941 data DB2 UDB oper system services sqloPamAuthentication fnc (3.3.15.1819.0.6506)
pid 16283 tid 140145571391232 cpid -1 node 0 sec 25 nsec 498029000 probe 6506
bytes 81Data1 (PD_TYPE_DEFAULT,73) Hexdump:
5041 4D20 6D61 7920 6E6F 7420 6265 2063 PAM may not be c
6F6E 6669 6775 7265 6420 7072 6F70 6572 onfigured proper
6C79 2066 6F72 2044 4232 2E20 436F 756C ly for DB2. Coul
6420 6E6F 7420 6669 6E64 202F 6574 632F d not find /etc/
7061 6D2E 642F 6462 32 pam.d/db240942 exit DB2 UDB oper system services sqloPamAuthentication fnc (2.3.15.1819.0)
pid 16283 tid 140145571391232 cpid -1 node 0 sec 25 nsec 498480000
rc = 0x800F0065 = -2146500507 = SQLO_BAD_PSW
Read more...
Product
Keywords
SQL30082N, Security processing failed with reason "24", rc = -2146500507, /etc/pam.d/db2, SQLO_BAD_PSW, LDAP , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.