IT30942: TRANSFER OWNERSHIP MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• In some rare instances, the Db2 server may terminate abnormally
  while processing a TRANSFER OWNERSHIP statement.  The stack
  looks similar to this example:
  
  0x0000100CEC7E4EF0 0x000010000D1F5DF4
    ( = offset 0xCE95DF4 in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100CEC7E4F20 0x000010000D1F68AC
    ( = offset 0xCE968AC in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100CEC7E5340 0x000010000D1F6064
  _Z29sqlnq_transfer_ownership_stmtPP8stknode_i10actiontypePhP3loc
  + 0x0214
    ( = offset 0xCE96064 in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100CEC7E5860 0x000010000C9360C4
  _Z12sqlnp_smactnP8sqlnp_cbi + 0x0254
    ( = offset 0xC5D60C4 in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100CEC7E5960 0x000010000C9256C4 _Z12sqlnp_parserP8sqlnp_cb
  + 0x09a4
    ( = offset 0xC5C56C4 in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100CEC7E5A90 0x000010000C92CE84
  _Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x0de4
    ( = offset 0xC5CCE84 in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100CEC7E6540 0x000010000C301988
  _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
  lrr_cmpl_enviiPP9sqlnq_qur + 0x8978
    ( = offset 0xBFA1988 in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100CEC7E8320 0x000010000C2F8FEC
  _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
  lrr_cmpl_env + 0x002c
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 version 11.1.4.6 or later                     *
  ****************************************************************
  

Problem conclusion

• First fixed in Db2 version 11.1.4.6
  

Temporary fix

Comments

APAR Information

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

  IT30926

• 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