|
Problem IC70370
|
Status: Closed |
SQL1611W MESSAGE IS SPLIT IN THE MIDDLE OF THE MESSAGE IN CLP. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* Database having a code page, LANG=JA_JP. *
****************************************************************
* 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 Version 9.7 Fix pack 4. *
**************************************************************** |
| Local Fix: |
Use system language other than UTF-8 for running CLP. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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 |
Problem was first fixed in Version 9.7 Fix Pack 4. |
| Workaround |
Use system language other than UTF-8 for running CLP. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.08.2010
09.05.2011
09.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
