DB2 FOR LUW / DB2FORLUW / A50 - DB2

Db2 skips verifying checksum for page from temp table.
For example, index corruption will be occurred in the
following scenario.

1) Start REORG INDEXES command.
2) If sort overflow happens when sorting data of index key,
   Db2 uses temp table.
3) Whilst using temp table and a H/W trouble happens,
   such as bad SFP module of SAN where Db2 temporary
   tablespace resides, corrupted data will be passed to Db2.
4) Db2 doesn't notice data corruption because Db2 skips
   verifying checksum for page from temp table.
5) Corrupted INDEX is created unexpectedly.

* Not only REORG INDEXES but also any SQL may be affected
  whilst it uses temp table and a H/W trouble with it.
* There is no workaround.

****************************************************************
* USERS AFFECTED:                                              *
* DB2 UDB Version 10.5                                         *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Version 10.5 FixPack 10.                          *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

08.01.2018
11.07.2018
11.07.2018