PM69181: SQLINCORROUT WITH FETCH FIRST FOR GROUP BY

Obtain the fix for this APAR.

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