IBM Support

LI73430: IMPROPER TABLE ELIMINATION BY OPTIMIZER ON SPECIFIC CONDITIONS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Here are the necessary conditions that customer query must have
    to hit this bug.
    1. Query has equality join predicates among at least fix
    tables, called T1, T2, T3, T4, T5, T6. The minimum set of
    join predicates is {P12, P23, P34, P45, P56}, where Pxy is
    predicate between Tx and Ty.
    2. There is no RI relationship between join columns of P12,
    P23.
    3. There are at least three hierarchical RI (Referential
    Integrity) relationship defined. These RI, RI34, RI45,
    RI56, cover join columns of P34, P45 and P56 respectively,
    and their primary key tables are T3, T4 and T5 respectively.
    The symptom is table T5 is gone in the optimized statement of
    query access plan.
    

Local fix

  • Workaround
    =========
    Reduce query optimization level to 0 or 1. For instance, "db2 se
    t current query optimization 1".
    

Problem summary

  • See Problem Description.
    

Problem conclusion

  • First fixed in DB2 Version 9.1, FixPak 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73430

  • Reported component name

    DB2 UDB WSE LIN

  • Reported component ID

    5765F3504

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-05-09

  • Closed date

    2008-07-14

  • Last modified date

    2008-07-14

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

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

    LI73431

Fix information

  • Fixed component name

    DB2 UDB WSE LIN

  • Fixed component ID

    5765F3504

Applicable component levels

  • R910 PSY

       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:
15 October 2021