SCHEMA-CHANGE attribute

Relaxes the requirement for exclusive access to a database in order to make the following schema changes online:

Add new sequences.

Add new tables, as well as any associated fields, indexes, and database triggers (which must be added within the same transaction).

Add new fields to an existing table. (You cannot define ASSIGN triggers for new fields while the database is online.)

Add new inactive indexes to an existing table.

Data type:

CHARACTER

Access:

Readable/Writeable

Applies to:

SESSION system handle

Set this attribute to “NEW OBJECTS” to activate this feature; and to the empty string ("") or the Unknown value (?) to deactivate this feature.