DB2 - Problem description
Problem IC70301 | Status: Closed |
SQL1611W MESSAGE IS SPLIT IN THE MIDDLE OF THE MESSAGE IN CLP. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - 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: * * CLP whose language is set to JA_JP on AIX. * **************************************************************** * 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 DB2 V 9.7 Fix Pack 7. * **************************************************************** | |
Local Fix: | |
Use system language other than UTF-8 for running CLP. | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in Version 9.5 FixPak 7. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC70370 IC70371 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.07.2010 21.12.2010 21.12.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.5., 9.7.FP7 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.7 | |
9.5.0.7 |