IBM Support

IT33146: DB2 SERVER TERMINATES ABNORMALLY DURING ROLLFORWARD RECOVERY IN THE SQLPLRQ FUNCTION WITH DB2_4K_DEVICE_SUPPORT=ON SET.

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

  • During rollforward recovery, Db2 may need to restore a load
    copy.  If there are any LOB columns in the load copy, we will
    attempt to perform extra serialization to avoid corruption of
    LOB data when DB2_4K_DEVICE_SUPPORT=ON is set.  However, the
    preconditions for the Db2 lock manager are not met, resulting in
    a panic.
    
    The following stack will be generated in this case:
    
      [0] 0x00007FD480220611 sqloPGRPRegisterOneCrash + 0x221
      [1] 0x00007FD4803A7026 sqloEDUCodeTrapHandler + 0xAB6
      [2] 0x00007FD48913A630 /lib64/libpthread.so.0 + 0xF630
      [3] 0x00007FD48065EC72 _Z7sqlplrqP9sqeBsuEduP14SQLP_LOCK_INFO
    + 0xD2
      [4] 0x00007FD479145D12
    _Z18sqlbDMSMapAndWriteP16SQLB_OBJECT_DESC14SQLB_AS_SCHEMEjtP12SQ
    LB_POOL_CBPllPjS5_lPcS5_P12SQLB_GLOBALS + 0x1A92
      [5] 0x00007FD479143310
    _Z18sqlbDMSDirectWriteP20SQLB_DIRECT_WRITE_CB + 0x1280
      [6] 0x00007FD4791B55D5
    _Z15sqlbDirectWriteP20SQLB_DIRECT_WRITE_CB + 0x955
      [7] 0x00007FD478EC3CC8
    _Z29sqlbServiceDirectWriteRequestP11SQLB_pfMisc + 0x2D8
      [8] 0x00007FD478EBBA0B
    _Z26sqlbPFPrefetcherEntryPointP16sqbPrefetcherEdu + 0xD9B
      [9] 0x00007FD478EBABE4 _ZN16sqbPrefetcherEdu6RunEDUEv + 0x24
      [10] 0x00007FD481F4302E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE
      [11] 0x00007FD4803A3DD9 sqloEDUEntry + 0x589
      [12] 0x00007FD489132EA5 /lib64/libpthread.so.0 + 0x7EA5
      [13] 0x00007FD4750D68DD clone + 0x6D
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All environments using DB2_4K_DEVICE_SUPPORT.                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.5 m4 fp0 or later.                         *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.5 m4 fp0 or later.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT33146

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-06-10

  • Closed date

    2020-06-30

  • Last modified date

    2020-06-30

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

  • 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

[{"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.5"}]

Document Information

Modified date:
01 July 2020