Upgrade Custom Database Schema (upgphys)

1. Run the Database Configuration Wizard to extract the storage control file from the target database as follows:

   • Specify the following values when prompted to do so:

     • Extract Options: Extract from Catalog.

     • Storage Control File: Specify the name of the storage control file to be extracted. You must specify the name storage_postupg.ctl.

   • Make sure you specify values for the target database when prompted for the names of the schema qualifier, ODBC data source, and database user name and password.

     The procedure to extract a storage control file using the Extract from catalog option is described in Implementing Siebel Business Applications on DB2 for z/OS. The extracted target database storage control file is used as input to the upgphys upgrade process.

2. Run the Database Configuration Wizard to complete the development environment upgrade:

   • Choose the following settings:

     • Environment Type: Development.

     • Upgrade Options: Upgrade Custom Database Schema (upgphys).

     • Storage Control File: The storage control file that you generated in step 1.

     • Make sure you specify values for the target database when prompted for the names of the schema qualifier, ODBC data source, and database user name and password.

       Launch the Siebel Upgrade Wizard. SQL commands are executed on the development environment database and a number of output files are generated.

3. Transferring the Development Environment Upgrade Output Files to the z/OS Host.

4. Synchronizing the Schema.

5. About the Siebel Upgrade Log Files.

6. If the upgrade contains unacceptable errors, do the following:

   1. Restore the backup of the database.

   2. Correct the errors.

   3. Rerun the Database Configuration Wizard.

7. Manually Archiving Upgrade Log Files.

8. Back up the upgraded database.

9. Deleting Redundant Upgrade Files.