IZ58417: A QUERY MAY COMPILE INDEFINITELY IF CERTAIN CONDITIONS ARE SATISFIED.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • In V9.5 a query may compile indefinitely if the following condit
    ions are satisfied:
    1) There are atleast two UNION ALLs joining indirectly through o
    ne or more tables
    2) One of the UNION ALL has a correlated column to either the
    table or the other UNION ALL.
    Force application is not effective in V9.1 while executing in
    this function. On ending the db2 instance, the following stack
    trace might be observed:
    sqlnr_sort_sips_order
    sqlnr_sort_sips_order
    sqlnr_sips_order
    sqlnr_magic_action
    sqlnr_comp
    sqlnr_seq
    sqlnr_rcc
    sqlnr_magic_detail_action
    sqlnr_comp
    sqlnr_seq
    sqlnr_rcc
    sqlnr_endqtb_action
    sqlnr_comp
    sqlnr_seq
    sqlnr_rcc
    sqlnr_start_action
    sqlnr_comp
    sqlnr_seq
    sqlnr_rcc
    sqlnr_exe
    sqlnn_cmpl
    

Local fix

  • A possible work around is SET CURRENT OPTIMIZATION LEVEL to 0
    or 1.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All customer having UNION ALL views with                     *
    * correlatedpredicates                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * A QUERY MAY COMPILE INDEFINITELY IF THERE IS A UNION ALLVIEW *
    * WITH BRANCHES HAVING CONFLICTING CORRELATED PREDICATES.      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to DB2 Version 9.5 Fix  Pack 6a               *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 Version 9.5 Fix Pack 6a
    

Temporary fix

  • A possible work around is SET CURRENT OPTIMIZATION LEVEL to 0
    or 1.
    

Comments

APAR Information

  • APAR number

    IZ58417

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-08-14

  • Closed date

    2010-05-25

  • Last modified date

    2010-10-12

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

    IZ56561

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

Fix information

  • Fixed component name

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R950 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

950

Reference #:

IZ58417

Modified date:

2010-10-12

Translate my page

Machine Translation

Content navigation