Siebel Database Upgrade Guide for DB2 for z/OS > Generating the Siebel Upgrade Files >

Building JCL Templates for the Target Database

Perform the following procedure to build the JCL templates for the target database.

To build JCL templates for the target database

1. On the Staging Database File Generation Menu, select option 7: Build Target Database JCL Templates, and press Enter.

   This option applies target database LPAR, Tableowner and STORGROUP values to the JCL templates that were created to run the preupgrade and upgrade (in-place) processes for the staging database so they are appropriate for the target database upgrade.

2. Submit the JCL in one of the following data sets:
   • For Siebel Industry Application (SIA) upgrades, use DSNHLQ.SIEBEL.INSTALL.JCL(ALLSIAS)
   • For Siebel Business Applications upgrades, use DSNHLQ.SIEBEL.INSTALL.JCL(ALLHORS)
3. Verify that the job ran successfully with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.
4. After submitting the job, enter cancel on the command line or press PF3 to save changes.
5. Press PF3 twice to return to the Staging Database File Generation Menu.

   When you successfully complete the target database file generation process, the File Generation option (1) on the Siebel In-Place Upgrade Main Menu is no longer available. You are now ready to start the target database pre-upgrade and upgrade processes.