Implementation of Additive Schema Changes

You generate the Additive Schema Changes script by starting the Database Configuration Utilities and choosing Apply Additive Schema Changes. A wizard prompts you for environment information similar to other upgrade modes.

After you review and confirm your entries, the wizard populates the file platform\driver_additive_gen.ucf. In this path, platform is the database type (DB2, MSSQL, or Oracle).

The Upgrade Wizard then performs the following steps:

• Reads the master_additive_gen.ucf file to obtain environment information and the name of the driver file.

• Reads the driver_additive_gen.ucf file and executes the ddlimp2 command it contains.

• The ddlimp2 command performs the following steps:

  • Reads the tables and indexes from the schema.ddl file.

  • Connects to the specified database and reads the existing schema and indexes.

  • Identifies the upgrade schema changes that can be made with the database online.

  • Writes these upgrade changes to the schema.additive.sql script.

  • Writes all actions to schema.additive.log.

The Upgrade Wizard does not execute schema.additive.sql against the database.