|
Problem IC84480
|
Status: Geschlossen |
REFRESH MQT IN DPF ENVIRONMENT DOESN'T HONOR AN OPTIMIZATION LEVEL, PREVIOUSLY SET WITH SET CURRENT OPTIMIZATION LEVEL CMD |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
Refresh MQT in DPF environement doesn't honor an optimization
level, previously set with SET CURRENT OPTIMIZATION LEVEL
statement. Usually setting lower optimization level is needed to
avoid MQT routing during MQT refresh operation for a base table
with number of MQT to reduce locking and increase concurrency.
Lowering optimization level before REFRESH MQT statement in a
single node environment works as expect, however in DPF
environment current optimization level is not honored by other
nodes thus having them to compile REFRESH MQT statement at the
default optimization level (5). |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V10.1 Fixpak 1 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in DB2 V10.1 Fixpak 1 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 14.06.2012
29.04.2013
29.04.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
