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

Running the Gen_Primary SQL to Update Data in Target Database Tables

The Gen_Primary data migration jobs apply changes to primary child columns that are required for the upgrade to the target database tables. The following procedure outlines the steps to follow to run the Gen_Primary jobs.

NOTE:  If you are upgrading to Siebel Industry Applications 8.1 from Siebel Industry Applications 8.0, there are no changes to primary child columns in database tables. As a result, the gen_primaryx.jcl upgrade files generated on the midtier platform do not contain any SQL commands, and do not have to be run, for this upgrade path.

To run the Gen_Primary SQL

1. On the Target Database In-Place Upgrade Menu, select option 10: Gen_Primary Data Migration, and press Enter.

   You are placed in edit mode on data set DSNHLQ.SIEBEL.INSTALL.JCL(SUBGENP).

2. Submit the JCL in the data set to update data in the target tables.

   This submits all the Gen-Primary data migration job streams (the number of job streams varies by upgrade type). All of the jobs are run in parallel as no dependencies exist between them.

3. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the return code is 0 or 4 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.