DB2 - Problem description
Problem IT19092 | Status: Closed |
DB2 SERVER TERMINATES ABNORMALLY EXECUTING DDL STATEMENT | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Executing a DDL statement may, in rare circumstances, cause the DB2 server to terminate abnormally. The stack looks similar to this example from AIX: -------Frame------ ------Function + Offset------ 0x090000003BAE7930 pdFormatIntegerUnsigned + 0xA4 0x090000003BAE7524 pdFormatArg + 0x1C8 0x090000003BAE7284 pdInvokeFmtFnc + 0x34 0x090000003BAE7038 @132@formatPDType__FP13PDLogFacilityUlUiT2T3T2Pv + 0x194 0x090000003BAE6DB8 @132@pdTypeFormatOrDump__FP13PDLogFacilityR10PD_CONTEXTPcUlUiT4b T7T5T4Pv + 0x1BC 0x090000003BAE4698 @132@pdLogInternal__FUlUiT1T2N41PvT1bPPc + 0x82C 0x090000003BADFDF4 pdLogInternal__FUlUiT1T2N41PvT1bPPc@glue464 + 0xB4 0x090000003BADFCF4 pdLog + 0x12C 0x090000003D4A5F84 sqlnq_create_with_error__FPUciUcP9sqlnq_qtbT4P3loc + 0x1F78 0x090000003D4A71A0 sqlnq_create_with_error__FPUciUcP9sqlnq_qtbT4P3loc@glue10E5 + 0x7C 0x090000003A07B4C0 sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0x5C8 0x090000003B8F77F4 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_enviT7PP9sqlnq_qur + 0x498 0x090000003BA2E11C sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_env + 0x40 | |
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 | |
Solution | |
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 : | 02.02.2017 23.06.2017 23.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |