IBM Support

IC70370: SQL1611W MESSAGE IS SPLIT IN THE MIDDLE OF THE MESSAGE IN CLP.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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>
    $
    

Local fix

  • Use system language other than UTF-8 for running CLP.
    

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.                       *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.7 Fix Pack 4.
    

Temporary fix

  • Use system language other than UTF-8 for running CLP.
    

Comments

APAR Information

  • APAR number

    IC70370

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-08-04

  • Closed date

    2011-05-09

  • Last modified date

    2011-05-09

  • APAR is sysrouted FROM one or more of the following:

    IC70301

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC70370

Modified date: 09 May 2011