IBM Support

IT01754: LOAD OPERATIONS INVOLVING XML OR LOB DATA IN NON-PARALLEL ENVIRONMENTS MAY CRASH IN INTERNAL HANDLE MANIPULATION FUNCTIONS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This is seen in very large and long-running loads with
    INTRA_PARALLEL set to NO
    
    Stack is showing:
    
     <StackTrace>
    -------Frame------ ------Function + Offset------
    0x0900000005D9A828
    sqlrh_return_value__FP8sqlrr_cbPUiPP10sqlz_valuePiPUcUiUl +
    0x390
    0x090000000492DE58
    sqlrimso__FP8sqlrr_cbP9sqllf_csoPUcPUiUiisPPvT6 + 0x218
    0x0900000006ADF66C
    xmlrnCSOInputStreamInitialize__19XmlrnCSOInputStreamFP8sqeAgent
    + 0x78
    0x0900000008A03BC0 xmlrnInsertDocument__FP11XmlrnIUD_CB + 0x498
    0x09000000065E84C0
    @148@sqldFormatXDADesc__FP8sqeAgentP13SQLD_TDATARECT2P8SQLD_TCBi
    T5PUlPiP10sqlz_valueT8P8SQLD_CCB + 0xB4C
    0x090000000669F984
    sqluLoadFormatFixedVar__FP8sqeAgentP13SQLD_TDATARECT2PP10SQLD_VA
    LUEiP8SQLD_TCBPiPUcP15SQLD_XOR_UPDATEP8SQLD_CCBP17SQLU_FORMATTER
    _CB + 0xD8
    0x09000000065E33BC
    sqluFormatDMRec__FP13SQLUCACB_TYPEP17SQLU_FORMATTER_CBUiPP10SQLD
    _VALUEP14sqlrg_mdc_infoP12SQLU_RP_INFOT3i + 0x1460
    0x0900000006695A4C
    @148@sqluGetAndFormatRecords__FP8sqlulacbP13SQLUCACB_TYPEP17SQLU
    _FORMATTER_CBUiPPUciP10sqlz_valuePUcPP10SQLD_VALUET9Pi + 0xA8C
    0x090000000668DBF0 iRun__14sqluCFormatterFv + 0xF9C
    0x090000000755C70C sqluLoadEDUDriver__FPUcUi + 0x5A4
    0x0900000004E5ACC0 sqloEDUEntry + 0x1C
    </StackTrace>
    

Local fix

  • Turn INTRA_PARALLEL ON
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V9.7 FP10                                         *
    ****************************************************************
    

Problem conclusion

  • First fixed in V9.7 FP10
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT01754

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-05-13

  • Closed date

    2014-11-10

  • Last modified date

    2014-11-10

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

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

    IT02671 IT02673

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IT01754

Modified date: 10 November 2014