home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT10151 Status: Closed

ADMIN_MOVE_TABLE REPLAY ACQUIRES HUGE AMOUNT OF LOCKS ON STAGING TABLE
WHICH CAN TRIGGER LOCK ESCALATION

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
ADMIN_MOVE_TABLE REPLAY acquires for each row in staging table a 
lock. If the staging table is large this can trigger a lock 
escalation on the staging table. Workload accessing the source 
has to wait until next commit of REPLAY to continue. This slows 
down processing on source table significantly.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 11.                      * 
****************************************************************
Local Fix:


Solution


First fixed in DB2 Version 9.7 Fix Pack 11.


Workaround


not known / see Local fix


Timestamps


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

17.07.2015
19.10.2015
19.10.2015


Problem solved at the following versions (IBM BugInfos)


9.7.FP11



Problem solved according to the fixlist(s) of the following version(s)


9.7.0.11

FixList