home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC65213 Status: Geschlossen

SECTION EXPLAIN PROCEDURES INCORRECTLY REPORT SUCCESS ON 32-BIT WINDOWS

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The following procedures are the external interface to the 
section explain functionality: 
EXPLAIN_FROM_SECTION 
EXPLAIN_FROM_ACTIVITY 
EXPLAIN_FROM_DATA 
EXPLAIN_FROM_PACKAGE 
 
On 32-bit Windows, these procedures may fail to perform a 
section 
explain (for example, section explain does not work for DDL 
statements because these statements have no access plan), but 
the procedures will still report success rather than returning 
the appropriate error code.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users performing section explain on DB2 LUW on 32-bit        * 
* Windows                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The following procedures are the external interface to the   * 
*                                                              * 
* section explain functionality:                               * 
*                                                              * 
* EXPLAIN_FROM_SECTION                                         * 
*                                                              * 
* EXPLAIN_FROM_ACTIVITY                                        * 
*                                                              * 
* EXPLAIN_FROM_DATA                                            * 
*                                                              * 
* EXPLAIN_FROM_PACKAGE                                         * 
*                                                              * 
*                                                              * 
*                                                              * 
* On Windows NT32, these procedures may fail to perform a      * 
* section                                                      * 
* explain (for example, section explain does not work for DDL  * 
*                                                              * 
* statements because these statements have no access plan),    * 
* but                                                          * 
* the procedures will still report success rather than         * 
* returning                                                    * 
* the appropriate error code.                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 2                        * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows

Lösung
This problem is fixed in DB2 Version 9.7 Fix Pack 2. Once the 
fix is applied, error codes will be properly returned when the 
section explain procedures encounter an error on 32-bit Windows.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
18.12.2009
08.04.2010
08.04.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList