IBM Support

LI72983: REPARTITION JOIN STRATEGY NOT CONSIDERED IN DPF ENVIRONMENT WHEN DB2_REDUCED_OPTIMIZATION IS SET

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Repartition join strategy is not considered in a DPF
    environment, when DB2_REDUCED_OPTIMIZATION is turned on. This
    limitation will be relaxed for OUTER JOINS with this fix.
    
    Without this fix, large tables or fact table on null producing
    side can be broadcasted to tuple preserving side, which leads to
    bad performance of the query.
    

Local fix

Problem summary

  • Repartition join strategy is not considered in a DPF
    environment, when DB2_REDUCED_OPTIMIZATION is turned on. This
    limitation will be relaxed for OUTER JOINS with this fix.
    
    Without this fix, large tables or fact table on null producing
    side can be broadcasted to tuple preserving side, which leads to
    bad performance of the query.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI72983

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-02-13

  • Closed date

    2008-06-24

  • Last modified date

    2008-06-24

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    LI72999

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
14 October 2021