IBM Support

JR34774: APPLIED PATCH JR34496 THE PERFORMANCE IS DEGRADING.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After applied patch JR34496 job is running slower
    

Local fix

  • This fix is included in 8.0.1 fixpack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    all
    ****************************************************************
    PROBLEM DESCRIPTION:
    Upsert is running very slow after applying a patch for APAR
    JR34496.
    ****************************************************************
    RECOMMENDATION:
    Apply patch provided.
    ****************************************************************
    

Problem conclusion

  • Bind variables are always assigned a character form NCHAR.  This
    is causing Oracle to skip indexes (as those are CHAR columns in
    the indexes). A full table scan per record is making upsert DML
    to a crawl.
    
    For a bind variable,  the operator now tries to read the
    character form of the corresponding target column and use it.
    If there is no corresponding column found, we need to use NCHAR
    as character column as default.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34774

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    753

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-05

  • Closed date

    2009-11-24

  • 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

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

Document Information

Modified date:
12 October 2021