IBM Support

IT08816: INCORRECT RESULTS FROM SORT OPERATIONS ON DB2 VERSION 9.7.0.10

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Incorrect results from sort operations might occur when all of
    the following conditions are true:
    - DB2 version 9.7.0.10 (or a special build containing an
    incorrect fix for APAR IT00913) is being used.
    - The sort operation includes more than one column.
    - The sort operation includes one or more VARCHAR or VARCHAR FOR
    BIT DATA columns beyond the first column.
    - The sort operation includes more than 500 records containing
    duplicate data in the columns leading up to the VARCHAR column.
    
    In addition to potential wrong and/or incorrectly ordered
    results being returned to the user based on incorrect sort
    order, it is also possible that the incorrect sort could result
    in an unordered index if the index was created or rebuilt using
    the problematic version of DB2.  This could result in the
    following symptoms:
    - Index errors during insert, update or delete processing.
    - Incorrect results from an index scan.
    - Duplicates being inserted into a unique index.
    
    The db2dart command can be used to detect any unordered
    indexes.
    
    This problem does not exist in v10.1.
    

Local fix

  • To avoid hitting the problem while on an affected built, execute
    the following command and then recycle the instance:
    db2set DB2_BINSORT=off
    
    After applying the workaround above and/or moving to a build
    with this APAR fix, to fix an affected index, execute the
    command above, recycle the instance and then perform one of the
    following actions:
    - Drop and recreate the affected index(es).
    - Execute the REORG INDEXES command without the CLEANUP ONLY
    option to rebuild the affected index(es).
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7.0.11.                             *
    ****************************************************************
    

Problem conclusion

  • The problem is first fixed in DB2 version 9.7.0.11.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT08816

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-05-10

  • Closed date

    2015-10-12

  • Last modified date

    2016-01-29

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

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

    IT09073 IT13280

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN UP

       BYPASS

[{"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":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 January 2016