IBM Support

IT21930: If DB2 happens to be backing up the tablespace at the same time it is being altered, this could cause DB2 panic.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When taking an online backup, and running an alter tablespace at
    the same time, if DB2 happens to be backing up the tablespace at
    the same time it is being altered, this could cause DB2 to panic
    and come down. The resulting stack might resemble:
    
    0x090000000056DF14 pthread_kill + 0xD4
    0x090000000768098C sqloDumpEDU + 0x6C
    0x0900000006B1D808 sqle_panic__Fv + 0x218
    0x0900000006BFF5B8
    dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T
    3T7 + 0x310
    0x09000000088DB820 releaseConflict__17SQLO_SLATCH_CAS64Fv +
    0x45C
    0x0900000009D37180
    sqlbpfParallelDirectReadV__FP14SQLB_pfParIoCbP17SQLB_DIRECT_IO_C
    B + 0x5D6C
    0x0900000009D2ACF0
    sqlbDirectReadBlock__FP19SQLB_DIRECT_READ_CBP14SQLB_pfParIoCbUiP
    UiT4 + 0x40D4
    0x0900000009D1FC84 sqlubReadDMS__FP14SQLU_BUFMAN_CB + 0x191C
    0x0900000009D1B4C8 sqlubBMProcessData__FP14SQLU_BUFMAN_CB +
    0x62C
    0x0900000009D17C48 sqlubbuf__FP8sqeAgent + 0x898
    0x0900000007644D4C sqleSubCoordProcessRequest__FP8sqeAgent +
    0x180
    0x09000000083A3FD4 RunEDU__8sqeAgentFv + 0x704
    0x09000000083A3114 EDUDriver__9sqzEDUObjFv + 0x13C
    0x09000000083A2F9C sqlzRunEDU__FPcUi + 0x10
    0x09000000083B66BC sqloEDUEntry + 0x264
    
    or
    -----------
    0x090000000056DF14 pthread_kill + 0xD4
    0x090000000768098C sqloDumpEDU + 0x6C
    0x0900000006B1D808 sqle_panic__Fv + 0x218
    0x0900000006BFF5B8
    dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T
    3T7 + 0x310
    0x090000000706CE08 getConflictComplex__17SQLO_SLATCH_CAS64FCUl +
    0x138
    0x0900000008707CDC getConflict__17SQLO_SLATCH_CAS64FCUl + 0x80
    0x0900000009D375E4
    sqlbpfParallelDirectReadV__FP14SQLB_pfParIoCbP17SQLB_DIRECT_IO_C
    B + 0x61D0
    0x0900000009D2ACF0
    sqlbDirectReadBlock__FP19SQLB_DIRECT_READ_CBP14SQLB_pfParIoCbUiP
    UiT4 + 0x40D4
    0x0900000009D1FC84 sqlubReadDMS__FP14SQLU_BUFMAN_CB + 0x191C
    0x0900000009D1B4C8 sqlubBMProcessData__FP14SQLU_BUFMAN_CB +
    0x62C
    0x0900000009D17C48 sqlubbuf__FP8sqeAgent + 0x898
    0x0900000007644D4C sqleSubCoordProcessRequest__FP8sqeAgent +
    0x180
    0x09000000083A3FD4 RunEDU__8sqeAgentFv + 0x704
    0x09000000083A3114 EDUDriver__9sqzEDUObjFv + 0x13C
    0x09000000083A2F9C sqlzRunEDU__FPcUi + 0x10
    0x09000000083B66BC sqloEDUEntry + 0x264
    

Local fix

  • Do not run alter tablespace on tablespaces that are being backed
    up.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 3 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT21930

  • 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

    2017-08-09

  • Closed date

    2018-03-19

  • Last modified date

    2018-03-19

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

    IT20976

  • 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

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

Document Information

Modified date:
19 March 2018