|DB2 Version 7 is available in English, French, German, Italian, Spanish, |Brazilian Portuguese, Japanese, Korean, Simplified Chinese, Traditional Chinese, |Danish, Finnish, Norwegian, Swedish, Czech, Dutch, Hungarian, Polish, Turkish, |Russian, Bulgarian, and Slovenian.
|On UNIX-based platforms, the DB2 product messages and library can be installed |in several different languages. The DB2 installation utility lays down the |message catalog file sets into the most commonly used locale directory for |a given platform as shown in the following tables. Table 4 provides |information for AIX, HP-UX, and Solaris. Table 5 provides |information for Linux, Linux/390, SGI, and Dynix.
|
Operating System | AIX | HP-UX | Solaris | |||
Language | Locale | Cde Pg | Locale | Cde Pg | Locale | Cde Pg |
French | fr_FR
Fr_FR | 819
850 | fr_FR.iso88591
fr_FR.roman8 | 819
1051 | fr | 819 |
German | de_DE
De_DE | 819
850 | de_DE.iso88591
de_DE.roman8 | 819
1051 | de | 819 |
Italian | it_IT
It_IT | 819
850 | it_IT.iso88591
it_IT.roman8 | 819
1051 | it | 819 |
Spanish | es_ES
Es_ES | 819
850 | es_ES.iso88591
es_ES.roman8 | 819
1051 | es | 819 |
Brazilian Portu- guese | pt_BR | 819 |
|
| pt_BR | 819 |
Japanese | ja_JP
Ja_JP | 954
932 | ja_JP.eucJP | 954 | ja | 954 |
Korean | ko_KR | 970 | ko_KR.eucKR | 970 | ko | 970 |
Simplified Chinese | zh_CN
Zh_ CN.GBK | 1383
1386 | zh_CN.hp15CN | 1383 | zh | 1383 |
Traditional Chinese | zh_TW
Zh_TW | 964
950 | zh_TW.eucTW
zh_TW.big5 | 964
950 | zh_TW
zh_TW.BIG5 | 964
950 |
Danish | da_DK
Da_DK | 819
850 | da_DK.iso88591
da_DK.roman8 | 819
1051 | da | 819 |
Finnish | fi_FI
Fi_FI | 819
850 | fi_FI.iso88591
fi_FI.roman8 | 819
1051 | fi | 819 |
Norwegian | no_NO
No_NO | 819
850 | no_NO.iso88591
no_NO.roman8 | 819
1051 | no | 819 |
Sweden | sv_SE
Sv_SE | 819
850 | sv_SE.iso88591
sv_SE.roman8 | 819
1051 | sv | 819 |
Czech | cs_CZ | 912 |
|
|
|
|
Hungarian | hu_HU | 912 |
|
|
|
|
Polish | pl_PL | 912 |
|
|
|
|
Dutch | nl_NL
Nl_NL | 819
850 |
|
|
|
|
Turkish | tr_TR | 920 |
|
|
|
|
Russian | ru_RU | 915 |
|
|
|
|
Bulgarian | bg_BG | 915 | bg_BG.iso88595 | 915 |
|
|
Slovenian | sl_SI | 912 | sl_SI.iso88592 | 912 | sl_SI | 912 |
|
|Table 5. Linux, Linux/390, SGI, Dynix
Operating System | Linux | Linux/390 | SGI | Dynix | ||||
Language | Locale | Cde Pg | Locale | Cde Pg | Locale | Cde Pg | Locale | Cde Pg |
French | fr | 819 | fr | 819 |
|
| fr | 819 |
German | de | 819 | de | 819 |
|
| de | 819 |
Italian |
|
|
|
|
|
| es | 819 |
Spanish |
|
|
|
|
|
|
|
|
Brazilian Portuguese |
|
|
|
|
|
|
|
|
Japanese | ja_JP.ujis | 954 | ja_JP.ujis | 954 |
|
| ja_JP.EUC | 954 |
Korean | ko | 970 | ko | 970 | ko_KO.euc | 970 |
|
|
Simplified Chinese | zh zh_CN.GBK | 1386 | zh zh_CN.GBK | 1386 |
|
|
|
|
Traditional Chinese | zh_TW.Big5 | 950 | zh_TW.Big5 | 950 |
|
|
|
|
Danish |
|
|
|
|
|
|
|
|
Finnish |
|
|
|
|
|
|
|
|
Norwegian |
|
|
|
|
|
|
|
|
Sweden |
|
|
|
|
|
|
|
|
Czech |
|
|
|
|
|
|
|
|
Hungarian |
|
|
|
|
|
|
|
|
Polish |
|
|
|
|
|
|
|
|
Dutch |
|
|
|
|
|
| nl | 819 |
Turkish |
|
|
|
|
|
|
|
|
Russian |
|
|
|
|
|
|
|
|
Bulgarian |
|
|
|
|
|
|
|
|
Slovenian |
|
|
|
|
|
|
|
|
|If your system uses the same code pages but different locale names than |those provided above, you can still see the translated messages by creating |a link to the appropriate message directory.
|For example, if your AIX machine default locale is ja_JP.IBM-eucJP and the code page of ja_JP.IBM-eucJP is 954, you can |create a link from /usr/lpp/db2_07_01/msg/ja_JP.IBM-eucJP |to /usr/lpp/db2_07_01/msg/ja_JP by issuing the following |command:
|ln -s /usr/lpp/db2_07_01/msg/ja_JP /usr/lpp/db2_07_01/msg/ja_JP.IBM-eucJP
|After the execution of this command, all DB2 messages come up in Japanese.
|The Control Center, Control Center Help and documentation filesets are |placed in the following directories on the target workstation: |
|Control Center file sets are in Unicode code page. Documentation and Control |Center help file sets are in a browser-recognized code set. If your system |uses a different locale name than the one provided, you can still run the |translated version of the Control Center and see the translated version of |help by creating links to the appropriate language directories.
|For example, if your AIX machine default locale is ja_JP.IBM-eucJP, you can create links from /usr/lpp/db2_07_01/cc/ja_JP.IBM-eucJP to /usr/lpp/db2_07_01/cc/ja_JP |and from /usr/lpp/db2_07_01/doc/ja_JP.IBM-eucJP to /usr/lpp/db2_07_01/doc/ja_JP |by issuing the following commands:
|
|After the execution of these commands, the Control Center and help text |come up in Japanese.
Please ensure that the locale of the DB2 Administration Server instance is compatible to the locale of the DB2 instance. Otherwise, the DB2 instance cannot communicate with the DB2 Administration Server.
If the LANG environment variable is not set in the user profile of the DB2 Administration Server, the DB2 Administration Server will be started with the default system locale. If the default system locale is not defined, the DB2 Administration Server will be started with code page 819. If the DB2 instance uses one of the DBCS locales, and the DB2 Administration Server is started with code page 819, the instance will not be able to communicate with the DB2 Administration Server. The locale of the DB2 Administration Server and the locale of the DB2 instance must be compatible. For example, on a Simplified Chinese Linux system, "LANG=zh_CN" should be set in the DB2 Administration Server's user profile.
|DB2 UDB supports the Baltic Rim code page, MS-1257, on Windows 32-bit operating |systems. This code page is used for Latvian, Lithuanian, and Estonian.
|Within the section titled "Deriving Code Page Values," change the |first paragraph, from:
|However, it is not necessary to set the DB2CODEPAGE registry variable, |because DB2 will determine the appropriate code page value from the operating |system.
|to: Normally, you do not need to set the DB2CODEPAGE registry variable |because DB2 automatically derives the code page information from the operating |system.
|Within the section titled "Country Code and Code Page Support," add |the following information to the table:
| Code Country | Page Group Code-Set Tr. Code Locale OS Country Name | ---- ----- -------- -- --- ----- ---- --------------- | 943 D-1 IBM-943 JP 81 ja_JP.PCK Sun Japan
|Within the section titled "Character Sets" and the subsection "Character Set for Identifiers," replace the last two sentences in the first |paragraph with the following:
|Use special characters #, @, and $ with care in an |NLS environment because they are not included in the NLS host (EBCDIC) invariant |character set. Characters from the extended character set can also be used, |depending on the code page that is being used. If you are using the database |in a multiple code page environment, you must ensure that all code pages support |any elements from the extended character set you plan to use.