Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Customizing a Development Environment > Applying Schema Extensions to the Target Database >

Synchronizing Schema Definitions with the Existing Siebel Schema

The Synchronize Schema Definitions process is used to synchronize the repository definitions with the existing Siebel Schema database. Detailed information about this utility is provided in Using Siebel Tools.

On DB2 UDB for z/OS and OS/390 this process depends on the existing database physical layout and the contents of the storage control file. The resulting database storage layout will fully reflect 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

1. Launch the Database Server configuration wizard:

   Choose Start > Programs > Siebel Enterprise Server 7.x.x > Configure DB Server.

   or

   1. Open a command prompt.
   2. Go to the SIEBSRVR_ROOT\BIN directory.
   3. Run the following command:

      ssincfgw -l ENU -v Y

   4. In the screen that appears, select dbsrvr.scm.
2. Select the following options: Run Database utilities > Synchronize Schema Definitions > Generate DDL into files.

   When you generate DDL into files, two output files are generated in the default directory ($SIEBEL_ROOT\dbsrvr\DB2390\DBOUTPUT\DDLSYNC):

   • schema.sql
   • ddlview.sql
3. Ask your DBA to apply the output files.