Running Unload Jobs on the Target Database

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

To run unload jobs on the target database

1. On the Target Database Non-Additive Processes menu, select option 1: Unload Schema, and press Enter.

2. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(SUBUNLD).

   This job submits all the Unload jobs to run in parallel. The number of Unload jobs run varies according to your upgrade path.

3. Verify that each Unload job ran successfully.

   • Verify that each job ran successfully with a return code of 0. For information, see Verifying JCL Upgrade Jobs.

   • Review unload jobs that generate a return code of 4. A return code of 4 might be returned if a table is empty but it can also indicate that an unload job has failed as a result of DSNTIAUL utility CCSID conversion errors. For additional information, see About DSNTIAUL CCSID Conversion Errors.

     If the DSNTIAUL utility encounters an unload job that generates a CCSID conversion error, it generates a return code of 4 and stops the unload process at that point. Exit from the upgrade process and use a program, such as the IBM DB2 UNLOAD utility, to complete the load and unload processing.

     You must fix any failed jobs before proceeding with the upgrade. For information on restarting failed jobs, see Restarting Upgrade Jobs That Fail.

4. After submitting the job, enter cancel on the command line or press PF3 to save changes.

5. View the job status log.

   You can view the job status log by completing the procedure described in Running SQL in Siebel Logs.