IC94297: RANGE PARTITIONED TABLES DEFINED WITH A NULLS FIRST PARTITIONING COLUMN MIGHT RETURN UNORDERED DATA

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Queries using a range partitioned table defined with a NULLS
    FIRST partitioning column, a partitioned index, and NULL values
    in the data might return unordered data.
    
    When the query contains no predicates on the column defined as
    NULLS FIRST and specifies an ORDER BY clause containing the
    columns of the partitioned index, then the NULL values are
    interspersed with other data from the table instead of being
    output at the end of the result set.
    
    The partitioned index must be used in the access plan and the
    access plan must not contain a SORT.
    

Local fix

  • Drop the relevant index or convert it a non-partitioned index or
    change the sequence or direction of columns used in the ORDER BY
    clause so that they do not exactly match to the index.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to DB2 LUW version 9.7 Fix Pack 9.                    *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 LUW version 9.7 Fix Pack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC94297

  • 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-07-22

  • Closed date

    2013-12-17

  • Last modified date

    2013-12-17

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

    IC93059

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC94297

Modified date:

2013-12-17

Translate my page

Machine Translation

Content navigation