Guidelines for Creating the IBM DB2 Database

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

If you are installing a Unicode database for IBM DB2, then you must specify UTF-8 as the codeset (including the hyphen). UTF-8 is the parameter used for Unicode implementations on IBM DB2, although the processing will use UCS-2. When you specify UTF-8 as the encoding for the VARCHAR type, the encoding for the VARGRAPHIC type is automatically set to UCS-2, even though UCS-2 is not specified as the parameter.

Verify that your data is exported and imported correctly.

For Siebel CRM language support and Unicode support, see the Certifications tab on My Oracle Support.

To create the IBM DB2 database

Locate the primary (base) language that your database will use, the territory for your language, and the applicable codeset.
Using the DB2 command line processor (Unix) or DB2 command prompt (Windows), enter the following command:
```
db2 create database dbname using codeset territory collate using identity
```
where:
- dbname is the alias for your database
- codeset is the textual representation of your code page
- territory is the territory for the language that your database runs in, under that codeset