IC91198: QUERY WITH TABLES FUNCTIONS AND EXISTENTIAL SUBQUERY MIGHT PRODUCE SQL0901N

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Under rare scenarios, DB2 might produce SQL0901N error message
    if the following conditions are true:
    1. The query has an existential subquery
    2. The source of the subquery is a union/union all
    3. One or more branches of the union all refer to a table
    function
    
    <error message>
    SQL0901N  The SQL statement failed because of a non-severe
    system error.
    Subsequent SQL statements can be processed.  (Reason "OID
    imbalance".)
    SQLSTATE=58004
    
    <stack>
    sqlnq_union_ofn_sm
    sqlnq_proc_enc
    sqlnq_qtb::add_doid
    sqlnq_sel_doid
    sqlnq_select_ofn_sm
    sqlnq_proc_enc
    sqlnq_qtb::add_doid
    sqlnr_addids
    sqlnr_EtoF_action
    
    Workaround: none
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * QUERY WITH TABLES FUNCTIONS AND EXISTENTIAL SUBQUERY MIGHT   *
    * PRODUCE SQL0901N                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * First fixed in fix pack 9                                    *
    ****************************************************************
    

Problem conclusion

  • See Error Description
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC91198

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-29

  • Closed date

    2014-01-08

  • Last modified date

    2014-01-08

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

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

    IC96363 IC96822

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC91198

Modified date:

2014-01-08

Translate my page

Machine Translation

Content navigation