IBM Support

Explicitly connect to database failed with SQL30082n rc=24. (Security method "PDOS" could not be loaded)

Troubleshooting


Problem

In a newly installed db2 instance and new database, explicitly connect to database failed with SQL30082n rc=24.
 

Symptom

Following error reported in db2diag.log
2020-07-02-13.15.36.063256+480 I2029A485            LEVEL: Severe
PID     : 20381782             TID : 258            PROC : db2ckpwd 0
INSTANCE: isimdb2              NODE : 000
HOSTNAME: TAMOSTEST
EDUID   : 258                  EDUNAME: db2wdog 0 [isimdb2]
FUNCTION: DB2 UDB, oper system services, sqloSpawnAndWaitForPasswordCheckExe, probe:130
MESSAGE : ZRC=0x800F006A=-2146500502=SQLO_BAD_USER "Bad User"
          DIA8117C Error with userid "".
DATA #1 : signed integer, 4 bytes
2
2020-07-02-13.15.36.065236+480 I2515A465            LEVEL: Warning
PID     : 15139046             TID : 12084          PROC : db2sysc 0
INSTANCE: isimdb2              NODE : 000           DB   : ISIMDB
APPHDL  : 0-50
HOSTNAME: TAMOSTEST
EDUID   : 12084                EDUNAME: db2agent (ISIMDB) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20

Cause

Reviewed db2trace and found entries as below
5619    SYSTEM ERROR DB2 UDB oper system services sqloGetUserPasswordInformationInternal fnc (5.3.15.1254.0.120)
    pid 7209062 tid 258 cpid -1 node 0 sec 10 nsec 168325503 probe 120
    Error  ZRC = 0xFFFFFFFF = -1
    Func.Called: loginrestrictions
    System Errno: 2

5620    error DB2 UDB oper system services sqloGetUserPasswordInformationInternal fnc (4.3.15.1254.0.160)
    pid 7209062 tid 258 cpid -1 node 0 sec 10 nsec 168326556 probe 160
    Error ZRC = 0x00000000 = 0 = HA_ZRC_OK
    bytes 52
    Data1     (PD_TYPE_DEFAULT,44) Hexdump:
    5365 6375 7269 7479 206D 6574 686F 6420    Security method
    2250 444F 5322 2063 6F75 6C64 206E 6F74    "PDOS" could not
    2062 6520 6C6F 6164 6564 2E0A               be loaded..

5621    exit DB2 UDB oper system services sqloGetUserPasswordInformationInternal fnc (2.3.15.1254.0)
    pid 7209062 tid 258 cpid -1 node 0 sec 10 nsec 168355406
    rc = 0x800F006A = -2146500502 = SQLO_BAD_USER

Resolving The Problem

Engage or disable Tivoli Access Manager for Operating System if applicable.

Document Location

Worldwide

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PmmAAE","label":"Security and Plug-Ins->Authentication"}],"ARM Case Number":"TS003892991","Platform":[{"code":"PF002","label":"AIX"}],"Version":"All Version(s)"}]

Document Information

Modified date:
02 July 2020

UID

ibm16243362