Applying Siebel Additive Schema Changes

Environments: Test, Production.

Platforms: Windows, UNIX, IBM z/OS.

You can run Database Configuration Utilities in Apply Additive Schema Changes mode. This generates a schema.additive.sql script that makes schema changes to the Siebel database schema. You do not have to take the database offline to apply this script.

Applying this script to your production database reduces the number of upgrade steps that must be performed while the production database is offline. This reduces production database downtime during the upgrade.

The recommended method for using this feature is to first test it in the test environment as part of upgrade tuning. After verifying that schema.additive.sqldoes not adversely affect the operation of the application, you then run the script against the production database.