|
Problem IT20230
|
Status: Closed |
DB2 SERVER TERMINATES ABNORMALLY EXECUTING DDL STATEMENT |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
The DB2 server may terminate abnormally when executing certain
DDL statements. The stack looks similar to this example from
AIX:
[0] 0x090000000B4AA128
diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCcCb +
0x4E8
[1] 0x090000000B4B16E4
MemTreeGet__13SQLO_MEM_POOLFCUlT1PP17SqloChunkSubgroupPUi +
0x864
[2] 0x090000000B4A9A7C
allocateMemoryBlock__13SQLO_MEM_POOLFCUlT1UiT1PP17SqloChunkSubgr
oupPUiCP12SMemLogEvent + 0xFC
[3] 0x090000000B440420 sqloGetMemoryBlockExtended + 0xAA0
[4] 0x090000000F82B6DC
buildCandidatePartKey__28sqlnqCandidatePartKeyBuilderFPPUsRUl +
0x27C |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 11.1.2.2 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 Version 11.1.2.2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.04.2017
26.06.2017
26.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
