home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)