IBM Support

IC77111: INCORRECT OUTPUT MIGHT BE RETURNED FOR QUERIES CONTAINING A DISTINCT CLAUSE AND DBPARTITIONNUM FUNCTION IN THE SELECT LIST.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • You might encounter incorrect output from a SQL statement that
    satisfies all the following conditions:
    
    1.  a DISTINCT clause in the SELECT list;
    2.  two or more references to table T;
    3.  if there are k >1 references to table T and a DBPARTITIONNUM
    function in the SELECT list on <= k-1 of the references to T
    4.  A restriction on the set of database partitions in the WHERE
    clause (e.g. DBPARTITIONNUM(T.a)=0) on the references to T on
    which the DBPARTITIONNUM function in the select list applies
    

Local fix

  • Modify the statement by moving the multiple references to table
    T into separate query blocks.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Problem occurs in DPF environment only.                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * You might encounter incorrect output from a SQL statement    *
    * that                                                         *
    * satisfies all the following conditions:                      *
    *                                                              *
    *                                                              *
    *                                                              *
    * 1.  a DISTINCT clause in the SELECT list;                    *
    *                                                              *
    * 2.  two or more references to table T;                       *
    *                                                              *
    * 3.  if there are k >1 references to table T and a            *
    * DBPARTITIONNUM                                               *
    * function in the SELECT list on <= k-1 of the references to T *
    *                                                              *
    * 4.  A restriction on the set of database partitions in the   *
    * WHERE                                                        *
    * clause (e.g. DBPARTITIONNUM(T.a)=0) on the references to T   *
    * on                                                           *
    * which the DBPARTITIONNUM function in the select list applies *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 5                        *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 Version 9.7 Fix Pack 5
    

Temporary fix

  • see LOCAL FIX
    

Comments

APAR Information

  • APAR number

    IC77111

  • 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

    2011-06-22

  • Closed date

    2011-12-09

  • Last modified date

    2011-12-09

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC77111

Modified date: 09 December 2011