Implementing Siebel Business Applications on DB2 for z/OS > Migrating a Siebel Database to Unicode Format >

Requirements for Migrating the Siebel CRM Database to Unicode

The tasks described in this topic are a step in the Roadmap for Migrating the Siebel Database to Unicode.

Before you can migrate your Siebel CRM ASCII or EBCDIC database to a Unicode database, you must perform the prerequisite tasks described in this topic.

1. Install Innovation Pack 2015, Patchset 5.
2. Ensure that the target environment you are migrating to is a DB2 for z/OS subsystem. The Unicode data conversion process fails if these minimum requirements are not met.
3. Verify that the Group codes in the Siebel Repository and the DB2 Catalog are consistent.

   Review the Group names in the schema.ddl file for your existing ASCII or EBCDIC database and verify that they match the table space names in the storage control file for your existing database. If they match, proceed to Step 4. If they do not match, do the following:

   1. Run the following SQL statement to update S_TABLE with the group codes from the catalog:

   UPDATE source_tableowner_name.S_TABLE A
   SET A.GROUP_CD = (SELECT B.TSNAME
   FROM SYSIBM.SYSTABLES B
   WHERE A.NAME = B.NAME AND B.CREATOR = 'source_tableowner_name')

   where source_tableowner_name is your Siebel schema qualifier name.

   2. Remove the diccache.dat file from your SIEBSRVR_ROOT\bin directory (Windows) or the SIEBSRVR_ROOT/bin directory (UNIX).
4. Extract the storage control file for your existing Siebel ASCII or EBCDIC database.

   The extracted file contains definitions of the physical layout of your existing Siebel database and is used to generate the DDL to build the Unicode database schema.

   For information on extracting a storage control file using the Database Configuration Utility, see Extracting a Storage Control File from the DB2 Catalog. Ensure that you specify the following values:

   • Extract method. Select the Extract from Catalog option, not the Extract from Catalog and Merge with Template option
   • Database values. Specify database parameter values for your existing Siebel ASCII or EBCDIC database
   • Storage Control File. You can assign any name to the storage control file that is extracted, for example, storage_ascii.ctl or storage_ebcdic.ctl
5. Extract the schema.ddl file for your existing Siebel ASCII or EBCDIC database.

   Ensure that your existing ASCII or EBCDIC Siebel database and repository are synchronized, then extract the schema.ddl file for your database. The schema.ddl file contains the logical definitions for all Siebel tables and indexes for the current version of your schema and is used as an input parameter by the Database Configuration Wizard when you select the Unicode Migration option.

   1. Synchronize your Siebel database and repository using the Database Configuration Utility.

      For information on this task, see Synchronizing Siebel Repository Definitions and the Physical Siebel Schema.

      Ensure that you specify the following values:

      • Run Database Utilities option. Select the Synchronize Schema Definition option of the Database Configuration Wizard
      • Storage Control File. Specify the name of the storage control file that you extracted in Step 4, for example, storage_ascii.ctl or storage_ebcdic.ctl

        The Synchronize Schema Definition process generates the synchronized schema.ddl file and places it in the DBSRVR_ROOT\db2390 (Windows) or DBSRVR_ROOT/db2390 (UNIX) directory.

   2. Rename the schema.ddl file to one of the following, depending on the code page of your existing database:
      • ddl_ascii.ctl
      • ddl_ebcdic.ctl
6. Convert the storage control file to Unicode.

   Convert the storage control file you extracted in Step 4 to Unicode format using the Siebel Database Storage Configurator (dbconf.xls). The converted storage control file is then used as an input parameter by the Database Configuration Wizard when you select the Migrate to Unicode option. For information on completing this task, see Converting the Storage Control File to Unicode.