|
Problem IC80733
|
Status: Geschlossen |
INVALID APG XML GENERATED FROM EXPLAIN_SQL STORED PROCEDURE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
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 |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84595
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 09.01.2012
09.11.2012
09.11.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
