Fixes are available
APAR status
Closed as program error.
Error description
The problem is difficult to reproduce. The function which trapped was sqloGetTIDFromEDUID() and the leading trigger was a call to table function env_get_db2_edu_system_resources() In the db2diag.log we see: EDUID : 20511 EDUNAME: db2agent (dbname) 0 FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:30 MESSAGE : ADM14005E The following error occurred: "AppErr". First Occurrence Data Capture (FODC) has been invoked in the following mode: "Automatic". Diagnostic information has been recorded in the directory named "/db2/path/db2dump/FODC_AppErr_2020-03-03-09.36.38.022000_20054_ 20511_ 000/". EDUID : 20511 EDUNAME: db2agent (dbname) 0 FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:1 MESSAGE : Error in agent servicing application with coor_node: DATA #1 : Hexdump, 2 bytes 0x00007DBAA700F822 : 0000 The stack trace shows Trap in sqloGetTIDFromEDUID : <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00007F5A49A16F85 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0385 (/db2/db2pjr/sqllib/lib64/libdb2osse.so.1) 0x00007F5A49A16B8C ossDumpStackTraceV98 + 0x002c (/db2/db2pjr/sqllib/lib64/libdb2osse.so.1) 0x00007F5A49A12C2D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00fd (/db2/db2pjr/sqllib/lib64/libdb2osse.so.1) 0x00007F5A500D1114 sqlo_trce + 0x0404 (/db2/db2pjr/sqllib/lib64/libdb2e.so.1) 0x00007F5A5015B299 sqloEDUCodeTrapHandler + 0x02b9 (/db2/db2pjr/sqllib/lib64/libdb2e.so.1) 0x0000003D6CC0F7E0 address: 0x0000003D6CC0F7E0 ; dladdress: 0x0000003D6CC00000 ; offset in lib: 0x000000000000F7E0 ; (/lib64/libpthread.so.0) 0x00007F5A4E01A75E sqloGetTIDFromEDUID + 0x005e (/db2/db2pjr/sqllib/lib64/libdb2e.so.1) 0x00007F5A4E07FFDC sqloGetCPUUsage + 0x020c (/db2/db2pjr/sqllib/lib64/libdb2e.so.1) 0x00007F5A504D043F _Z50sqlrwGatherEnvDB2EduSystemInformationForThisMemberP8sqeAgent PPcPl + 0x031f (/db2/db2pjr/sqllib/lib64/libdb2e.so.1) 0x00007F5A50439844 _Z30sqlrkGetWLMTableFunctionResultP8sqeAgentP20sqlrw_rpc_tf_requ estPPvPl + 0x0184 (/db2/db2pjr/sqllib/lib64/libdb2e.so.1) 0x00007F5A4E32EE41 _Z36sqlrwGetWLMTableFunctionMergedResultjPPv + 0x0661 (/db2/db2pjr/sqllib/lib64/libdb2e.so.1) 0x00007F5A4D304B7C _Z29sqlerTrustedRtnCallbackRouterjPPv + 0x00bc . . </StackTrace>
Local fix
Avoid a call to table function ENV_GET_DB2_EDU_SYSTEM_RESOURCES
Problem summary
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1.4.6 or higher * ****************************************************************
Problem conclusion
Upgrade to Db2 11.1.4.6 or higher
Temporary fix
Comments
APAR Information
APAR number
IT32586
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-04-17
Closed date
2021-03-31
Last modified date
2021-03-31
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
424AC6
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022