Siebel Database Upgrade Guide for DB2 for z/OS > Upgrading the Target Database >

Creating and Loading Siebel Log Tables

Upgrades: All upgrades.

Environments: All environments.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

Perform the following procedure to create Siebel log tables and load them on the target database before you begin the target database upgrade.

To load the target log table

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

   TSO SBLUPG81

2. Select option 2: Target Database Processes - Pre-Upgrade, and press Enter.
3. Select option 0: Create & Load Target Siebel Log, and press Enter.
4. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(LOADTAR).

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

5. 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.
6. After submitting the job, enter cancel on the command line or press PF3 to save changes.