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) >

Running Load Jobs on the Target Database

Perform the following procedure to run load jobs on the target database.

To run loads to the target database

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



    The Siebel Upgrade Job Submission Menu for your upgrade path appears.

    • For Siebel Business application upgrades, the panel ID is SBLRUNHP.
    • For Siebel Industry application (SIA) upgrades, the panel ID is SBLRUNFP.
  3. Select option 3: LOAD TARGET.

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

  4. Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(SUBLOAD).

    This job automatically submits all the unload job streams referenced in dataset DSNHLQ.SIEBEL.EXEC(@DDLIMPL).

    This submits the Load job streams. The number of upgrade Load jobs varies by upgrade path. If you selected Siebel-Scheduled Mode, this job is logged (as Completed Successfully or Failed) to the target Siebel log table: TARGET_TABLEOWNER.TMP_SBLLOG_TAR.

  5. Verify job ran successfully, RC=0 or RC=4.

    Jobs with an ABEND (end abnormally) U99 or U099 message are jobs that failed.

    NOTE:  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.
  7. View the job status.

    For information on how to view job status if you selected Siebel-Scheduled Mode, see Viewing the Siebel Job Log Status.

Once all Load jobs have completed successfully, continue with the upgrade.

Upgrade Guide for DB2 UDB for z/OS