IBM Support

IT26579: DB2 SERVER MAY TERMINATE ABNORMALLY WITH SQLDCSL_BADPAGE "BAD DATA PAGE"

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

  • Issuing a query that queries XML data may terminate abnormally
    with the following stack:
    
    FUNCTION: DB2 UDB, Common Storage Layer,
    sqldcsl_getRecDataAndLength, probe:2611
    MESSAGE : ZRC=0x87A80001=-2019033087=SQLDCSL_BADPAGE "Bad Data
    Page"
    DIA8500C A data file error has occurred, record id is "".
    DATA #1 : signed integer, 8 bytes
    0
    DATA #2 : Hexdump, 20 bytes
    0x00007F1D74C60038 : 0000 0000 0000 0000 B47F 0000 B37F 0000
    ................
    0x00007F1D74C60048 : 0000 1400 ....
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
    [0] 0x00007F1E41931C4E
    _Z19sqldcsl_fetchDirectP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQL
    DCSL_FETCH_CB + 0x2AE
    [1] 0x00007F1E419315E6
    _Z16sqldcsl_fetchRowP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLDCS
    L_FETCH_CB + 0x116
    [2] 0x00007F1E4935C032
    _Z16xmls_FetchRecordP11XMLSTORE_CBR8XMLS_XIDPPcPtS5_hP13XMLS_WA_
    TOKENPP8SQLD_TCB + 0x2F2
    [3] 0x00007F1E4929EE4F
    _ZN12XmlrnNodeMgr13fetchTempNodeEP11XMLSTORE_CBP17xmlDataDescrip
    torR8XMLS_XIDsRP9XmlrnNodePPcPtP12XmlsNidStackP13XMLS_WA_TOKENP
    + 0xBF
    [4] 0x00007F1E492D5FA0
    _ZN15XmlrnTreeWalker10initWalkerEP17xmlDataDescriptort + 0x470
    [5] 0x00007F1E4924469D
    _ZN17xmlDataDescriptor15getNodeTypeInfoEP11XMLSTORE_CBPhS2_Pj +
    0x25D
    [6] 0x00007F1E4842D0A5 _Z21sqlriXmlUpdInsReplaceP8sqlrr_cb +
    0x515
    [7] 0x00007F1E4838614A _Z14sqlriNljnPipedP8sqlrr_cb + 0x1FA
    

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

    IT26579

  • 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

    2018-10-10

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

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

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

    IT35085

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