|
Problem IC98073
|
Status: Geschlossen |
DEADLOCK MAY OCCUR SURROUNDING ANONYMOUS BLOCKS PACKAGES WHEN DB2ABC (APM CACHE CLEANUP) AND DDL STATEMENT RUN CONCURRENTLY. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
Deadlock cycle can happens when:
One agent performs DDL on an object which the ANONYMOUS BLOCK
depends on.
This results in the agent getting a lock on a SYSPLANDEP row
and then getting the package lock while
invalidating the package.
The 2nd agent performs Cache space management, while ejecting
the ANONYMOUS block package,
It first acquires the package lock exclusively then attempt to
remove the row in SYSPLAN DEP.
In a timing window it is clear how the deadlock cycle can be
completed. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to versino 10.1 Fixpack 4 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in version 10.1 fix pack 4 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 03.12.2013
27.06.2014
27.06.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.4
|
 |
