Implementing Siebel Business Applications on DB2 for z/OS > Migrating a Siebel Database to Unicode Format > Process of Performing the Database Unicode Migration >

Building the Target Schema

Complete the following procedure to build the target (Unicode) schema. When you have completed this task, you can then migrate data from the ASCII or EBCDIC schema to the Unicode schema.

This task is a step in the Process of Performing the Database Unicode Migration.

To build the target schema

1. On the Siebel Unicode Migration Option Menu, select option 2. Pre-Migration. The Unicode Pre-Migration Menu panel is displayed. The panel ID is SBLUPREP.
2. Select option 1. Build Target Schema to create the Unicode schema on the target database.
3. Submit the JCL in the data set DSNHLQ.SIEBEL.UNI.INSTALL.JCL(CRESCHEM).

   The Build Target Schema process creates the Unicode databases, table spaces, and tables in the target DB2 subsystem.

4. On the Unicode Pre-Migration Menu, select option 2. Verify Target Schema, and press Enter.

   The Unicode migration tool reads table information from the source and target schemas, and compares the schemas to ensure that they contain the same tables.

   Differences between the schemas are logged in the DSNHLQ.SIEBEL.UNI.DIFFRENT data set. Review this file and resolve the cause of any differences noted.

   NOTE:  Objects in the source schema that are defined as inactive in the repository are not built in the target schema.

   The build target schema process is now completed.