Siebel Installation Guide for UNIX > Configuring the RDBMS > Configuring an IBM DB2 Database for Siebel Business Applications >

Guidelines for Selecting a Language for IBM DB2

As part of database creation, you must set the language characteristics of your database, even if you deploy in only one language.

To do this, you must know in which of the Siebel-supported languages your database runs, the codeset your database uses, the territory for your language, and the sort order (also known as the collation sequence) that your users prefer.

For an IBM DB2 production environment database, you can use any sort order. For a development environment database, you must use binary (identity) sort order.

Setting the language characteristics of the database is part of the sample script in the DBSRVR_ROOT/DB2UDB directory.

For Siebel language support, Unicode support, and legacy code page support, see 1513102.1 (Article ID) for Siebel CRM version 8.1.1.x or 1524342.1 (Article ID) for Siebel CRM version 8.2.2.x on My Oracle Support.

See also Planning RDBMS Installation and Configuration and Specifying the Locale for Siebel Business Applications.

See also Verifying Installation for the Siebel Database.

This topic is part of Configuring an IBM DB2 Database for Siebel Business Applications.


IBM DB2 distinguishes between a code page (also known as a character set) and a codeset. A codeset is defined as a textual string that describes the character encoding standard used for the database, whereas a code page is a numeric representation of the same standard.


The territory, or region, is a combination of the language and the locale; for example, French would be a language example, while Canada or France would be locales in which French is used with regional differences. So, an example of a territory is Canadian French.

Sort Order

The sort order is specified during the initial installation of a database and defines the way in which the database sorts character data. Sort order support depends on both the code page of the database and whether it will be used in a development or a production environment.

For more information about supported sort orders, see the Certifications tab on My Oracle Support.

  • Development environment databases. The repository object names in your development environment database must sort in the same order that they would under the UTF-16 binary sort order, because Siebel Tools uses this sort order internally.

    NOTE:  Binary sort order is the simplest and fastest sort order to perform in the database. Binary sorting is case-sensitive and is based on the numeric values (for example, 0 through 255 for an 8-bit character set) of the characters in the installed character set.

    Customers are responsible for making sure that their data is backed up and restored correctly.

  • Production environment databases. For information about production environment database restrictions, see the Certifications tab on My Oracle Support. See also IBM DB2 documentation.
Siebel Installation Guide for UNIX Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.