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 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
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 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 FixList
9.5.0.7 FixList