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

• 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

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