SQL System Properties

SQL system properties are key/value settings that are visible to every Transaction Engine (TE) or Storage Manager (SM) process and client connection in the database. They are stored persistently in the SYSTEM.PROPERTIES table (see PROPERTIES System Table Description) and are modifiable by the SET SYSTEM PROPERTY command (see SET).

Note: Only a user that has been granted the system ADMINISTRATOR role can modify system property values.