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
- Locate the
DSNHLQ .SIEBEL.INSTALL.JCL library in your dataset list.
This is a PDS, so all PDS members are listed.
- At the command line, locate PDS members that begin with HHMIG by using the following command:
L HHMIGFIN
- Edit the HHMIGFIN member of
DSNHLQ .SIEBEL.INSTALL.JCL .
This places you in edit mode on PDS member DSNHLQ .SIEBEL.INSTALL.JCL(HHMIGFIN) .
- Run the job using the JCL in dataset
DSNHLQ .SIEBEL.INSTALL.JCL(HHMIGFIN) .
- 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.
- After submitting the job, enter
cancel on the command line or press PF3 to save changes.
|