DB2 - Problembeschreibung
Problem IC64261 | Status: Geschlossen |
ADMIN FUNCTION ADMIN_EST_INLINE_LENGTH SOMETIMES MIGHT INCORRECTLY RETURN -1 INSTEAD OF THE ESTIMATED INLINED LENGTH | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
The admin function ADMIN_EST_INLINE_LENGTH might sometimes return a -1 instead of the estimated inlined length. The problem will surface when the estimated inlined length is closed to the page size limit, and it will be triggered by the presence of 'ORDER BY' in the query. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See APAR information * **************************************************************** * RECOMMENDATION: * * Customers need to upgrade to V97FP2. * **************************************************************** | |
Local-Fix: | |
remove 'ORDER BY' from the query | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
This problem is fixed in V97FP2 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 29.10.2009 13.05.2010 13.05.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |