IBM Support

JR34322: THE ORACLE CONNECTOR STAGE IS 400% SLOWER THAN THE ORACLE ENTERPRISE STAGE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The Oracle Enterprise Stage can read from the
    table at 24,000 rows/seconds while the Oracle Connector Stage
    can only
    achieve 6,000 rows/second.  In both cases the bottleneck is the
    "osh"
    operator running at 100% on the server.
    
    The Oracle Connector Stage is 400%
    slower than the Oracle Enterprise Stage.  Since, the other
    Connector stages have been faster.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    ALL
    ****************************************************************
    PROBLEM DESCRIPTION:
    Slow performance when executing jobs that used DataStage
    Date and Timestamp types with Scale and Extended attributes
    not set.
          The connector was
    importing Oracle DATE columns as DataStage  Date types when
             using the MDI
    Wizard. This is incorrect since the Oracle DATE type can store
          date (year,
    month, day) and time (hour, minute, second)      values,
    while the
    DataStage Date type only store date values.
               Oracle connector jobs
    would fail when selecting or inserting Oracle DATE and
         TIMESTAMP columns with
    the DataStage Time type.
      Oracle connector jobs would fail when loading
    Oracle DATE columns with the
      DataStage Timestamp type.
                 When
    Table Action was set to Create, and the Oracle connector was
    generating           the
    CREATE TABLE statement, the connector would generate
    INTERVAL data types
    in the table for DataStage Time and Timestamp types, which
    are not compatible.
    ****************************************************************
    RECOMMENDATION:
    Download latest Oracle connector patch.
    This change is included in 8.1 Fix Pack 1.
    ****************************************************************
    

Problem conclusion

  • The code was fixed to increase performance when using
    DataStage Date and
     Timestamp types with Scale and Extended attributes not set.
    
    The code was fixed to import Oracle DATE columns as DataStage
    Timestamp
     with attributes Scale set to 0 and Extended not set.
    
    The code was fixed to allow using DataStage Time types when
    operating with
     Oracle DATE and TIMESTAMP data types.
    
    The code was fixed to allow bulk loading into Oracle DATE
    columns with the
     DataStage Timestamp type.
    
    The code was fixed to generate a CREATE TABLE statement with
    DATE columns
     for DataStage Time or Timestamp columns with Scale and
    Extended attributes
     not set. When Time or Timestamp columns have Scale or
    Extendedattributes set,
       the connector will generate TIMESTAMP columns.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34322

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

  • Closed date

    2009-09-30

  • Last modified date

    2009-12-15

  • 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:
15 December 2009