Upgrade Guide for DB2 UDB for z/OS > Upgrading a Database from the Mainframe > Executing the Upgrade on the z/OS 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 FINS 6.2.1, upgrades from SIA 7.0.4, 7.5.2 and 7.7.x, and upgrades from Release 7.x applications. To determine whether or not you need to run this procedure, check if the DSNLHLQ. SIEBEL.EXEC(@HHFIN) PDS member contains a job to be submitted; if it does, you will need to run this procedure.

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 appear.

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 Restarting Failed Jobs on the Mainframe.

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