DB2 FOR LUW / DB2FORLUW / 970 - DB2

Regeneration of view updates the system catalog's. When this 
catalog update is replayed on standby replay only window should 
be enabled but it is not.  Due to this, applications trying to 
access the particular catalog table could see a corrupted LOB 
thus bringing down the standby database. A simple repro that 
could trigger this situation is 
 
create table t1 (c1 int) 
create view v1 as select * from t1 
drop table t1 
create table t1 (c1 int) 
select * from v1

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW HADR users with reads on standby enabled on standby  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* roblem:                                                      * 
* ----------                                                   * 
* Regeneration of a view changes catalog tables and updates    * 
* LOB columns. This is a DDL operation but due to the way it   * 
* is designed it doesn't go through the normal DDL code path.  * 
* When a view is regenerated it's not enabling the Replay Only * 
* Window on Standby.                                           * 
*                                                              * 
* Impact:                                                      * 
* ---------                                                    * 
* When the log's records for the regen view stmt are being     * 
* replayed on standby, readers on standby will not be blocked. * 
* Applications trying to access the particular catalog table   * 
* could see a corrupted LOB thus bringing down the database.   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v97 fixpack 7.                                * 
****************************************************************

One can avoid the issue by manually terminating all applications 
on standby before a regen view is being replayed. No new 
applications should attempt to connect while the view 
regeneration log records are replayed on standby. 
In case, the database is brought down due to the mentioned 
issue, restart the standby database. There should be no impact 
to the database contents. It will come back normal.

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 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

The defect is first fixed in DB2 v97 Fixpack 7

keiner bekannt / siehe Local-Fix

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

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

13.06.2012
20.10.2012
20.10.2012

9.7.FP7