IBM Support

LI73587: A DB2 DPF INSTANCE ABENDS WHEN RUNNING A QUERY CONTAININING A UNION ALL CLAUSE THAT IS JOINED TO ANOTHER TABLE/SUBSELECT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In DPF/MPP mode, a query containing a UNION ALL
    clause (UA) may cause the DB2
    server to abend, if the UA is contained within a subselect or
    view that is
    joined with another subselect, view or table. Specifically, the
    characteristics
    of the server and query being evaluated need to be the following
    for the abend
    to occur:
    - DPF environment
    - Query contains UA as part of a view or a subselect, with local
    predicates on
      the branches of the UA
    - Subselect or VIEW containing the UA is joined to another
    table, view or
      subselect on the same column as the local predicates in the UA
    - The non-UA subselect, table or view also has local predicates
    on the
      join column
    
    The resulting stack trace from the abend my look something like:
    sqlnq_colmap::get_colmap_col
    sqlnr_mark_ua_bound_cols
    sqlnr_joinppd_mpp_precheck
    sqlnr_joinppd_magic_detail
    sqlnr_joinppd_action
    sqlnr_comp
    sqlnr_seq
    sqlnr_rcc
    sqlnr_magic_detail_action
    sqlnr_comp
    sqlnr_seq
    sqlnr_rcc
    sqlnr_endqtb_action
    sqlnr_comp
    sqlnr_seq
    

Local fix

  • The problem occurs on optimization levels 2, 5 or higher. The
    issue can be worked around by operating the DB2 instance on
    optimization level 0, 1 or 3. This issue will be fixed starting
    with DB2 Version 9.1 Fix Pack 6 and DB2 Version 9.5 Fix Pack 3.
    

Problem summary

  • See problem description.
    

Problem conclusion

  • First Fixed in DB2 Version 9.5 Fixpack 3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73587

  • 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

    2008-07-15

  • Closed date

    2009-04-20

  • Last modified date

    2009-04-20

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

    LI73586

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

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:
20 April 2009