IT19092: DB2 SERVER TERMINATES ABNORMALLY EXECUTING DDL STATEMENT

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
Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error 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
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 version 11.1.2.2                              *
  ****************************************************************
  

Problem conclusion

• First fixed in DB2 version 11.1.2.2
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IT14855

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP