DB2 - Problem description
Problem IC77828 | Status: Closed |
IMPLEMENTING DB2TOP WITH OPTION -NO_MAP_CHAR WHICH WAS INTRODUCED TO DB2EXFMT | |
product: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problem description: | |
When using db2exfmt for explain plan with languages other than English, the statement was not formatted correctly. There are gaps inserted into the plan because of unprintable characters used . Option to format the plan correctly was to use "-no_map_char" with db2exfmt. When we run db2top in the following steps: db2top -d <databasename> * Use l option to list the application * Choose an agent of SQL application using option 'a' * Use option 'x' to generate explain plan db2top ends up calling db2exfmt for an explain plan. However we can not enter the option of "-no_map_char", Therefore the output is not formatted correctly. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Every version that runs db2top * **************************************************************** * PROBLEM DESCRIPTION: * * See problem description above * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 9.1 Fix Pack 11 or later version * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows | |
Solution | |
First Fixed in Version V9.1 Fix pack 11 | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC78084 IC78085 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.07.2011 23.12.2011 23.12.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.1.FP11 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.11 |