IBM Support

JR61117: SQL SERVER ENTERPRISE OPERATOR IN WRITE MODE (BULK LOAD) TO BCP CAUSES HEAP CORRUPTION WHEN PROCESSING DECIMAL DATA.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The SQL Server operator incorrectly calculates the size of the
    bind buffer for a DECIMAL column as 1 byte too short. This
    causes the conversion from DECIMAL to BCP format (string) to
    overrun the heap. This subtle heap corruption issue may or may
    not cause a segmentation violation or the fatal message
    Unexpected exit status -1,073,740,940.
    

Local fix

Problem summary

  • A decimal value must be converted to a string in order to
    satisfy the BCP Load format. The string length is precision plus
     2. Add 1 is for the leading space or plus or minus sign and 1
    for the decimal separator. The string value is NOT
    null-terminated. The 1st 4 bytes in the buffer represent the
    length of the string. The SQL Server Operator code was modified
    to provide a buffer of precision+2 instead of precision+1.
    

Problem conclusion

  • The heap corruption of BCP Load was solved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR61117

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-05-21

  • Closed date

    2019-06-06

  • Last modified date

    2019-06-06

  • 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

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • RB50 PSY

       UP

  • RB70 PSY

       UP

  • RB71 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 October 2021