IBM Support

JR34977: DB2 CONNECTOR TRUNCATES DATA AFTER THE FIRST NULL VALUE (HEX0)

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 connector when reading or inserting varchar, truncates
    the data to the first hex0 (null value) that is in the string.
    Therefore it is not possible to insert or read strings that
    contain null values inside.
    
    This problem is in the common connector framework and affects
    also ODBC connector.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    DB2 Connector
    ****************************************************************
    PROBLEM DESCRIPTION:
    DB2 connector when reading or inserting varchar, truncates the
    data to the first 0x00 (null value) that is in the string.
    ****************************************************************
    RECOMMENDATION:
    Apply the patch for JR34977
    ****************************************************************
    

Problem conclusion

  • DB2 Connector handled 0x00 as a null-terminator since it was
    using strlen() to fetch the data length. Fixed connector to get
    actual data length so that 0x00 will be handled was a input
    data.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34977

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-30

  • Closed date

    2009-12-07

  • Last modified date

    2009-12-07

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

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

Modules/Macros

  • DB2CC
    

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R810 PSN

       UP

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

Document Information

Modified date:
07 December 2009