|
Problem IC79853
|
Status: Closed |
UNSUPPORTED SERVER FEATURES ARE REPORTED AS SUPPORTED FOR IDS AND DB2 ISERIES SERVERS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Following server features are reported as supported even though
they are not:
DECFLOAT and Optimistic locking on IDS
XML strings on DB2 iSeries V6
This incorrect feature reporting can cause sending incorrect
queries to the server, which will result in server errors,
although these can be prevented on the client beforehand. For
example .NET would allow to insert decfloat value into a column,
which would fail at the server, instead of throwing NotSupported
exception immediately without involving the server at all. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All DB2 Version 9.7 Fix Pack 3 to Fix Pack 5 clients on *
* Linux, Unix, and Windows platforms attempting to use these *
* features on the specified servers. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Following server features are reported as supported even *
* though they are not: *
* DECFLOAT and Optimistic locking on IDS *
* XML strings on DB2 iSeries V6 *
* *
* This incorrect feature reporting can cause sending incorrect *
* queries to the server, which will result in server errors, *
* although these can be prevented on the client beforehand. *
* For example .NET would allow to insert decfloat value into a *
* column, which would fail at the server, instead of throwing *
* NotSupported *
* exception immediately without involving the server at all. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 6 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
The problem is first fixed in DB2 Version 9.7 Fix Pack 6 and all
subsequent Fix Packs. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.11.2011
05.06.2012
05.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
