IBM Support

JR34510: DB2 CONNECTOR USING BULK LOAD FAILING USING DECIMAL TYPE DATA FIELD WITHOUT SCALE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Problem using the DB2 connector using bulk Load where the logs
    show errors and no data is written to the target/exception
    tables when processing decimal type data field without scale.
    

Local fix

  • Workaround is to set scale for DECIMAL column.
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    DB2 Connector
    ****************************************************************
    PROBLEM DESCRIPTION:
    DB2 Connector using Bulkload failing when:
     - Using DECIMAL type data field without scale.
     - Loading NULL data into DECIMAL and DATE type
     - Loading data when column ordering of input data was different
    from the DB2 table definition.
    
    ****************************************************************
    RECOMMENDATION:
    Apply the patch for JR34510
    ****************************************************************
    

Problem conclusion

  • DB2Connector API LOAD is loading data in ASC(non-delimited)
    format.
    Connector pass position with the input data. When loading
    deciaml data, we count +2 for sign and decimal point. When
    there is no scale, DB2 Connector was not appending decimal
    point, but the position is passed in as +2. DB2 Connector will
    append decimal point for all decimal data. DB2 connector will
    also pass the correct length for NULL data processing.
    
    DB2 Connector did not pass COLUMN ordering when generating LOAD
    statement. DB2 connector is fixed to pass in the column ordering
    to LOAD statement, so that the ordering of the input column do
    not need to match the table definition.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34510

  • 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-10-09

  • Closed date

    2009-11-10

  • Last modified date

    2009-11-10

  • 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

  • R810 PSN

       UP

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

Document Information

Modified date:
12 October 2021