IBM Support

IT23521: SQL WITH OLAP SPECIFICATION EXECUTED AGAINST COLUMNAR ORGANIZED TABLES COULD PRODUCE INTERMITTENT WRONG RESULT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If query with OLAP specification is executed against Columnar
    Organized Tables,
    and , if OLAP work is done below CTQ lolepop in the plan,
    and if degree chosen for the work is greater then 1,
    then in rare circumstances the query could produce an
    intermittent wrong result.
    
    An example would be that RANK() gives a wrong values for some
    rows in the query that looks like:
    
    select col1, col2, rk, count(col3) as col3_count from
    (select col1, col2, col3, rank() over (partition by col1 order
    by col2) as rk  from cde_table where col1 <= 30) group by col1,
    col2, rk order by col1 asc, col2 asc, rk asc, col3_count desc;
    

Local fix

  • force query to execute with DEGREE=1 by using optimizer
    guidelines
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Columnar Organized Tables Only                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * See Error Description. Please, install this fix.             *
    ****************************************************************
    

Problem conclusion

  • See Error Description. Please, install this fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23521

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-12-15

  • Closed date

    2018-12-09

  • Last modified date

    2018-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

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

Document Information

Modified date:
09 December 2018