IT31613: UNNECESSARY SQLO_BAD_USER LOGGING INTO DB2DIAG.LOG (DB2 的BUG问题)
IT31613: UNNECESSARY SQLO_BAD_USER LOGGING INTO DB2DIAG.LOG
https://www.ibm.com/support/pages/apar/IT31613
A fix is available
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
You may encountering unnecessary SQLO_BAD_USER in db2diag.log
like the following:
2020-01-17-14.34.00.480708+060 I5819328E668 LEVEL: Error
PID : 13800 TID : 47679098840832 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-630 APPID: *LOCAL.db2t03.200117133407
HOSTNAME: localhost
EDUID : 91 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, oper system services,
sqloGetUserAttribByName, probe:20
MESSAGE : ZRC=0x800F006A=-2146500502=SQLO_BAD_USER "Bad User"
DIA8117C Error with userid "".
DATA #?1 : String, 40 bytes
getpwnam failed: user name, system error
DATA #?2 : String, 8 bytes
user1
DATA #?3 : signed integer, 4 bytes
0
The lastest v11.1 Fixpack 5 and v11.5 introduced extra logging
which caused this issue.
This APAR will reduce logging for this specific scenario.
Local fix
Problem summary
****************************************************************
* USERS AFFECTED: *
* All DB2 systems on all Linux, Unix and Windows platforms at *
* service level 11.1.4.5. Earlier releases of Db2 are not *
* affected *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1.4.6 *
****************************************************************
Problem conclusion
The complete fix for this problem first appears in DB2 Version
11.1.4.6 and all the subsequent Fix Packs.
The fix will ensure that Db2 does not log SQLO_BAD_USER at Error
level when it is an expected result from an OS function call.
Temporary fix
Comments
APAR Information
APAR numberIT31613
Reported component nameDB2 FOR LUW
Reported component IDDB2FORLUW
Reported releaseB10
StatusCLOSED PER
PENoPE
HIPERNoHIPER
Special AttentionNoSpecatt / Xsystem
Submitted date2020-01-22
Closed date2021-03-11
Last modified date2021-03-11
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:IT31615
Fix information
Fixed component nameDB2 FOR LUW
Fixed component IDDB2FORLUW
Applicable component levels
RB10 PSN
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· Docker 太简单,K8s 太复杂?w7panel 让容器管理更轻松!