derby.database.propertiesOnly

Function

When set to true, this property ensures that database-wide properties cannot be overridden by system-wide properties.

When this property is set to false, or not set, database-wide properties can be overridden by system-wide properties (see Precedence of Properties).

This property ensures that a database's environment cannot be modified by the environment in which it is booted.

This property can never be overridden by system properties.

Default

False.

Examples

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
    'derby.database.propertiesOnly','true')

Dynamic or static

This property is dynamic; if you change it while Derby is running, the change takes effect immediately. For information about dynamic changes to properties, see Dynamic or Static Changes to Properties.