PI28478: INDEX DEFINE ON ROWID COLUMN, AND PADDED WOULD RETURN 'ROW NOT FOUND', EVEN THOUGH ROWS EXIST.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CREATE INDEX on ROWID column, and index defined as PADDED, then
  it would return 'ROW NOT FOUND', even though rows exist.
  

Local fix

• ALTER INDEX FROM PADDED TO NOT PADDED
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 10 and 11 for z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect output for query with         *
  *                      predicate ROWID.                        *
  *                      DB2 may result in RECORD NOT FOUND for  *
  *                      some records.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 may return RECORD NOT FOUND for some records for query
  with predicate ROWID. For example:
  
  SELECT ...
  FROM T1
  WHERE ROWIDC = ROWID(?);
  

Problem conclusion

• DB2 code has been changed to correct predicate evaluation
  logic.
  

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:

  UI28423 UI28424

Modules/Macros

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

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI28423

     UP15/06/27 P F506 Ž

• RB10 PSY UI28424

     UP15/06/27 P F506 Ž

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.