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


The Address Migration job corresponds to scripts run previously on the midtier against the Source system. This means that you only need to run the following job if you ran the midtier Address Migration script (rpt_dup_addr_rowids.sql) and applied the midtier procedures previously noted for rowids identified by this script. Otherwise, you do not need to run this job. For further information, see Preparing Address Data for Upgrade.

Upgrades:

  • Release 6.2.1 and 7.0.x of Siebel Financial Services applications to Release 7.8.x of Siebel Industry applications.
  • Release 7.8.x of Siebel Business Applications to Release 7.8.x of Siebel Industry Applications.

To run address data migration SQL scripts

  1. If you are not on the Siebel Upgrade Main Menu, enter the following command:

    TSO SBLUPG78

  2. Select option 4: RUN UPGRADE / POST-UPGRADE MAINTENANCE.

    The panel ID is SBLRUNFP.

  3. Select option 7: ADDRESS MIGRATION.

    This places you in edit mode for dataset DSNHLQ.SIEBEL.INSTALL.JCL(ADMIGFIN).

  4. Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(ADMIGFIN).
  5. Submit the job and then press Enter.
  6. 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.

  7. After submitting the job, enter cancel on the command line or press PF3 to save changes.
Upgrade Guide for DB2 UDB for z/OS