|
Problem IC63122
|
Status: Closed |
ADMIN_MOVE_TABLE DATA LOSS DUE TO TRIGGERS NOT FIRING FOR CURREN TLY EXECUTING OR PREPARED STATEMENTS AGAINST THE SOURCE TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
In ADMIN_MOVE_TABLE during the INIT phase, a number of triggers
are created on the source table to capture any data changes. In
v97, CREATE TRIGGER uses soft invalidation instead of hard
invalidation. This means that any currently executing or
prepared statements against the source table can execute without
firing the triggers, with the end result being data loss during
the REPLAY phase. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of ADMIN_MOVE_TABLE *
****************************************************************
* PROBLEM DESCRIPTION: *
* In ADMIN_MOVE_TABLE during the INIT phase, a number of *
* triggers are created on the source table to capture any data *
* changes. In v97, CREATE TRIGGER uses soft invalidation *
* instead of hard invalidation. This means that any currently *
* executing or prepared statements against the source table *
* can execute without firing the triggers, with the end result *
* being data loss during the REPLAY phase. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to FP1 for v97 to get the fix. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 10 for Linux, UNIX, and Windows
|
| Solution |
At the end of the INIT phase drive a hard invalidation of all
currently executing or prepared statements against the table. By
doing this those changes will be picked up by the triggers,
eliminating the data loss. Upgrade to FP1 for v97 to get the
fix. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.09.2009
16.02.2010
16.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
