|
Problem IC76426
|
Status: Geschlossen |
CONCURRENCY ISSUE WHEN FLUSHING TWO OPTIMIZATION PROFILES |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
When two different optimization profiles are flushed
concurrently, the latter one will need to wait for the first one
to release the lock, although that they are for two different
optimization profiles.
This can happen with two different connections issuing FLUSH
OPTIMIZATION PROFILE on different optimization profiles if they
are not already in the cache. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All DB2 Version 9.7 Fix Pack 4 and earlier servers on Linux, *
* Unix, and Windows platforms issuing the FLUSH OPTIMIZATION *
* PROFILE command. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When two different optimization profiles are flushed, the *
* latter *
* one will need to wait for the first one to release the lock, *
* *
* although that they are in two different optimization *
* profiles. *
* This can happen with two different connections issuing DB2 *
* FLUSH *
* OPTIMIZATION PROFILE on different optimization profiles if *
* they *
* are not already in the cache. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 5 or refer to Local Fix. *
**************************************************************** |
| Local-Fix: |
Issue the FLUSH OPTIMIZATION PROFILE commands sequentially. |
| verfügbare FixPacks: |
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
|
| Lösung |
The problem is first fixed in DB2 Version 9.7 Fix Pack 5 and all
subsequent Fix Packs. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 16.05.2011
24.05.2011
24.05.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
