Siebel Installation Guide for Microsoft Windows > Configuring the RDBMS > Configuring an IBM DB2 UDB Database for Siebel Applications >

Guidelines for Creating the DB2 UDB Database

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

If you are installing a database that is to be enabled for Unicode, you must specify UTF-8 as the codeset (including the hyphen). UTF-8 is the parameter used for Unicode implementations on DB2 UDB, although the actual 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.

To create the DB2 UDB database

1. Locate the primary (base) language your database will use, the territory for your language, and the applicable codeset.

   For the values that apply to your language, see Siebel System Requirements and Supported Platforms on Oracle Technology Network.

2. Using the DB2 UDB Command Line Processor, enter the following command:

   db2 create database dbname using codeset territory collate using identity

   where:

   • dbname = The alias for your database
   • codeset = The textual representation of your code page
   • territory = The territory for the language your database runs in, under that codeset