|
Problem IC73778
|
Status: Geschlossen |
ADMIN_MOVE_TABLE STORED PROCEDURE PERFORMANCE ENHANCEMENT |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
ADMIN_MOVE_TABLE uses COALESCE for triggers and replaying rows
if the index that is used for replaying values has nullable
columns .
COALESCE affects the query optimizer decision not to choose an
equal start/stop predicate. In addition, double binding the
same value twice in statements that have parameter markers also
suppress this query optimization as the optimizer cannot know
that the parameter marker point to the same value. Not using the
start/stop predicate cause significant performance penalty if
nullable columns are involved. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* ADMIN_MOVE_TABLE uses COALESCE for triggers and replaying *
* rows *
* if the index that is used for replaying values has nullable *
* *
* columns . *
* *
* COALESCE affects the query optimizer decision not to *
* choose an *
* equal start/stop predicate. In addition, double binding the *
* *
* same value twice in statements that have parameter markers *
* also *
* suppress this query optimization as the optimizer cannot *
* know *
* that the parameter marker point to the same value. Not using *
* the *
* start/stop predicate cause significant performance penalty *
* if *
* nullable columns are involved. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 FixPak 5 *
**************************************************************** |
| Local-Fix: |
n/a |
| 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 |
First fixed in DB2 v 9.7 FixPak 5 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 11.01.2011
06.02.2012
06.02.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
