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

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

NOTE:  This topic applies to upgrades from Release SIA 6.2.1 applications. Perform this procedure only if you ran corresponding eChannel scripts on the source system during the development environment upgrade. (See Executing SQL Output Files After the Second Pause.)

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 are listed.

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 Running the Siebel Upgrade Wizard.

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.