DB2 - Problem description
Problem IT37100 | Status: Closed |
DB2STOP RESULTS IN SQL1042C AN UNEXPECTED SYSTEM ERROR OCCURRED. SQLSTATE=58004 | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
It is possible for db2stop processing to fail with the following SQLCODE: SQL1042C An unexpected system error occurred. SQLSTATE=58004 The db2diag.log contains probes such as the following: 2021-03-14-01.03.42.581861-480 I173302271E330 LEVEL: Event PID : 15757 TID : 140323966326656 PROC : db2stop2 INSTANCE: db2dpe NODE : 000 HOSTNAME: heeudpedb03 FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250 DATA #1 : String, 41 bytes Requesting system controller termination. : 2021-03-14-01.03.47.533305-480 I173304887E476 LEVEL: Severe PID : 17834 TID : 139627176388352 PROC : db2sysc 0 INSTANCE: db2dpe NODE : 000 HOSTNAME: heeudpedb03 EDUID : 21 EDUNAME: db2tcpcm 0 FUNCTION: DB2 UDB, RAS/PD component, pdResilienceIsSafeToSustain, probe:800 DATA #1 : String, 37 bytes Trap Sustainability Criteria Checking DATA #2 : Hex integer, 8 bytes 0x200000000000800C DATA #3 : Boolean, 1 bytes false 2021-03-14-01.03.47.535084-480 E173305364E1411 LEVEL: Severe PID : 17834 TID : 139627176388352 PROC : db2sysc 0 INSTANCE: db2dpe NODE : 000 HOSTNAME: heeudpedb03 EDUID : 21 EDUNAME: db2tcpcm 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: "/db2/DPE/db2dump/". DATA #1 : Signal Number Recieved, 4 bytes 11 DATA #2 : Siginfo, 128 bytes 0x00007EFD7C00FBF0 : 0B00 0000 0000 0000 0100 0000 0000 0000 ................ 0x00007EFD7C00FC00 : 5000 0000 0000 0000 0000 0000 0000 0000 P............... 0x00007EFD7C00FC10 : 0000 0000 0000 0000 8061 2CC7 F69C FFFF .........a,..... 0x00007EFD7C00FC20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007EFD7C00FC30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007EFD7C00FC40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007EFD7C00FC50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007EFD7C00FC60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 2021-03-14-01.03.47.548752-480 I173306776E1216 LEVEL: Event PID : 17834 TID : 139627176388352 PROC : db2sysc 0 INSTANCE: db2dpe NODE : 000 HOSTNAME: heeudpedb03 EDUID : 21 EDUNAME: db2tcpcm 0 FUNCTION: DB2 UDB, oper system services, sqloPGRPRegisterOneCrash, probe:2159 MESSAGE : lastCrashCount DATA #1 : unsigned integer, 8 bytes 0 DATA #2 : String, 10 bytes inRecovery DATA #3 : Boolean, 1 bytes false CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007EFD8F6010EC sqloPGRPRegisterOneCrash + 0x17C [1] 0x00007EFD8F6536E9 sqloEDUCodeTrapHandler + 0xA59 [2] 0x00007EFD954D6630 /lib64/libpthread.so.0 + 0xF630 [3] 0x00007EFD8C61C517 _ZN16sqeAgentServices19RequestAgentForApplEiiP12SQLZ_APP_HDLP23S QLKD_RQST_REPLY_FORMATP17SQLE_CONNECT_INFO + 0x447 [4] 0x00007EFD8C61ADFB _ZN16sqeAgentServices12RequestAgentEiP18SQLCC_INITSTRUCT_TiP12SQ LZ_APP_HDLP23SQLKD_RQST_REPLY_FORMATi + 0x52B [5] 0x00007EFD8E5D0DC4 _Z21sqlcctcpconnmgr_childPcj + 0x1944 [6] 0x00007EFD8D5BDF73 sqloEDUEntry + 0x303 [7] 0x00007EFD954CEEA5 /lib64/libpthread.so.0 + 0x7EA5 [8] 0x00007EFD881B496D clone + 0x6D And a trap file is generated with the following stack: ossDumpStackTraceInternal ossDumpStackTraceV98 OSSTrapFile::dumpEx sqlo_trce + 0x0404 sqloEDUCodeTrapHandler + 0x02bf sqeAgentServices::RequestAgentForAppl sqeAgentServices::RequestAgent sqlcctcpconnmgr_child sqloEDUEntry | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5 FP7 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.06.2021 22.11.2021 22.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |