Upgrade Guide for DB2 UDB for z/OS > Upgrading a Database from the Mainframe > Executing the Upgrade on the z/OS Host (Phase 2 of 2) >

Loading Target Siebel Log Tables


Perform the following procedure to load target Siebel log tables. The first time you perform this procedure, it loads load jobs and unload jobs. The second time you perform it, it loads logging records for the new schema indexes (GEN PRIMARY indexes).

To load target Siebel log tables

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

    TSO SBLUPG78

  2. Select option 5: UPGRADE - RUN UPGRADE/POST-UPGRADE MAINTENANCE.

    The Siebel Upgrade Job Submission Menu appears.

    • For Siebel Business application upgrades, the panel ID is SBLRUNHP.
    • For Siebel Industry application (SIA) upgrades, the panel ID is SBLRUNFP.
  3. Select the option for the application you are upgrading.
    • For Siebel Business application upgrades, select option 9: LOAD TARGET LOG (2 of 2).
    • For Siebel Industry application (SIA) upgrades, select option 12: LOAD TARGET LOG (2 of 2).

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

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

    This loads the target Siebel log table using logload file DSNHLQ.SIEBEL.JOBLOG.LOADFILE.

    After the job is run, verify that the job ran successfully. (RC=0 or RC=4 indicates that the job was successful.)

  5. After submitting the job, enter cancel on the command line or press PF3 to save changes.
Upgrade Guide for DB2 UDB for z/OS