1. Implementing Siebel Business Applications on DB2 for z/OS
  2. Submitting the Unicode Migration Jobs

Submitting the Unicode Migration Jobs

When you have built your Unicode schema and generated the migration jobs, you can migrate data from the ASCII or EBCDIC Siebel schema to the new Unicode schema by submitting the appropriate DB2 Cross Loader jobs. Then you must create indexes for the new Unicode tables. This topic describes how to perform both of these tasks, and how to generate statistics for the new Unicode schema.

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

Note: Ensure that all of the pre-migration jobs have completed successfully before you submit the Unicode migration jobs described in this topic.

To submit the Unicode migration jobs

  1. On the Siebel Unicode Migration Option Menu, select option 3. Migration, and press Enter. The Unicode Migration Menu is displayed (the panel ID is SBLUMIGP). The options on the Unicode Migration Menu are used to submit the jobs that perform the schema Unicode migration.

    Submit the jobs in the sequence in which they are listed on the menu. The indexes are built after the Cross Loader jobs are completed for performance reasons. If the indexes are built before the Cross Loader jobs are run, the load jobs take much longer.

  2. Select option 1. Submit Cross Loader Jobs, and press Enter. The Cross Loader jobs migrate the data from the source to the target Unicode database.

  3. Submit the JCL in the data set DSNHLQ.SIEBEL.UNI.INSTALL.JCL(SUBXLOAD).

    If one of the Cross Loader jobs ends abnormally during the data migration process, restart the job as described in Resubmitting Cross Loader Jobs.

    When all the jobs are successfully executed, the Unicode tables are loaded with data from the source schema.

  4. To create unique, nonunique, and obsolete indexes for the loaded Unicode tables, select option 2. Build Indexes, and press Enter.

  5. Submit the JCL in the data set DSNHLQ.SIEBEL.UNI.INSTALL.JCL(CRESCHIX).

  6. Verify that the job ran successfully (RC is 0 or RC is 4).

    Indexes are created on the tables in the Unicode schema.

  7. To populate the indexes, select option 3. Submit Rebuild Index Jobs, and press Enter.

  8. Submit the JCL in the data set DSNHLQ.SIEBEL.UNI.INSTALL.JCL(CRESCHEM).

  9. Verify that the job(s) ran successfully (RC is 0 or RC is 4).

    The indexes on the Unicode schema are rebuilt.

  10. To collect statistics for the table spaces in the new Unicode schema, select option 4. Submit RunStat Jobs, and press Enter.

  11. Submit the JCL in the data set DSNHLQ.SIEBEL.UNI.INSTALL.JCL(SUBRUNST).

    Verify that the job(s) ran successfully (RC is 0 or RC is 4). RUNSTATS jobs are run on all table spaces in the Unicode schema.

  12. Press PF3 to save changes and return to the Siebel Unicode Migration Option Menu.

    The Unicode migration process is now completed.