|
Problem IC80733
|
Status: Closed |
INVALID APG XML GENERATED FROM EXPLAIN_SQL STORED PROCEDURE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* DB2 LUW users of db2exfmt with different Server & Client *
* code pages *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade the DB2 Linux, Unix and Windows server to v9.7fp6 or *
* higher. *
**************************************************************** |
| 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 |
Upgrade the DB2 Linux, Unix and Windows server to v9.7fp6 or
higher in order for the output of db2exfmt to contain the
correct output for any of the SQL Statement, predicate text,
column lists, or explain arguments. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84595
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.01.2012
09.11.2012
09.11.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
|
 |
