PI31161: SQL SELECT STATEMENT DOES NOT RETURN CORRECT NUMBER OF ROWS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Select from sysibm.sysviews does not return correct rumber of
  rows.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users using UNIQUE, NOT  *
  *                 PADDED indexes.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Index query access may return less rows *
  *                      than actually qualify when index is     *
  *                      defined UNIQUE, NOT PADDED and has at   *
  *                      least one varying-length column.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Index query access may return less rows than actually qualify
  when index is defined UNIQUE, NOT PADDED and has at least one
  varying-length column.
  
  An error in the index selection expression comparison
  routine caused less rows to qualify. The routine failed to
  handle index keys with reserved space.
  Note: DSN1PRNT with FORMAT option will display key(s)
  with reserve space ("RESERVE SPACE").
  
  Additional keywords: DB2INCORR/K, INCORROUT, SQLINCORR,
                       SQLINCORROUT, SQLINDEXONLY
                       SQLRESERVESPACE
  

Problem conclusion

• Index selection expression comparison routine has been updated
  to correctly compare index keys defined on UNIQUE, NOT PADDED
  index.
  

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:

  UI26094

Modules/Macros

•    DSNIONX2 DSNIOST2 DSNIRIDL DSNISFX2 DSNIXLDI
  DSNKFLRR DSNKFLST DSNKFPRV DSNKFTCH DSNKFTRR DSNKGSEL DSNKNXT2
  DSNOLDEL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI26094

     UP15/04/04 P F504 Ž

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.