IBM Support

IT27796: DB2 SERVER TERMINATES ABNORMALLY WHEN AUTO_REVAL=DEFERRED_FORCE

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

  • Db2 may terminate abnormally during object creation when the
    auto_reval database configuration parameter is set to deferred
    force.  The stack is similar to this example from Linux:
    
    0x00002AAAAEA13604
    _Z25sqlnq_ddl_create_func_endP9sqlnq_qtbbbP12sqlnq_string +
    0x6a54
                    (/home/.../sqllib/lib64/libdb2e.so.1)
    0x00002AAAB0B438DB
    _Z23sqlnq_create_with_errorPhihP9sqlnq_qtbS1_P3loc + 0x0beb
                    (/home/.../sqllib/lib64/libdb2e.so.1)
    0x00002AAAAE7C1803 address: 0x00002AAAAE7C1803 ; dladdress:
    0x00002AAAAACE1000 ; offset in lib: 0x0000000003AE0803 ;
                    (/home/.../sqllib/lib64/libdb2e.so.1)
    0x00002AAAAE7BB82F
    _Z15sqlnq_resolveFnP9sqlnq_pidP12sqlnq_stringPhPiP3locisi +
    0x03cf
                    (/home/.../sqllib/lib64/libdb2e.so.1)
    0x00002AAAAEA218DB _Z22sqlnq_ddl_function_refP9sqlnq_pid +
    0x02ab
                    (/home/.../sqllib/lib64/libdb2e.so.1)
    

Local fix

  • Change the auto_reval database configuration parameter to
    deferred and create objects in dependency order
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All PLatforms                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 v11.1.4.6 or later.                           *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 v11.1.4.6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27796

  • 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-01-17

  • Closed date

    2021-03-17

  • Last modified date

    2021-03-17

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

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

    IT35055

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:
18 March 2021