April 09, 2013

Red Alert: Potential data loss in DB2 10 data sharing environment

On March 25, IBM posted a Red Alert for customers running DB2 10 for z/OS data sharing environment. See this detailed description.

In summary,  PTF UK91435 must be applied as soon as possible to avoid a potential data loss. The problem occurs during data modifications with insertions and mass deletes. The data may not be recoverable using standard recovery procedures. However, the changes are recorded to the DB2 log, so a log analyzer tool can be used to rebuild the redo statements.

The best way to determine if you have a problem is to run the CHECK INDEX or CHECK DATA utilities. Any issues uncovered should be reported to IBM Software Support to determine root cause.

Additional information can be found in APAR PM79520.