IBM Support

IC85988: IN SMP WHEN DOING DISTINCT OR GROUP BY THAT INCLUDES TIMESTAMP COLUMNS, IT IS POSSIBLE THAT DUPLICATE ROWS WILL BE RETURNED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In SMP when doing distinct or group by that includes timestamp
    columns, it is possible that duplicate rows will be returned.
    example:
    select distinct col1(varchar), col2(timestamp) from table
    might return duplicate rows if col1 has values that differ in
    trailing blanks only. (ex: 'A' and 'A    ')
    
    Conditions to encounter this problem:
    - must have SMP enabled (database manager config has the
    parameter INTRA_PARALLEL set to ON)
    - The query degree is > 1 (database config for DFT_DEGREE or the
    CURRENT QUERY DEGREE special register)
    - must have timestamp column as last column in the list , so it
    becomes first column in the hash key
    - must have rows that would have been considered identical and
    the only difference is varchar column that has spaces
    

Local fix

  • turn SMP off, remove trailing blanks or install this fix.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * SMP only                                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Install this fix                                             *
    ****************************************************************
    

Problem conclusion

  • Install this fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC85988

  • 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

    2012-08-20

  • Closed date

    2012-10-20

  • Last modified date

    2012-10-20

  • 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 PSY

       UP

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

Document Information

Modified date:
20 October 2012