DB2 - Problem description
Problem IT26427 | Status: Closed |
DB2 MAY CRASH WITH COREDUMP IF WINDOWS SYSTEM IS IN SHUTDOWN STATE DURING FETCH PROCESSING. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Db2 may crash with coredump (Linux/UNIX) or userdump (Windows) under the following conditions in federation environment. - Error handling is needed internally when windows system is shutdown. - Continue fetching data after error received. When encounter the issue, the following are reported in db2diag.log 2018-0x-2x-1x.0x.3x.302000+540 I16995275242F1250 LEVEL: Error PID : 3210 TID : 9876 PROC :db2syscs.exe INSTANCE: DB2 NODE : 000 DB :TESTDBB APPHDL : 0-xxxxx APPID: APPL.SAMP1.D0123456789 AUTHID : DB2ADMIN HOSTNAME: TESTSERVER1 EDUID : 9999 EDUNAME: db2agent (TESTDB) 0 FUNCTION: DB2 UDB, mssql wrapper, Mssql_Server::get_error_info, probe:7 MESSAGE : ODBC error txt: DATA #1 : Hexdump, 142 bytes 0x00000163DE586A80 : 5B4D 6963 726F 736F 6674 5D5B 4F44 4243 [Microsoft][ODBC 0x00000163DE586A90 : 2053 514C 2053 6572 7665 7220 4472 6976 SQL Server Driv 0x00000163DE586AA0 : 6572 5D5B 5351 4C20 5365 7276 6572 5D53 er][SQL Server]S 0x00000163DE586AB0 : 4855 5444 4F57 4E20 82AA 9069 8D73 9286 HUTDOWN ...i.s.. 0x00000163DE586AC0 : 82C5 82B7 8142 0000 0000 0000 0000 0000 .....B.......... 0x00000163DE586AD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000163DE586AE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000163DE586AF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000163DE586B00 : 0000 0000 0000 0000 0000 0000 0000 .............. 2018-04-24-12.07.46.942000+540 I16995286076F624 LEVEL: Error PID : 3210 TID : 9876 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : TESTDB APPHDL : 0-xxxxx APPID: APPL.SAMP1.D0123456789 AUTHID : DB2ADMIN HOSTNAME:TESTSERVER1 EDUID : 9999 EDUNAME: db2agent (TESTDB) 0 FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:9 MESSAGE : Error in agent servicing application with PRODUCT SIGNATURE: DATA #1 : Hexdump, 8 bytes 0x00000163C314C5FC : 5153 5130 3730 3330 Stacktrace in a trap file is as follows: sqlpCreateWakeUpList sqpLoggwEdu::sqlpgwlp sqpLoggwEdu::sqlpLoggwMain sqpLoggwEdu::RunEDU sqlzRunEDU sqloEDUEntry | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Windows System * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 V11.1 FP4 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
NONE | |
BUG-Tracking | |
forerunner : follow-up : IT26754 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.09.2018 10.03.2019 10.03.2019 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |