IBM Support

JR34942: UPDATE PERFORMANCE OF ODBC CC IS SLOW EVEN WHEN THERE IS NO REJECT LINK ATTACHED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Update performance of ODBC CC is slow even when there is no
    reject link attached.
    

Local fix

  • Use DSN parameter FloatingPointParameters=1
    
    This fix is included in 8.0.1 fix pack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users of ODBC Connector stage using one of the Update modes
    (Update, Update then insert and insert then update)
    ****************************************************************
    PROBLEM DESCRIPTION:
    Update performance of ODBC CC connecting to Oracle database is
    slow even when there is no reject link attached
    ****************************************************************
    RECOMMENDATION:
    Apply this APAR.
    
    For Oracle Database, set the DSN Parameter:
    
    FloatingPointParameters=1
    
    ****************************************************************
    

Problem conclusion

  • The update job is run using array size set to 1 even when there
    is no reject link.
    Array size 1 will help us in determining the row wise  error
    code and text so that  those can be added to the rejected rows
    for user information. This is not required when there is no
    reject link.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34942

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-24

  • Closed date

    2010-02-10

  • 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:

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R801 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.0.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021