Upgrade Guide for DB2 UDB for z/OS and OS/390 > Upgrading a Database from the Mainframe > Executing the Upgrade on the zSeries Host (Phase 1 of 2) >

Migrating Household Data

Complete the following procedure to run corresponding Household SQL scripts against the target system.

NOTE:  This topic applies to upgrades from SIA 6.2.1, 7.0.4, and 7.5.2 applications. Perform this task only if you ran the corresponding Household script (Household_Mig_Fins.sql) on the source system during the development environment upgrade. (See Executing SQL Output Files After the Second Pause.)

To run the data migration Household SQL scripts

1. Locate the DSNHLQ.SIEBEL.INSTALL.JCL library in your dataset list.

   This is a PDS, so all PDS members are listed.

2. At the command line, locate PDS members that begin with HHMIG by using the following command:

   L HHMIGFIN

3. Edit the HHMIGFIN member of DSNHLQ.SIEBEL.INSTALL.JCL.

   This places you in edit mode on PDS member DSNHLQ.SIEBEL.INSTALL.JCL(HHMIGFIN).

4. Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(HHMIGFIN).
5. Verify that the job ran successfully, RC=0 or RC=4.

   Jobs with an ABEND (end abnormally) U99 or U099 message are jobs that failed.

   NOTE:  These jobs are not logged. You must fix any failed jobs before proceeding with the upgrade. For information on restarting failed jobs, see Running the Siebel Upgrade Wizard.

6. After submitting the job, enter cancel on the command line or press PF3 to save changes.