DB2 - Problem description
Problem IT33707 | Status: Closed |
FODC_ForceDBShutdown occurs after an INSERT statement is interrupted and attempts to roll back. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
An insert that is interrupted before finishing will undergo rollback, and under certain conditions a FODC_Trap can occur, causing a FODC_ForceDBShutdown. The most common cause of this is if we run out of memory during the insert. If such a scenario occurs, you can confirm it is this problem by looking for the following lines in the trap.txt file inside the FODC_Trap folder: -----Frame------ ------Address----- ------Function + Offset------ 0x0000101FDC7EB970 0x00001000054D5C0C ( = offset 0x51F5C0C in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101FDC7EB9B0 0x00001000054C8EA4 _ZN7ibm_cde4data30PageDictionaryColumnGroupState15resetForNewPag eEv + 0x0074 ( = offset 0x51E8EA4 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101FDC7EB9F0 0x00001000063C12AC _ZN7ibm_cde4data21ColumnGroupWriteState25resetForInsertBufferFlu shEbb + 0x02fc ( = offset 0x60E12AC in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101FDC7EBAA0 0x00001000063D6850 _ZN7ibm_cde4data21ColumnGroupWriteState20flushBufferedInsertsENS _5types3TSNEbbbbbb + 0x01e0 ( = offset 0x60F6850 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101FDC7EBB90 0x00001000060B26D8 _ZN7ibm_cde4data11TableWriter20flushBufferedInsertsEbmbbbbbbbb + 0x0418 ( = offset 0x5DD26D8 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101FDC7EBE60 0x0000100005E65238 _ZN7ibm_cde4data11InsertRange18flushInsertBuffersEbbbmbbbbbb + 0x0348 ( = offset 0x5B85238 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) ... | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * The fix will be added to a futute release. * **************************************************************** | |
Local Fix: | |
This issue will be fixed in Db2 v11.5.5 | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.07.2020 28.07.2020 28.07.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |