Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > 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 Siebel Tools Reference.
On DB2 UDB for OS/390 and z/OS 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
- Launch the Database Server Configuration Utility:
Choose Start > Siebel Enterprise Server 7.x.x > Configure DB Server.
or
- Open a command prompt.
- Go to the
SIEBSRVR_ROO
T
\BIN
directory.- Run the following command:
ssincfgw -l ENU -v Y
- In the screen that appears, select dbsrvr.scm.
- 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
- bumpver.sql
- Ask your DBA to apply the output files.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS Published: 18 April 2003 |