Siebel Database Upgrade Guide for DB2 for z/OS > Upgrading the Target Database > Performing the In-Place Target Database Upgrade >

Migrating Data on the Target Database

Perform the tasks described in this topic to migrate preexisting Siebel data to version 8.1 or 8.2 data. Generally, this involves inserting or updating values in the target tables, but new indexes might also be created and rebuilt.

There are optional data migration scripts for Household data and for Siebel Financial Services (FINS) applications. The scripts you must apply depends on the applications you have implemented and your upgrade path. Review Table 14 to determine the scripts that apply for your upgrade.

Use the following procedure to run each of the data migration scripts.

To run the data migration scripts

1. On the Target Database In-Place Upgrade Menu, select option 8: Data Migration Processes, and press Enter.

   The Target Database Data Migration Processes Menu appears. The panel ID is SBLDMP.

2. Select the appropriate option for the data migration script you want to run, for example, select option 2: Preschm, and press Enter, to run the preschm scripts.
3. You are placed in edit mode on one of the following data sets, depending on the option you select:
   • Household: DSNHLQ.SIEBEL.INSTALL.JCL(HHMIG)
   • Household - FINS: DSNHLQ.SIEBEL.INSTALL.JCL(HHMIGFIN)
   • Preschm: DSNHLQ.SIEBEL.INSTALL.JCL(SUBPSH)
   • Preschm - FINS: DSNHLQ.SIEBEL.INSTALL.JCL(SUBPSF)
   • UpgISS: DSNHLQ.SIEBEL.INSTALL.JCL(SUBUPGIS)
4. Run the data migration job using the JCL in the data set in which you have been placed. For example, if you selected option 3:Preschm, submit the JCL in the DSNHLQ.SIEBEL.INSTALL.JCL(SUBPSH) data set.

   This job automatically submits the first job in the job stream.

   If the first Household and Preschm data migration job completes successfully, it automatically submits all subsequent jobs in the that data migration process flow. The number of jobs that are run varies according to your upgrade path.

   If one of the automatically submitted job fails, the succeeding dependent job is not submitted and the automatic job submission sequence terminates. Correct the problem that caused the job failure and resubmit the individual failed job. When the job completes successfully, it then submits the next job in sequence.

5. Verify that the job ran successfully with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.

   Fix any failed jobs before proceeding with the upgrade. For information on restarting failed jobs, see Restarting Upgrade Jobs That Fail.

6. Press PF3 to return to the Target Database Data Migration Processes Menu and run the next data migration job in sequence.

About Migrating Preschm Data

Some of the PRESCHM jobs run independently but others are submitted in a defined order and cannot run until previous jobs have completed successfully; you can run the standalone jobs in parallel with those with dependencies. To see the serial flow of the PRESCHM jobs and the PRESCHM job dependencies, look at the PDS member DSNHLQ.SIEBEL.PRESCHM.JCL(@DEPFLOW).