|
Problem IC84595
|
Status: Closed |
INVALID APG XML GENERATED FROM EXPLAIN_SQL STORED PROCEDURE |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
EXPLAIN_SQL and db2exfmt can generate incomplete SQL statement
text, and predicate text, with some multi-byte National Language
characters missing or truncated. This occurs when there is a
code page difference between the database and the client or
application.
If you see the SQL statement text, predicate text, table names,
or column names displayed incorrectly, this fix should correct
the problem, and cause the text to display properly. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* EXPLAIN_SQL and db2exfmt can generate incomplete SQL *
* statement text, and predicate text, with some multi-byte *
* National Language characters missing or truncated. This *
* occurs when there is a code page difference between the *
* database and the client or application. *
* *
* If you see the SQL statement text, predicate text, table *
* names, or column names displayed incorrectly, this fix *
* should correct the problem, and cause the text to display *
* properly. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v101 fp1 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
fix is delivered to v101 fp1 version |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.06.2012
31.10.2012
31.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
