1. Database Upgrade Guide for DB2 for z/OS
  2. Validating the Extracted Storage Control File

Validating the Extracted Storage Control File

When you have extracted your existing database storage control file and merged it with a Siebel CRM template in preparation for the upgrade, you must validate the storage control file. (You must also validate the storage control file any time you modify it.) The validation process checks that the tables are the correct length for the target schema. Do not proceed with the upgrade until the validation process runs without error.

This task is a step in Process of Preparing the Storage Layout of the Schema.

The following procedure describes how to validate the storage control file you extracted and merged as described in Extracting the Storage Control File.

To validate the storage control file

  1. Run the Database Configuration Wizard.

    The procedure to validate a storage control file using the Database Configuration Wizard is also described in Implementing Siebel Business Applications on DB2 for z/OS.

  2. Specify the following values:

    1. On the Database Configuration Options screen, select the Validate Storage File option.

    2. On the Data Transport Method screen, select the Batch - Generate Unload/Load option.

    3. On the following screens, make sure you specify values for the staging database:

      • ODBC Data Source Name

      • Database User Name

      • Siebel Schema Qualifier

    4. On the Schema File screen, specify the following values:

      • Schema File: Specify the directory path and filename of the file against which the extracted file is to be validated. For development environment upgrades, specify the ddl.ctl file. For production environment upgrades, specify the schema.ddl file.

      • Storage Control File: Specify the name of the storage control file you extracted and merged in Extracting the Storage Control File. For development environment upgrades, specify storage_upg_dev.ctl. For production environment upgrades, specify storage_upg_prod.ctl.

  3. When you have entered all the required values and reviewed them, launch the Siebel Upgrade Wizard to start the validation process. See Running the Database Configuration Wizard.

  4. When validation completes, review the log files, upgwiz.log and schema.log, that are generated in the SIEBEL_ROOT\LOG\dbconfig_validate_mf\output directory (Windows) or the SIEBEL_ROOT/LOG/dbconfig_validate_mf/output directory (UNIX).

    If any validation errors occurred, correct them, and then run the validation process again.

    Note: For information about the other files (such as, sql and ldc) that are generated during this process, see Siebel CRM z/OS Upgrade Files.