DB2 FOR LUW / DB2FORLUW / 970 - DB2

Tests has shown that replaying deletes is much slower than 
replaying inserts on the same table using the 
SYSPROC.ADMIN_MOVE_TABLE procedure. 
The root cause is the WITH RR clause that is used during 
replaying of the rows. 
 
This apar will address this performance gap, by avoiding the 
need to use the WITH RR clause inside the ADMIN_MOVE_TABLE 
procedure. ( when used with the REPLAY option ).

**************************************************************** 
* USERS AFFECTED:                                              * 
* SYSPROC.ADMIN_MOVE_TABLE routine users                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Routine SYSPROC.ADMIN_MOVE_TABLE  has slow performance       * 
* during the replay delete step.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade DB2 server to V9.7 fixpak 4.                         * 
****************************************************************

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 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
 

This problem was first fixed in V9.7 fixpak 4

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC73388 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

05.11.2010
24.05.2011
24.05.2011

9.7.