A fix is available
APAR status
Closed as program error.
Error description
SQL statements issued may trap and bring the instance down with FODC generation. This type of db2 crash will show below generic messages in db2diag.log : 2021-03-25-17.35.25.990209+480 I13360299A1267 LEVEL: Error PID : 19464234 TID : 61998 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-59952 APPID: X.X.X.X.0000.210325093641 AUTHID : AUTHUSER HOSTNAME: HOST1 EDUID : 61998 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:8 MESSAGE : Error in agent servicing application with AUTHORIZATION ID: DATA #1 : Hexdump, 129 bytes 0x0A000100623E92D1 : 5441 5F4D 4F4E 2020 0000 0000 0000 0000 AUTHUSER ........ ? . 2021-03-25-17.35.44.938383+480 E13453350A1282 LEVEL: Severe PID : 19464234 TID : 61998 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-59952 APPID: X.X.X.X.0000.210325093641 AUTHID : AUTHUSER HOSTNAME: HOST1 EDUID : 61998 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:90 MESSAGE : ADM14011C A critical failure has caused the following type of error: "Trap". The DB2 database manager cannot recover from the failure. First Occurrence Data Capture (FODC) was invoked in the following mode: "Automatic". FODC diagnostic information is located in the following directory: "/db2dump/db2inst1/dump/FODC_Trap_2021-03-25-17.35.25.620651_000 0/". DATA #1 : Signal Number Recieved, 4 bytes 11 Checking the trap file for this PID.TID trap file - 19464234.61998.000.trap.txt for thread 61998 will show below stack with top frame in sqlra_check_each_privs: -------Frame------ ------Function + Offset------ 0x090000001168CB6C sqlra_check_each_privs__FP8sqlrr_cbP16sqlra_cached_variP19sqlra_ list_req_privP10sqlr_rolesbPb + 0xFB4 0x09000000114A29C4 sqlra_check_privs__FP8sqlrr_cbP16sqlra_cached_variP19sqlra_list_ req_privP10sqlr_rolesbPb + 0x65C 0x090000000F314454 sqlra_check_stmt_privs__FP8sqlrr_cbiP19sqlra_list_req_privP16sql ra_cached_varbPb + 0x350
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1 FP7 or later * ****************************************************************
Problem conclusion
Upgrade to 11.1 FP7 or later
Temporary fix
Comments
APAR Information
APAR number
IT37005
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
2021-05-24
Closed date
2021-11-23
Last modified date
2022-03-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
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:
03 May 2022