Siebel Database Upgrade Guide for DB2 for z/OS > Upgrading the Target Database > Performing the In-Place Target Database Upgrade >

Running the PRET Jobs for the Target Database

Perform the following procedure to run the PRET jobs to prepare the target database for table creation during the in-place upgrade.

To run the PRET jobs

1. On the Target Database In-Place Upgrade Menu, select option 3: Pret, and press Enter.
2. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(SUBPRET).

   This triggers the first PRET job, which then automatically submits the next PRET job in sequence. The number of PRET jobs that are automatically submitted varies according to your upgrade path.

3. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the return code is 0 and that the JCLTEST return code is FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
4. After submitting the job, enter cancel on the command line or press PF3 to save changes.

   All jobs must complete successfully before you proceed to the next step.

5. On the Target Database In-Place Upgrade Menu, select option 4: PretFINS, and press Enter.
6. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(SUBPRETF).

   This triggers the first PRET job, which then automatically submits the next PRET job in sequence. The number of PRET jobs that are automatically submitted varies according to your upgrade path.

   NOTE:  You only have to perform this step if you are performing an Siebel Industry Applications upgrade.

7. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the return code is 0 and that the JCLTEST return code is FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
8. After submitting the job, enter cancel on the command line or press PF3 to save changes.

   All PretFINS jobs must complete successfully before you proceed to the next step.