DB2 - Problem description
Problem IC70371 | Status: Closed |
SQL1611W MESSAGE IS SPLIT IN THE MIDDLE OF THE MESSAGE IN CLP. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
Problem description: | |
The message text of SQL1611W is split into two lines when the database is activated. This phenomenon is seen when the system language is Japanese and the character encoding was UTF-8 (i.e. LANG=JA_JP for AIX). It does not happen for the character encoding is shift JIS or EUC-JP. Example reproduction scenario on AIX: (The second output of SQL1611W is correct.) $ env | grep LANG LANG=JA_JP $ db2start SQL1063N DB2START $ db2 list application SQL1611W <Japanese text1> <Japanese text2> $ db2 activate db sample DB20000I ACTIVATE DATABASE $ db2 list application SQL1611W <Japanese text1><Japanese text2> $ | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * User using with Japanese language on the system with code * * page is UTF-8. * **************************************************************** * PROBLEM DESCRIPTION: * * The message text of SQL1611W is split into two lines when * * the * * database is activated. * * * * This phenomenon is seen when the system language is Japanese * * and * * the character encoding was UTF-8 (i.e. LANG=JA_JP for AIX). * * * * It does not happen for the character encoding is shift JIS * * or * * EUC-JP. * * * * * * * * Example reproduction scenario on AIX: (The second output of * * * * SQL1611W is correct.) * * * * * * * * $ env | grep LANG * * * * LANG=JA_JP * * * * $ db2start * * * * SQL1063N DB2START * * * * $ db2 list application * * * * SQL1611W <Japanese text1> * * * * <Japanese text2> * * * * $ db2 activate db sample * * * * DB20000I ACTIVATE DATABASE * * * * $ db2 list application * * * * SQL1611W <Japanese text1><Japanese text2> * * * * $ * **************************************************************** * RECOMMENDATION: * * Upgrade to V9.8 Fix Pack 4. * **************************************************************** | |
Local Fix: | |
Use system language other than UTF-8 for running CLP. | |
Solution | |
Problem was fixed first in V9.8 Fix Pack 4. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.08.2010 24.06.2011 24.06.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.8.FP4 | |
Problem solved according to the fixlist(s) of the following version(s) |