DB2 FOR LUW / DB2FORLUW / 970 - DB2

The problem that there is a missing lifeLSN check in the 
sqldUpdateTdirTcb. 
 
In this scenario, we are replaying a pending list log record for 
a table that was later dropped and recreated. Prior to version 
9.7, we fix the page 0 and can infer from the page LSN that we 
don't need to apply the pending list log record. But for 
tablespaces created in 9.7, we may not always be able to fix 
page 0 in recovery because the update to EMP page is not always 
flushed and we can get SQLB_EMP_MAP_INFO_END back.  So the 
lifeLSN check is needed here before we fix page 0.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See error description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.7 fix pack 2.                   * 
****************************************************************

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

The problem was first fixed in DB2 UDB Version 9.7 fix pack 2.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC67479 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

26.03.2010
30.06.2010
30.06.2010

9.7.FP2