SAP Knowledge Base Article - Preview

3247999 - DB6: SQL30082N with reason "24" due to PAM configuration

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 81

     Data1  (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/db2

    40942 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...

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.