IBM Support

JR39106: DATASTAGE ORACLE ENTERPRISE RETURNING SEQUENTIAL READ DATA ON ALL PARTITIONS INSTEAD OF PARTITION TABLE DATA IN PARALLEL DATAS

 

APAR status

  • Closed as program error.

Error description

  • When defining the partition table to return the partitioned data
    in parallel for the Oracle Enterprise Stage,  they are getting
    Sequential Data across all nodes.
    

Local fix

Problem summary

  • Certain queries cause Oracle EE stage to read all data on all
    nodes instead of partitioning among nodes.  This results in
    duplicated data.
    

Problem conclusion

  • Queries are being rewritten incorrectly if they
    contain a subselect query with a where clause.  For example:
    
    select id,val,(select 1 from dual where 1=1) from test where 1=1
    
    rewritten as:
    
    select /*+ rowid(test)*/  id,val,(select 1 from dual where
    (test.rowid between 'AAASa8AAEAAAAKgAAA' and
    'AAASa8AAEAAAAKnH//' ) AND  1=1) from test where 1=1
    
    
    Note that in order to correctly partition the results among the
    nodes, the rowid needs to be added to the main where clause, not
    to the subselect's where clause.
    

Temporary fix

  • Avoid use of subselect with where clause
    

Comments

APAR Information

  • APAR number

    JR39106

  • Reported component name

    WIS QUALITYSTAG

  • Reported component ID

    5724Q36QS

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-09

  • Closed date

    2011-03-23

  • Last modified date

    2011-03-23

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

  • Fixed component ID

    5724Q36QS

Applicable component levels

  • R801 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSVSBF","label":"InfoSphere QualityStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1"}]

Document Information

Modified date:
12 October 2021