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

Generating the Unicode Migration Files

When you have extracted the original schema ddl.ctl file and converted the storage control file to Unicode for your ASCII or EBCDIC database, run the Database Configuration Utilities to generate the new Unicode schema files at the midtier.

The Database Configuration Wizard builds the new schema by reading the current schema and making the necessary adjustments to data types to convert the schema to a Unicode format. The utility also builds the load and unload control cards required to perform the migration process on the z/OS host.

This task is a step in Roadmap for Migrating the Siebel Database to Unicode.

To generate the Unicode schema files

1. Launch the Database Configuration Wizard and follow the steps in Performing a Standard Installation until the Siebel Database Operation screen is displayed (Step 6).
2. From the Siebel Database Operation screen, select Run Database Utilities, and then click Next.
3. Select the Unicode Migration option, and click Next.
4. Choose the mode you want to use for the Unicode migration process.
   • Batch - Generate Unload/Load. Allows you to generate the Unicode migration files in batch mode. Select this option.
   • Foreground - Generate Insert/Select. Allows you to generate the Unicode migration files in foreground mode.
5. If you have installed more than one language pack onto the Siebel Server, the Base Language screen is displayed. Specify which language is the primary (base) language for the Siebel database, and click Next.
6. Enter the ODBC Data Source Name to connect to the target Unicode database. Click Next.
7. Enter the database user name for the target Unicode database. Click Next.
8. Enter the password associated with the database user name for the target Unicode database. Re-enter the password to confirm, then click Next.
9. Enter the Security Group ID/Grantee name, for example, SSEROLE, then click Next.
10. Enter the schema qualifier for the target database, and click Next.
11. On the Host/LPAR name where Target database resides screen, enter the name of the host and logical partition that will contain the new Unicode database to be migrated, for example ZM01. Click Next.
12. Enter your TSO account ID, then click Next.

    This account ID must have the authorization to allocate and create data sets on the z/OS host.

13. Enter the dataset high-level qualifier you want to use for the z/OS Unicode migration data sets, then click Next. Follow your organization's naming standards.
14. Enter the name of the directory where you want to save the migration DDL files generated. The default directory is DBSRVR_ROOT\db2390\dboutput\unicode_migration (Windows) or DBSRVR_ROOT/db2390/dboutput/unicode_migration (UNIX).

    Click Next.

15. Specify the schema.ddl file you generated in Step 5 (ddl_codepage.ctl), then click Next.
16. Enter the path and name of the storage control file you converted to Unicode (for example, storage_uni.ctl) as described in Converting the Storage Control File to Unicode.
17. Specify the name of the Log Output Directory and click Next.

    By default, the files are created in SIEBSRVR_ROOT\log\unicode_migration_mf (Windows) or SIEBSRVR_ROOT/log/unicode_migration_mf (UNIX).

18. Save the configuration information you have entered and launch the Siebel Upgrade wizard as described in the following topics:
    • Running the Database Configuration Wizard Under Windows
    • Running the Database Configuration Wizard Under UNIX
19. Click OK.

    The Upgrade Wizard creates a number of files in the output directory you specified.

20. Apply these files on your z/OS host as described in Transferring Migration Upgrade Files from the Midtier to the z/OS Host.