Troubleshooting
Problem
Linux Redhat 6 with SSSD (System Security Service Daemon) has problem working with DB2 Transparent LDAP
Symptom
LDAP user fails to connect to DB2 database with error SQL30082N rc=24
Cause
There is a defect in Redhat 6 SSSD that would cause such an issue with DB2 Transparent LDAP.
Environment
Linux Redhat 6
Diagnosing The Problem
db2diag.log messages shows user password expired even when correct or incorrect password is used:
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 65 bytes
Password validation for user mgrice failed with rc = -2146500508
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30082 sqlerrml: 19
sqlerrmc: 1 PASSWORD EXPIRED
sqlerrp : SQLEXSMC
sqlerrd : (1) 0x80370064 (2) 0x00000064 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000004
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 08001
Resolving The Problem
Upgrade Redhat 6 to Redhat 6.2 where the defect is fixed.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21588633