|
Problem IC65213
|
Status: Closed |
SECTION EXPLAIN PROCEDURES INCORRECTLY REPORT SUCCESS ON 32-BIT WINDOWS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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 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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
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 |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.12.2009
08.04.2010
08.04.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
