IBM Support

JR37282: READING DATA IN PARALLEL DOES NOT WORK WHEN TABLE ALIAS IS SPECIFIED IN THE SELECT STATEMENT.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Oracle Connector stage configured for partitioned (parallel)
    reads does not work if the specified SELECT statement uses table
    alias for the table name.
    

Local fix

  • Remove the table alias and reference only the actual table name
    in the specified SELECT statement.
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    IS DataStage users who are utilizing Oracle Connector stage in
    their jobs for reading data from Oracle database.
    ****************************************************************
    PROBLEM DESCRIPTION:
    Reading data in parallel does not work when table alias is
    specified in the select statement.
    The job fails with the error message indicating that the
    connector could not find the specified table or view.
    ****************************************************************
    RECOMMENDATION:
    Install patch JR37282.
    ****************************************************************
    

Problem conclusion

  • The connector code was fixed to allow for table alias to be used
    in the SELECT statement when the connector is configured to
    perform partitioned reads. The connector automatically
    determines the specified table name and alias. It then uses the
    table name to find out the necessary information about the table
    in the database, and it uses the table alias for the modified
    SQL statements that run on the processing nodes.
    
    The table name and alias can also be explicitly specified in the
    "Table name for partitioned reads" property in the following
    format:
    
    table_name table_alias
    
    Where table_name and table_alias match the table name and alias
    values specified in the SELECT statement for the stage.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR37282

  • Reported component name

    INFO SRVR PLATF

  • Reported component ID

    5724Q3612

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-07-21

  • Closed date

    2010-08-02

  • Last modified date

    2010-08-02

  • 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

    INFO SRVR PLATF

  • Fixed component ID

    5724Q3612

Applicable component levels

  • R801 PSN

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 August 2010