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 eChannel Data

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

NOTE:  This topic applies to upgrades from Release FINS 6.2.1 applications. Perform this procedure only if you ran corresponding eChannel scripts on the source system during the development environment upgrade.

To run the data migration eChannel 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 ECHM by entering the following command:

   L ECHM

   The following PDS members appear in the list:

   • ECHMCON
   • ECHMORG
3. Enter E next to the PDS members that apply to your upgrade path.

   This places you in edit mode on individual PDS members.

4. Run this job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(ECHM*).
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.

   This places you in edit mode on the next PDS member.