home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT00926 Status: Geschlossen

CONCURRENT LOADS TO THE SAME TABLE MIGHT RESULT IN DEADLOCK

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
The deadlock might happen on two concurrent LOADs to the same 
table when STATISTICS USE PROFILE is specified at least for one 
LOAD. If you monitor the deadlock, such as using EVENT MONITOR, 
you can see that one LOAD is holding a Z TableLock on the loaded 
 table, but waiting for an X RowLock on SYSIBM.SYSTABLES, while 
the other LOAD is holding a U RowLock on SYSIBM.SYSTABLES, but 
waiting for a Z TableLock on the loaded table. After that, one 
LOAD is chosen as victim by DB2 deadlock checking mechanism and 
fails with SQL0911N with reason 2, then the other LOAD can 
proceed. 
 
The problem is caused by statistics collection during LOAD that 
attempts to upgrade current NS RowLock on SYSIBM.SYSTABLES to X 
RowLock. 
 
Although the problem might happen on both row-organized and 
column-organized tables, concurrent LOADs to the same 
column-organized table most likely hit it since STATISTICS USE 
PROFILE is the default for column-organized table.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* The users are running two concurrent LOADs.                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix    * 
* Pack 4) or higher.                                           * 
****************************************************************
Local-Fix:
Prevent from running concurrent LOAD commands to the same table, 
 or running concurrent Loads with explicit "STATISTICS NO" .
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4)
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.04.2014
15.09.2014
14.10.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList