IBM Support

PM69181: SQLINCORROUT WITH FETCH FIRST FOR GROUP BY

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Sqlincorrout may happen with FETCH FIRST for GROUP BY.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of queries which   *
    *                 contain a FETCH FIRST clause for GROUP BY    *
    *                 and a column function with a floating-point  *
    *                 argument.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: An incorrect result set can be returned *
    *                      for a query that contains a FETCH FIRST *
    *                      clause for GROUP BY and includes a      *
    *                      column function with a floating-point   *
    *                      argument.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An incorrect result set can be returned for a query that
    contains a FETCH FIRST clause for GROUP BY and includes a column
    function with a floating-point column as an argument.
    
    The problem is caused by the conversion of the FLOAT column
    which can overlay storage following it by 4 bytes since the
    float conversion assumes the output length is 8 bytes.
    
    However, in some situations, the output length may only be 4
    bytes.  The problem has been masked for many releases of DB2
    because the storage contents gets processed from left-to-right;
    the following columns or other sort information would have
    overwritten this area that would have been overlaid.  But for
    the new processing of the FETCH FIRST for GROUP BY, this may not
    be the case because the latter area may be placed in the buffer
    ahead of the float conversion and could now be overlaid by the
    float conversion.
    

Problem conclusion

  • DB2 has been modified to check the final output length of the
    float conversion and move the appropriate length. This will
    prevent the overlay from occurring.
    
    Additional Keywords: SQLGROUPBY SMCOVERLAY DB2OVRLAY/K SQLFLOAT
                         SQLINCORR SQLINCORROUT DB2INCORR/K
                         INCORROUT SQLFFNR
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PM69181

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-18

  • Closed date

    2012-08-13

  • Last modified date

    2012-09-05

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

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

    UK81046

Modules/Macros

  • DSNXSIFG
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK81046

       UP12/08/28 P F208

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
05 September 2012