DB2 FOR LUW / DB2FORLUW / 970 - DB2

During SWAP operation, all the objects created by 
ADMIN_MOVE_TABLE during startup, will be cleaned. We can end up 
in a situation, where the drop UDI trigger operations on the 
source table are rolled back due to a -911 RC 68 SQL error. All 
the other objects like staging table are removed successfully, 
which leaves the UDI triggers in state inoperative on the new 
target table. The SQL911 error is never reported back to the end 
user, thus the SWAP operation finishes with success.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 10.                      * 
****************************************************************

Manually drop the ADMIN_MOVE_TABLE UDI triggers from the target 
table after the SWAP operation finished successfully.

First fixed in DB2 Version 9.7 Fix Pack 10.

keiner bekannt / siehe Local-Fix

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

04.07.2014
09.12.2014
09.12.2014

9.7.FP10