IBM Support

JR33993: DB2 CONNECTOR INSERT WRONG VALUE TO THE TARGET TABLE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 connector issue-
    The wrong data is inserted into the column
     The data is
    truncated with a NULL and then padded with spaces, as can be
    seen in the hex dump
    

Local fix

  • using ODBC connector without RCP
    
    This fix is included in 8.0.1 fix pack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    IS 8.0.1 with DTS patch, IS 8.1, all platforms
    ****************************************************************
    PROBLEM DESCRIPTION:
    Users Affected:
    IS 8.0.1 with patches patch_e122936 and patch_JR29796
    IS 8.1 with Connectivity Rollup Patch 1
    (all platforms)
    
    Problem Description:
    When writing to a DB2 database using the DB2 Connector, a
    string column that is followed by a decimal column will be
    updated with the decimal column's data.
    
    Problem Summary:
    When using an insert statement that has a string column followed
    by a decimal column, the DB2 Connector will sometimes use the
    string column's bind buffer for the decimal column's data (being
    retreived from the preceeding stage in the job).  This only
    happens if the string column did not need any codepage
    conversions and the string column's length is greater than the
    length of the decimal column + 2.  (The plus two is for the
    "." and +/- sign.)  The result is that the decimal column's
    data will be inserted into the string column and the decimal
    column.
    
    ****************************************************************
    RECOMMENDATION:
    For IS 8.0.1 users with patches patch_e122936 and patch_JR29796:
    Apply the patch for this APAR.
    
    For IS 8.1 users:
    Apply Connectivity Rollup Patch 2 (which will be released Sept.
    2009)
    
    All users:
    Upgrade to IS 8.5 (once it is released).
    ****************************************************************
    

Problem conclusion

  • The allocator for the buffer was declared as "static", thus
    the array's data pointer was not being set to NULL each time.
    The data pointer for the array is now initialized to NULL by an
    explicit call to setArray().  The decimal column will only
    receive its data and the string column will receive the correct
    data.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR33993

  • 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-08-14

  • Closed date

    2009-09-04

  • Last modified date

    2010-12-09

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

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

Modules/Macros

  • SERVER
    

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:
09 December 2010