Implementing Siebel Business Applications on DB2 for z/OS > Customizing a Development Environment >
Synchronizing Siebel Repository Definitions and the Physical Siebel Schema
To synchronize the Siebel Repository database definitions and the existing physical Siebel database, use the Synchronize Schema Definition option of the Database Configuration Wizard.
When you synchronize repository definitions and the existing Siebel Schema, the following data sources are accessed:
- Siebel Repository
- Storage control file
- DB2 catalog
When you run the Synchronize Schema Definition option, be aware of the following:
- Custom columns in the Siebel Schema that are not in the Siebel Repository are not deleted
- Custom indexes in the Siebel Schema that are not in the Siebel Repository are deleted
NOTE: It is recommended that you use the SQL DROP command to remove EIM tables before synchronizing the Siebel logical and physical schemas to ensure that the synchronization process does not fail when processing EIM tables.
To synchronize Siebel schema definitions
- Launch the Database Configuration Wizard and follow the steps in Performing a Standard Installation until the Siebel Database Operation screen (Step 6) is displayed.
- Select the Run Database Utilities option, and click Next.
- Select the Synchronize Schema Definition option, and click Next.
- Identify the appropriate database encoding method, and click Next.
- Specify the code page encoding scheme for your Siebel database, either ASCII or EBCDIC, and click Next.
- On the Siebel Tools Directory and Tools DSN screen, enter the directory where Siebel Tools is installed. Oracle reccomends that you do not select the BIN folder.
This step is required when schema changes are made so that the changes are published into the Runtime Repository.
- On the Language Selection screen, select the language in which the database runs, and click Next.
- Enter the ODBC data source name to use to connect to the database, and click Next
- Enter the source database DB2 subsystem name, then click Next.
- Enter the database user name. Click Next.
- Enter the password associated with the database user name, then enter the password again to confirm it. Click Next.
- Enter the Siebel schema qualifier in uppercase, and click Next.
- Enter the name of the security group ID/Grantee, and click Next.
- Specify the Repository Synchronization Mechanism, in this case, select the Generate DDL into Files option, and click Next.
- On the Commit Frequency screen, choose the number of DDL statements that can be run before a COMMIT statement is issued, and click Next.
- Enter the name of the output directory where the DDL is to be created, then click Next.
By default, the DDL output directory is DBSRVR_ROOT
\db2390\dboutput\ddlsync (Windows) or
/db2390/dboutput/ddlsync (UNIX). Click Next.
- Enter the path and name of the storage control file to use in the synchronization process. Alternatively, use the Browse button to locate this file, then click Next.
- Enter the name of the Repository with which the existing physical Siebel database is to be synchronized. Click Next.
- Enter the name of the directory where the log files are to be created, and click Next.
By default, the files are created in SIEBSRVR_ROOT
\log\ddlsync_mf (Windows) or
- Save the configuration information you have entered and launch the Siebel Upgrade wizard as described in the following topics:
- If you selected the Run DDL Automatically installation option, the Siebel Upgrade Wizard applies the DDL commands to synchronize the Siebel database with the Repository directly against the database on the z/OS host. When you receive a message stating that the configuration was applied successfully, click OK. This step completes the Run DDL Automatically synchronization option
- If you selected the Generate DDL Into Files installation option, the Siebel Upgrade Wizard generates the following files into the output directory that you designated in Step 19 after the synchronize schema definition configuration is completed: