Setting Database Options for Managed Databases

Database options are key/value pairs representing either overall database level options or options specifically governing TE and SM processes. The default templates contain very few default options. When creating a database, you can add additional options that will be applied to all processes of the database or you can add database options that will only apply to certain process groups. A process group is a combination of an optional region and either "TEs" or "SMs", meaning all transaction engines in one or all regions or all storage managers in one or all regions.

For a description of each database option, see Database Options.

All database level options will be set for all TEs and SMs in the database.

You can use these tools to set and modify database options:

Also see: Precedence for Database Process Options