Quick Beginnings

Customizing Language Support

By default, DB2 Connect queries the current code page settings for your system and the database. This section tells you how the conversion is checked, gives examples, and tells you how you can customize your DB2 Connect Personal Edition workstation.

Summary

When DB2 Connect connects to a database, the client's code page is passed to the host, which validates the conversion requested between the client code page and the host database code page. (In the case of DB2 Connect DB2 Connect Personal Edition, the client is the DB2 Connect workstation).

If the conversion is not supported, then message SQL30073N is issued. Otherwise, a similar check is then performed by DB2 Connect.

For example, if you are connecting to a DB2 for OS/390 or DB2 for MVS/ESA database that uses host CCSID 930 (Japan), then your PC must be set up to use one of the code pages listed in that row of the table.

Note:

Always set the DB2CODEPAGE environment variable to a value that is supported by the operating system

How to Determine your Workstation Code Page

To determine what the current code page setting is for your DB2 Connect Personal Edition workstation:

Windows 95 and Windows NT

Note that Windows NT supports both OEM and ANSI code pages concurrently. DB2 programs run in the ANSI code page, and (when using DB2 Windows NT) databases are created using the ANSI code page as well. The DOS Command Line Processor runs in the OEM code page but the Windows operating system converts the characters to ANSI code page before connecting to DB2. This type of conversion does not take place from DB2 to the DOS Command Line Processor. To avoid any discrepancies, you can do one of the following:

• Use the Command Center instead of the DOS Command Line Processor

• If you must use the DOS Command Line Processor, do the following:

  1. Set the DB2CODEPAGE environment variable to your OEM code page.

  2. Choose a TrueType font.

  3. Issue the db2.

  4. Enter all your commands from within the DB2 shell.

Refer to your operating system documentation.

Database Configuration

DB2 Universal Database provides you with these database configuration parameters:

Database code page

The code page used to create the database. It is derived from the code set used to create the database.

Database code set

The code set used to create the database.

Database country code

The country code used to create the database. It is derived from the territory used to create the database.

Database territory

The territory used to create the database.

These settings are used by DB2 Connect when a DRDA application requester is used to connect to a DB2 Universal Database server as a DRDA application server.

You can view the settings, as follows. For example, to list the database configuration for the SAMPLE database, enter the following command at a DB2 prompt:

 get db cfg for sample

The output will look similar to this:

       Database Configuration for Database sample
 
 Database configuration release level                    = 0x0600
 Database release level                                  = 0x0600
 
 Database territory                                      = US
 Database code page                                      = 437
 Database code set                                       = IBM-437
 Database country code                                   = 1
 .
 .
 .

For further information, refer to the Quick Beginnings guide for your DB2 server. Note that these database configuration settings should not be changed.

[ DB2 List of Books | Search the DB2 Books ]