PI23551: SQLINCORROUT MORE ROWS RETURNED WHEN QUERY USES INDEX WHICH IS DEFINED WITH INCLUDE COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Sqlincorrout more rows returned may happen when query uses index
  which is defined with INCLUDE column.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL DB2 10 and DB2 11 for z/OS users using   *
  *                 UNIQUE indexes and INCLUDE columns are       *
  *                 present.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLERRD(3) in SQLCA was incorrectly set *
  *                      during SQL UPDATE and UNIQUE INDEX with *
  *                      INCLUDE column(s) was used.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SQLERRD(3) in SQLCA, number of rows affected, was incorrectly
  set during SQL UPDATE and UNIQUE INDEX with INCLUDE column(s)
  was used.
  
  The key comparison routine incorrectly compared the INCLUDE
  portion of the key and caused rows counter to incorrectly
  increase.
  
  
  Additional Keywords: DB2INCORR/K, INCORROUT, SQLINCORROUT
                       SQLINCLUDE, SQLUPDATE
  

Problem conclusion

• The index key comparison routine has been updated to correctly
  compare keys when INCLUDE columns are present during an SQL
  UPDATE.
  

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:

  UI27053 UI27054

Modules/Macros

•    DSNKBULD DSNKCEST DSNKDLE  DSNKFLRR DSNKFLST
  DSNKFPRV DSNKFTCH DSNKFTRR DSNKINSL DSNKLFPR DSNKLOD2 DSNKNXT2
  DSNKPOSI DSNKREST DSNKTRAV
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI27053

     UP15/05/09 P F505 Ž

• RB10 PSY UI27054

     UP15/05/09 P F505 Ž

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.