IBM Support

LI74202: ENHANCE FACTORIZATION OF A COMPLEX TYPE OF OR PREDICATE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This fix improves the predicate factorization of OR predicate
    whose all subterms have exactly matched clause. Given an example
    predicate
    (((col1 = 1 and col2 = 2) or col1 >= 100) and col3 = 3) or
    (((col1 = 1 and col2 = 2) or col1 >= 100) and col4 = 4)
    , this fix will rewrite the predicate to
    ((col1 = 1 and col2 = 2) or col1 >= 100) and (col3 = 3 or col4 =
    4).
    
    Here, the exactly matched clause is mixed with OR and AND. The
    comparison can be any type including >=, >, =, <, <=, IS NULL,
    IS NOT NULL, IN, etc. Both comparison operands can be literal
    including special register and host variable, single base table
    column, or expressions.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 v9.5 users with fixpacks lower than fixpack 5            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * This fix improves the predicate factorization of OR          *
    * predicate                                                    *
    * whose all subterms have exactly matched clause. Given an     *
    * example                                                      *
    * predicate                                                    *
    *                                                              *
    * (((col1 = 1 and col2 = 2) or col1 >= 100) and col3 = 3) or   *
    *                                                              *
    * (((col1 = 1 and col2 = 2) or col1 >= 100) and col4 = 4)      *
    *                                                              *
    * , this fix will rewrite the predicate to                     *
    *                                                              *
    * ((col1 = 1 and col2 = 2) or col1 >= 100) and (col3 = 3 or    *
    * col4 =                                                       *
    * 4).                                                          *
    *                                                              *
    *                                                              *
    *                                                              *
    * Here, the exactly matched clause is mixed with OR and AND.   *
    * The                                                          *
    * comparison can be any type including >=, >, =, <, <=, IS     *
    * NULL,                                                        *
    * IS NOT NULL, IN, etc. Both comparison operands can be        *
    * literal                                                      *
    * including special register and host variable, single base    *
    * table                                                        *
    * column, or expressions.                                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v9.5 fixpack 5.                                   *
    ****************************************************************
    

Problem conclusion

  • ENHANCE FACTORIZATION OF A COMPLEX TYPE OF OR PREDICATE fix
    included in v9.5 fixpack 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74202

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-02-25

  • Closed date

    2010-02-18

  • Last modified date

    2010-02-18

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

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

    IC61599

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
18 February 2010