PM90171: SQLINCORROUT LESS ROWS RETURNED FROM TABLESPACE WITH BRF FORMAT AND COUNT FUNCTION CONTAINS DISTINCT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Incorrout less rows returned may happen when COUNT function
  which contains DISTINCT with tablespace scan access.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 and DB2 10 for z/OS users of      *
  *                 aggregate functions such as SELECT COUNT     *
  *                 DISTINCT on a VARCHAR NOT NULL column in a   *
  *                 table space or partition that is in Basic    *
  *                 Row Format (BRF)                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrout possible during aggregate     *
  *                      functions such as SELECT COUNT DISTINCT *
  *                      when run on VARCHAR NOT NULL column in  *
  *                      BRF table space or partition            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  For a basic row format (BRF) table space or partition, SELECT
  COUNT DISTINCT on a VARCHAR NOT NULL column returned fewer rows
  than expected.
  
  During the comparison of said column between rows, when a
  workfile was used for sorting, DB2 used a wrong length for
  comparison, off by 1 from what the comparison length should be.
  
  As a result, more rows were 'matching' each other and so fewer
  rows were distinct.
  

Problem conclusion

• DB2 code has been modified to make sure that COUNT DISTINCT on a
  VARCHAR NOT NULL column in a BRF table space or partition uses a
  correct column length when rows are compared to each other.
  
  Additional keywords: SQLINCORROUT SQLINCORR DB2INCORR/K
                       SQLSETFUNCTION SQLCOUNT
  

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:

  UK97025 UK97026

Modules/Macros

• DSNISFRL DSNISFS  DSNISFWL DSNISFX2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK97025

     UP13/09/11 P F309 ½

• RB10 PSY UK97026

     UP13/09/11 P F309 ½

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.