DB2

DB2 is IBM's offering to the highend database market. The latest version of DB2 (Universal Database) is ideal for OLTP, Data Warehousing, Decision Support and everything in between. It's well priced, extremely scalable and runs on virtually every platform out there from handhelds to mainframes.

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
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.
Originally Posted by Marcus_A
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?
Originally Posted by Marcus_A
NLS support is for DB2 messages, commands, etc. I doubt you would need this.
You mean National Language Package, not NLS?
Originally Posted by db2girl
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).
Originally Posted by db2girl
You mean National Language Package, not NLS?
Whatever.
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.
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).
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
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.
Do you mean if i installed Simplified Chinese package,
I can enter db2 commands/statements in chinese ???
That's how I understand this, but I could be wrong.

Related Links

st
Adding space to SMS tablespaces - alternatives?
db2inidb through API
How to obtain a lock on the table
Activate not logged initially issue
Page cleaners Tuning
PHP and db2diag command
Recursive query - Help needed...
DB2 Backups, Jobs from Tivoli
FP/DB Upgarade
Usage of LTRIM and RTRIM
DB2/VM and LONG VARCHAR
Physical disk layout and DB2 containers. How to config?
Connection Excption
DB2set command HELP
same value returned by udf for each row

Categories

DataBase Dev
MongoDB
Adabas
DB2
Informix
Microsoft SQL Server
MySQL
Oracle
Pervasive.SQL
PostgreSQL
Sybase
Other
ASP
Crystal Reports
Delphi, C etc
JAVA
Perl and the DBI
PHP
ANSI SQL
Unix Shell Scripts
Visual Basic
Brilliant Database
Corel Paradox
FileMaker
Microsoft Access
Microsoft Excel
Other PC Databases
New Members & Introduc...
Applications & Tools
Database Concepts & De...
Chit Chat
Marketplace
Job Opportunities
Suggestions & Feedback

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App