Bookshelf Home | Contents | Index | PDF     

Implementing Siebel Business Applications on DB2 UDB for z/OS > Customizing a Development Environment > Process of Applying Schema Extensions to the Target Database >

Synchronizing Schema Definitions with the Existing Siebel Schema

To synchronize the Siebel repository database definitions with the existing Siebel Schema database, use the Synchronize Schema Definitions utility. Detailed information about this utility is provided in the Using Siebel Tools guide.

On DB2 for z/OS, this process involves the existing database physical layout and the contents of the storage control file. The resulting database storage layout reflects storage control file settings.

When you synchronize repository definitions with the existing Siebel Schema, the following data sources are accessed:

  • Siebel Repository
  • Storage control file
  • DB2 catalog

To synchronize schema definitions under Windows

  1. Launch the Database Server Configuration utility and follow the steps in Performing a Standard Installation Under Windows until the Siebel Database Operation screen (Step 6) is displayed.
  2. Select the Run Database Utilities option.
  3. Select the Synchronize Schema Definition option.
  4. Enter the ODBC data source name and the source database DB2 SubSystem name.
  5. Enter the database user name and password, and then enter the password again to confirm it.
  6. Specify the Siebel Schema qualifier in uppercase and the security group ID.
  7. Specify the Repository Synchronization Mechanism, in this case, select the Generate DDL into Files option.
  8. On the Commit Frequency screen, choose the number of DDL statements that can be run before a COMMIT statement is issued.
  9. Enter the name of the output directory where the DDL is to be created and the path and name of the storage control file to use in the synchronization process.
  10. Enter the name of the Repository with which the existing Siebel database is to be synchronized.
  11. Enter the directory where log files are to be created or accept the default directory, ddlsync_mf.
  12. When the runnow message appears, indicate whether you want to apply the configuration now or later. Click OK to continue.
  13. Review the configuration parameter values. If these values are correct, click Finish to apply the configuration.
  14. If you have to cancel the configuration or encounter problems and want to rerun the configuration at a later time, navigate to the SIEBSRVR_ROOT\bin directory and enter the following from the command line:

    siebupg.exe /m master_ddlsynch_mf.ucf

    When you synchronize schema definitions using the Generate DDL into files option, two output files are generated in the default directory, SIEBEL_ROOT\dbsrvr\db2390\dboutput\ddlsync, after the synchronize schema definition configuration is completed:

    • schema.sql
    • ddlview.sql
  15. Ask your DBA to apply these files.

To synchronize schema definitions under UNIX

  1. Launch the Database Server Configuration utility and follow the steps in Performing a Standard Installation Under UNIX, until the Siebel Database Operation screen is displayed (Step 9).
  2. Select option 5- Run Database Utilities.
  3. Select option 1- Synchronize Schema Definition.
  4. On the Language Selection screen, indicate the language in which the database is run.
  5. Enter the ODBC data source name and the source DB2 SubSystem name.
  6. Enter the database user name and password.
  7. Specify the Siebel Schema qualifier in uppercase and the group authorization ID.
  8. Specify the repository synchronization mechanism, in this case, select option 1- Generate DDL into a File.
  9. On the DDL Commit Frequency screen, choose the number of DDL statements that can be run before a COMMIT statement is issued.
  10. Enter the name of the output directory where the DDL is to be created and the path and name of the storage control file to use in the synchronization process.
  11. Enter the name of the repository with which the existing Siebel database is to be synchronized.
  12. Specify the directory where log files are to be created; the default is ddlsynch_mf.
  13. Review the configuration parameter values and enter 1 (Yes) to launch the Siebel Upgrade Wizard (srvrupgwiz).

    NOTE:  If you want to rerun the Upgrade Wizard at a later time, navigate to the $SIEBSRVR_ROOT/bin directory and enter:

    srvrupgwiz /m master_ddlsynch_mf.ucf

    When you synchronize schema definitions using the Generate DDL into a File option, two output files are generated in the default directory, $SIEBEL_ROOT/dbsrvr/db2390/dboutput/DDLSYNC, after the synchronize schema definition configuration is completed.

    • schema.sql
    • ddlview.sql
  14. Ask your DBA to apply these files.
    
Implementing Siebel Business Applications on DB2 UDB for z/OS