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: db2inst1 NODE : 000
HOSTNAME: XXX.XXX.XXX
EDUID : 258 EDUNAME: db2wdog 0 [db2inst1]
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
PID : 20381782 TID : 258 PROC : db2ckpwd 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: XXX.XXX.XXX
EDUID : 258 EDUNAME: db2wdog 0 [db2inst1]
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: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-50
HOSTNAME: XXX.XXX.XXX
EDUID : 12084 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
PID : 15139046 TID : 12084 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-50
HOSTNAME: XXX.XXX.XXX
EDUID : 12084 EDUNAME: db2agent (SAMPLE) 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
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..
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PmmAAE","label":"Security and Plug-Ins-\u003EAuthentication"}],"ARM Case Number":"TS003892991","Platform":[{"code":"PF002","label":"AIX"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
06 December 2022
UID
ibm16243362