IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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 number

    IT30942

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-11-14

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
01 April 2021