IBM Support

IT37454: WHILE DOING AN XML LOAD, DB2 MAY CRASH WHEN PROCESSING A ROW WITH INVALID DATA

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When doing a LOAD operation, if there is a row with some invalid
    data that Db2 needs to reject and there is XML data type
    involved; while doing processing related to rejecting this row a
    bad pointer can be encountered which leads Db2 to crash. This
    APAR fixes this condition.
    
    
    		<StackTrace>
    		-----FUNC-ADDR---- ------FUNCTION + OFFSET------
    		0x00007F30C25053E5
    _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
    0x0385&#160;
    		0x00007F30C2504FEC ossDumpStackTraceV98 + 0x002c&#160;
    		0x00007F30C250108D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
    0x00fd&#160;
    		0x00007F30C8BBE664 sqlo_trce + 0x0404&#160;
    		0x00007F30C8C48699 sqloEDUCodeTrapHandler + 0x02b9&#160;
    		0x00007F30CEA72630 address: 0x00007F30CEA72630 ; dladdress:
    0x00007F30CEA63000 ; offset in lib: 0x000000000000F630 ;&#160;
    		0x00007F30C785EE31 pdSQUFormat_sqluXmlChunkState + 0x0a41&#160;
    		0x00007F30C3AF2433 pdFormatArg + 0x01b3&#160;
    		0x00007F30C785FE11 pdSQUFormat_sqluXmlFrmCB + 0x0db1&#160;
    		0x00007F30C3AF2433 pdFormatArg + 0x01b3&#160;
    		0x00007F30C3AFC167 address: 0x00007F30C3AFC167 ; dladdress:
    0x00007F30C2A2C000 ; offset in lib: 0x00000000010D0167 ;&#160;
    		0x00007F30C3AFBB97 address: 0x00007F30C3AFBB97 ; dladdress:
    0x00007F30C2A2C000 ; offset in lib: 0x00000000010CFB97 ;&#160;
    		0x00007F30C3AF590A address: 0x00007F30C3AF590A ; dladdress:
    0x00007F30C2A2C000 ; offset in lib: 0x00000000010C990A ;&#160;
    		0x00007F30C3AF4716 pdLog + 0x0436&#160;
    		0x00007F30C7316192 _Z10sqlucPdLogmjmmmmz + 0x08b2&#160;
    		0x00007F30C96668A6 _Z16sqluXmlRejectRowP12sqluXmlFrmCBt +
    0x03a6&#160;
    		0x00007F30C722D380
    _Z23sqluGetAndFormatRecordsP13SQLUCACB_TYPEP17SQLU_FORMATTER_CBj
    PPhiP10sqlz_valueS3_PP10SQLD_VALUES9_Pi + 0x07f0&#160;
    		0x00007F30C722A653 _ZN14sqluCFormatter4iRunEv + 0x06d3&#160;
    		0x00007F30C72A34C3 _Z17sqluLoadEDUDriverPhj + 0x0333&#160;
    		0x00007F30C6BF2B43 sqloEDUEntry + 0x0303&#160;
    		0x00007F30CEA6AEA5 address: 0x00007F30CEA6AEA5 ; dladdress:
    0x00007F30CEA63000 ; offset in lib: 0x0000000000007EA5 ;&#160;
    		0x00007F30C17C096D clone + 0x006d ??
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to 11.1.4.7                                          *
    ****************************************************************
    

Problem conclusion

  • upgrade to 11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT37454

  • 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

    2021-06-29

  • Closed date

    2022-02-28

  • Last modified date

    2022-02-28

  • 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

  • RA50 PSN

       UP

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022