Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

    Unanswered: National Language Package

    I'm trying to understand when one would need to install a National Language Package. On the servers where I did the install using db2_install, there is only (it doesn't get installed with db2_install):

    xxxxx:/opt/IBM/db2/V9.7/install>$ ./db2ls -q -a -b /opt/IBM/db2/V9.7 | grep -i messages
    DB2_PRODUCT_MESSAGES_EN 9.7.0.5 5 Product Messages - English


    I was told that on some servers, we need this package but they don't know why. Example from the server where it's installed:



    xxxxx:/opt/IBM/db2/V9.5/install> ./db2ls -q -a -b /opt/IBM/db2/V9.5 | grep -i messages
    DB2_PRODUCT_MESSAGES_EN 9.5.0.8 8 Product Messages - English
    DB2_PRODUCT_MESSAGES_BR 9.5.0.8 8 Product Messages - Portuguese - Brazil
    DB2_PRODUCT_MESSAGES_CN 9.5.0.8 8 Product Messages - Simplified Chinese
    DB2_PRODUCT_MESSAGES_CZ 9.5.0.8 8 Product Messages - Czech
    DB2_PRODUCT_MESSAGES_DE 9.5.0.8 8 Product Messages - German
    DB2_PRODUCT_MESSAGES_ES 9.5.0.8 8 Product Messages - Spanish
    DB2_PRODUCT_MESSAGES_FR 9.5.0.8 8 Product Messages - French
    DB2_PRODUCT_MESSAGES_IT 9.5.0.8 8 Product Messages - Italian
    DB2_PRODUCT_MESSAGES_JP 9.5.0.8 8 Product Messages - Japanese
    DB2_PRODUCT_MESSAGES_KR 9.5.0.8 8 Product Messages - Korean
    DB2_PRODUCT_MESSAGES_PL 9.5.0.8 8 Product Messages - Polish
    DB2_PRODUCT_MESSAGES_RU 9.5.0.8 8 Product Messages - Russian
    DB2_PRODUCT_MESSAGES_TW 9.5.0.8 8 Product Messages - Traditional Chinese



    What's the purpose of this National Language Package? Is it just for this?
    IBM DB2 9.7 Information Center for Linux, UNIX, and Windows


    Is this package required for NLS? I don't think so.
    National Language Support | DB2 LUW wiki on DBPedias | All your database are belong to you

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You probably need UNICODE support when creating a database (UTF-8 is now default on all new databases in 9.7 and maybe before that, I don't recall). This enables you to store other character sets in data columns.

    NLS support is for DB2 messages, commands, etc. I doubt you would need this.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by Marcus_A View Post
    You probably need UNICODE support when creating a database (UTF-8 is now default on all new databases in 9.7 and maybe before that, I don't recall). This enables you to store other character sets in data columns.
    I don't need to install any additional packages to have UNICODE support, right?


    Quote Originally Posted by Marcus_A View Post
    NLS support is for DB2 messages, commands, etc. I doubt you would need this.

    You mean National Language Package, not NLS?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by db2girl View Post
    I don't need to install any additional packages to have UNICODE support, right?
    No, just make sure database is UTF-8, which is the default for new databases (but check your old ones).

    Quote Originally Posted by db2girl View Post
    You mean National Language Package, not NLS?
    Whatever.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    This National Language Package is just to display DB2 messages, commands, GUI stuff, etc.. in a different language and nothing else? Then I don't understand why they said we need this package.

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I have no idea who told you that, or why they told you that. Based on what you have described that you inherited as a DBA, it doesn't sound like they know what they are talking about (whoever "they" is).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    Nov 2011
    Posts
    334
    Maybe these packages are not required。
    I am chinese and we did not install this package:
    "DB2_PRODUCT_MESSAGES_CN 9.5.0.8 8 Product Messages - Simplified Chinese"
    but it works well。。。。。
    XXXXXXXXX:/opt/IBM/db2/V9.7/install]$db2ls -q -a -b /opt/IBM/db2/V9.7 | grep -i messages
    DB2_PRODUCT_MESSAGES_EN 9.7.0.3 3 Product Messages - English

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    they = my co-workers. I have no idea why we need this package, it sounds like we don't.


    fengsun, Based on my understanding, you only need this package if you want to work with db2 in your own language. If you enter all db2 commands/statements in English (and the output is in English), then it's not needed.

  9. #9
    Join Date
    Nov 2011
    Posts
    334
    Do you mean if i installed Simplified Chinese package,
    I can enter db2 commands/statements in chinese ???

  10. #10
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    That's how I understand this, but I could be wrong.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •